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 Make a Pareto Chart in Excel
A Pareto chart is a useful tool for identifying the most significant factors in a dataset. It’s based on the Pareto principle—also known as the 80/20 rule—whic ...
English Premier League Prediction Template in Excel and Google Sheets (Free Download)
Are you looking for a free English Premier League Prediction Template to track matches, make weekly predictions, and see how your forecasts stack up against yo ...
How to Calculate the Altman Z Score in Excel
The Altman Z Score is a financial formula that evaluates a company’s financial health by analyzing key balance sheet and income statement ratios. In simple ter ...
How to Do an 80/20 Sales Analysis in Excel
Marketers know that typically 80% of sales come from just 20% of customers, and by focusing on that group, you can gain valuable insights into your data. With ...
How to Create a Dashboard in Excel to Summarize Sales Data
In this post, I'm going to walk you through the steps of creating a dashboard in Excel, from start to finish. You can use the sample data file to follow along ...
How to Analyze S&P 500 Sector Performance Using an Excel Bar Chart
Charts can be an effective way to convey data, as opposed to just tables. By visualizing numbers, readers can easily see the highs and lows, and just how much ...
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 ...