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 Create a Dashboard to Track Las Vegas’ Visitor Data
A good way to gauge the strength of the U.S. economy and how well it is returning to normal level is by looking at Las Vegas' visitor data. The Las Vegas Conve ...
Free Math Worksheet and Template for Elementary School
If you have young kids who could use some math practice, I've got you covered. What's great about Excel is that by using the random number generator, you can c ...
How to Replace Multiple Values in Power Query
Replacing values can be an important part of cleaning up your data and preparing it for data analysis. Below, I'll outline the steps to take to replace a value ...
How to Add Flags to Conditional Formatting Rules
Conditional formatting in Excel allows you to automatically format and highlight cells based on their values. You may want to apply custom rules to values that ...
Use Manual Calculations in Excel? This New Feature Helps You Find Stale Values
If you've got a big, complex spreadsheet with lots of formulas, it can be slow to run. In those situations, turning off calculations can be a life saver. But t ...
How to Group Dates by Month in a Pivot Table
In this post, I'm going to show you how to group dates in a pivot table by month. By doing this, you can do analysis by month rather than individual day. And t ...
How to Make a Histogram Chart in Excel
What is a histogram? A histogram is a type of chart used to visualize the frequency distribution of a dataset. It represents how often different values occu ...
How to Use the Trend Function in Excel
The TREND function in Excel is a powerful tool that allows users to perform linear regression analysis and make predictions based on existing data. This functi ...