Helping You Excel!
Sign up to our newsletter and get the latest Microsoft Excel tips straight to your inbox!
Get access to all the workbook downloads to follow along and learn the in demand tools that will help you be more efficient in your work and more valuable in the workforce.
Welcome!
John MacDougall
I’m John, and my goal is to help you master Excel!
You’ll find a ton of awesome tips, tricks, tutorials, templates and other great stuff here to help you save time and effort in your work.
Latest Posts
SUBSTITUTE function
What Does It Do? This function will allow you to find and replace a piece of text within a text string. You can...
Getting Started
So you're new to Excel and have heard how great it is for calculations, data analysis, creating charts and graphs and...
How To Conditionally Concatenate A Range
Excel has some great built in functions for summing and counting conditionally based on given criteria, but to...
HLOOKUP funtion
This function is similar to VLOOKUP but allows you to look up a value in the first row of a range and return the...
ROW function
This function will return the row number of the cell referenced. Syntax ROW(Range) Range (optional) - This is a single...
COLUMN function
This function will return the column number of the cell referenced. Syntax COLUMN(Range) Range (optional) - This is a...
Latest Templates
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃
