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 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 ...
How to Import Tables From Wikipedia Into Excel
You can import a lot of different data into your Excel spreadsheet. In this post, I'll show you how you can get tables from Wikipedia both manually and with th ...
How to Print Graph / Grid Paper in Excel
An Excel spreadsheet has lines and displays like a grid. And rather than buying graph or grid paper, you can print it out yourself and customize it. Below, I'l ...