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 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 ...
How to Generate a List of Non-Repeating Random Numbers in Excel
Do you want to create a list of random numbers in Excel, but avoid repeating values? Below, I'll cover how you can set that up to ensure that no number is show ...
How to Use the TRIMRANGE Function in Excel
Microsoft Excel has recently rolled out a new function, TRIMRANGE. And as its name suggests, it will help you trim a range, to ensure that your formula is effi ...
Free Google Sheets Calendar Template to Track Bills and Events
Want to track events, bills, and tasks easily? Rather than using different apps, you can do all of that right within Google Sheets. Whether you're using your h ...
How to Create Dynamic Min-Max Range Charts in Excel
A good chart in Excel can display a lot of useful information in one visual. In this example, I'm going to show you how to display minimum and maximum values, ...