Want to get better at Excel?
This site will help you...
New content every week on this site and on social media
Recent posts
10 Pivot Table Mistakes to Avoid
Creating a pivot table is not difficult to do. If you just go to the Insert menu in Excel, there is an option to select a Pivot Table. As long as you have your ...
How to Use the CHOOSE Function in Excel: A Comprehensive Guide
When it comes to working with Excel, mastering the various built-in functions can save you time, increase your efficiency, and unlock new ways to analyze your ...
How to Fix #SPILL! Errors in Excel
If you've ever worked with dynamic arrays in Excel, you've probably come across the #SPILL! error. This error message may seem confusing at first, but it’s act ...
How to Change the Default Layout of Your Pivot Table in Excel
The default pivot table layout can oftentimes be suboptimal. The compact view doesn't make it easy for analyzing data, especially when you have many fields. If ...
How to Use the PIVOTBY Function in Excel
PIVOTBY is a relatively new function that Excel introduced in 2021. It is a dynamic, formula-based alternative to pivot tables. It’s part of Excel’s push towar ...
How to Make a Pivot Table From Multiple Sheets in Excel (Step-by-Step Guide)
Creating a Pivot Table is one of the fastest ways to summarize large amounts of data in Excel. But if your data is spread across multiple sheets, it can seem a ...
How to Use the TRIMMEAN Function in Excel
What is the TRIMMEAN function? The TRIMMEAN function has been available on Excel since the 2016 version. What it does is return the mean (average) of your d ...
How to Create a Map Chart in Excel Showing the Most Expensive Zip Codes in Each U.S. State
Map charts can help display a lot of data, showing you not only the largest values relative to other values. Below, I'm going to walk you through the steps of ...