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 Use Compare Mode in Google Sheets
If you're creating a chart on Google Sheets, there's a really useful feature you can use which makes it easy to compare values, and that's compare mode. In thi ...
Quickly Add Rows and Columns in Google Sheets
Google Sheets is a powerful and versatile tool for managing data, whether you're tracking expenses, analyzing survey results, or organizing information for a p ...
Create an Automatically Updating Pivot Table in Google Sheets
Did you know you can create a pivot table in Google Sheets which automatically updates as you add data to it? Remarkably, it's an easier process than in Excel ...
How to Add IF Statements to a Pivot Table
Pivot tables are a powerful feature in Excel that allow users to summarize, analyze, and visualize data. One of the more advanced features of pivot tables is t ...
How to Track Income and Expense in a Single Chart
Do you want to create a budget which tracks income and expenses on just one chart? There's an easy way you can combine them where you can show positive and neg ...
How to Break Ties in Excel and Rank with Multiple Criteria
If you're tracking standings in Excel, you know it can be challenging to ensure that you have your rankings setup correctly, especially when factoring in multi ...
How to Add a Calculated Column in Power Query
Power Query can help you summarize and analyze your data. But did you know that you can also add calculated columns similar to how you might in a pivot table? ...
Hide Blanks and Error Values on a Pivot Table
Do you want a quick way to clean up your pivot table and remove blanks and errors from it? Below, I'll show you how to do that with just a few steps. In the be ...