Sign Up for the FREE Excel Newsletter
Sign up for the Excel newsletter and get access to 4 eBooks, templates, and all the example workbooks used on this website and my YouTube channel.

đ Your information is safe with me. đ§ You can unsubscribe at any time.
The Formula for Success!

I’ve been there before. At the start of my career I struggled through Excel just like you and made plenty of mistakes along the way.
But I realized Excel could be the key to my success if I could master this tool.
Hello, I’m John MacDougall, Microsoft MVP and expert in Excel with years of experience helping professionals like you demystify advanced Excel features. I’m here to guide you in your journey to Excel proficiency.
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.
Courses
Advanced Formulas
Unlock the power of advanced Excel functions such as LET and LAMBDA and gain a competitive edge in your career.
Pivot Table Masterclass
Master data analysis in Excel with our comprehensive masterclass. Transform your data into insights with ease!
Dashboard Practise Pack
Build stunning, interactive, professional dashboards that will impress your boss with our hands-on exercise pack!
Latest Posts
6 Ways to Copy Values and Number Formatting in Microsoft Excel
Today, you'll learn how to copy values and number formatting in Microsoft Excel. Working in Microsoft Excel to analyze...
6 Ways to Autofit Rows in Microsoft Excel
Learn how to autofit rows in Microsoft Excel in tried and tested ways. If youâve worked on a client report or...
4 Ways to Apply the Percentage Number Format in Microsoft Excel
Today, you'll learn how to apply the Percentage number format in Microsoft Excel. Ever stared at a spreadsheet, trying...
6 Ways to Move a Sheet in Microsoft Excel
Learn how to move a sheet in Microsoft Excel in various proven methods for different challenging situations. Moving a...
18 Keyboard Shortcuts Every Accountant Needs To Know
Accounting is hard enough! Excel doesnât have to be. These are the only shortcuts youâll ever need. If youâre like me,...
3 Ways To Print Column Headings in Microsoft Excel
Today, you'll learn how to print column headings in Microsoft Excel on every sheet of paper you print. If youâve ever...