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
How to Use the COPILOT Function in Microsoft Excel
Wondering if you could use the mighty Copilot AI from Microsoft in your Excel workbooks to think and work faster? I've...
5 Ways to Get Rid of Extra Spaces in Microsoft Excel
Today, you'll learn how to get rid of extra spaces in Microsoft Excel. This is a valuable skill to acquire. Stick to...
5 Ways to Make Columns the Same Width in Excel
Follow along with the methods below to learn how to make Microsoft Excel columns the same width. When I look at a...
5 Ways to Make Rows the Same Size in Microsoft Excel
Do you want to find out how to make rows the same size in Microsoft Excel? You've come to the right place. Keep...
How to Change A1 to R1C1 Reference Styles in Excel
Two types of cell references in Excel. A1 is the default reference style. Most Excel users do not know about...
How to Reverse Numbers in Excel
Do you need to reverse a number in your report or dashboard? This blog post cover 8 advanced methods to reverse...









