Want to get better at Excel?
This site will help you...
New content every week on this site and on social media
Recent posts
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 ...
How to Use VLOOKUP with Pivot Tables
Do you want to be able to use a VLOOKUP with a pivot table? While there isn't a way to natively do so, there is a way you can make it look as though your pivot ...
How to Get Rid of the Red Warning Bar in Microsoft Excel
Have you opened a file in Excel which contains macros in it only to find that you can't use it, because the content is blocked? If you've come across the follo ...