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 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...
5 Ways to Redact in Microsoft Excel
Do you want to learn how to redact in Microsoft Excel? Follow along with the methods listed here. If you've ever...
How to Convert Degrees to Radians in Excel
Do you need to Convert Degrees to Radians in your Excel Report or dashboard? This article will show you all the...
5 Ways to Convert a Date to a Number in Microsoft Excel
Are you wondering how to convert a date to a number in Microsoft Excel? Keep reading! Whether you're calculating...
3 Ways to Add a DRAFT Watermark in Microsoft Excel
Do you need to add a watermark to your Excel worksheet? A watermark is a semi-transparent logo, image, or text written...









