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
4 Ways How to Calculate Sharpe Ratio in Microsoft Excel
Follow along with me in this effortless Microsoft Excel tutorial to learn how to calculate the Sharpe Ratio in...
3 Ways To Randomly Select a Winner in Microsoft Excel
Do you want to find out how to randomly select a winner in Microsoft Excel? Keep reading! Think of managing an...
4 Ways To Run Macro When Opening Microsoft Excel
Today, I'll show you how to run a macro when opening Microsoft Excel. Imagine you’re preparing for a weekly sales...
5 Ways To Add Draft Watermark in Microsoft Excel
If you want to learn how to add a draft watermark in Microsoft Excel, follow along with the methods described in this...
5 Ways To Save One Sheet as a PDF in Microsoft Excel
Today, you'll learn how to save one sheet in Microsoft Excel as a PDF. Often, you need to wrap up client reports and...
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...









