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 tips, tricks, tutorials, templates and other great stuff here to help you save time and effort in your work.
Latest Posts
8 Ways to Remove Conditional Formatting in Microsoft Excel
Suppose, your data changed, you're looking for different formatting criteria, or the worksheet is becoming too...
6 Ways to Remove #DIV/0! Errors in Microsoft Excel
Suppose you've copy pasted raw data into a Microsoft Excel worksheet template containing calculated cells. Often you...
6 Best Ways to Create Organizational Chart in Microsoft Excel
Don't know how to create an organizational chart in Microsoft Excel? Let me describe to you the top methods in simple...
9 Best Ways to ZIP an Excel File
Do you need to ZIP an Excel file to benefit from file compression to enhance storage efficiency, facilitate smoother...
5 Ways to Extract Year From Date in Microsoft Excel
Do you need to extract years from dates in Excel for data preprocessing or feature engineering? You've come to the...
6 Ways to Assign Letter Grades in Microsoft Excel
Have you ever found yourself facing the formidable task of assigning letter grades to a vast array of scores? Whether...
Latest Templates
Rent Roll Template for Microsoft Excel
When a landlord is renting out properties to tenants, he or she needs a way to keep track of the details of those...
A Countdown Timer for Microsoft Excel
Have you ever wished you had a dynamic countdown timer in your Excel workbook? A countdown timer is great for creating...
Simple To Do List Template in Microsoft Excel
Everyone has stuff to do and Excel is a great tool to keep track of it all. This is a To Do List template to help keep...
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 😃
