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 tipstricks, tutorials, templates and other great stuff here to help you save time and effort in your work.

Latest Posts

SUMIFS function

This function will conditionally sum up numbers in a range based on given criteria. Syntax SUMIFS(Sum Range, Range 1,...

read more

ABS function

This function will return the absolute value of a number. The absolute value is the "positive" part of a number....

read more

PROPER function

This function will function will capitalize the first letter of each word. Syntax PROPER(Text) Text (required) - This...

read more

UPPER function

This function will convert text to all uppercase letters. Syntax UPPER(Text) Text (required) - This is the text string...

read more

LOWER function

This function will convert text to all lower case letters. Syntax LOWER(Text) Text (required) - This is the text...

read more

RIGHT function

This function will return the right most characters of a text string based on a number specified. Syntax...

read more

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 😃