Want to get better at Excel?
This site will help you...
New content every week on this site and on social media
Recent posts
How to Create a Stock Heat Map in Google Sheets
Heat maps can help you easily identify high and low values. You'll often find them to display stock prices to show which stocks did well, and which ones didn't ...
Free Calendar and Task Manager Template
It's a new year and with the help of a good calendar, you can ensure you stay on top of not only your deadlines and tasks but goals as well. I have a free temp ...
How to Autofill in Excel: A Step-by-Step Guide
Autofill is one of Excel's most powerful tools, helping you quickly and efficiently populate cells with data, formulas, or patterns. Whether you're entering da ...
How to Fix #N/A Errors in Excel
Excel is a powerful tool, but even the most experienced users encounter errors like #N/A from time to time. This error can be frustrating, but it’s actually Ex ...
How to Calculate Running Totals in a Pivot Table
Pivot tables in Excel are useful for summarizing data. But you can do more than just simple summations and can also calculate running totals based on multiple ...
Calculate Trailing 12 Month (TTM) Values in Excel
Calculating trailing-12 month values, also known as TTM, can be a powerful way to analyze financial or business data over the most recent year. This method foc ...
Add Horizontal Lines to Stock Charts to Identify Min and Max Values in Excel and Google Sheets
If you're pulling in stock prices into your spreadsheet, you can easily plot those values on a chart. And one way to help visualize the data is to add horizont ...
Dynamic Calendar Template and Organizer for Excel
Do you want to track deadlines and have an easy place to manage all your upcoming tasks and bills? In this post, I'm going to share with you my Dynamic Calenda ...