Sunday, October 25, 2020
This Excel table shows the top and bottom five results, with charts that show the most recent three month trends. And it updates automatically.

Show Top and Bottom Results in a Chart-Table

The workbook that supports the following figure does a lot of work! First, it uses Power Query to download the weekly unemployment claims and the...
How to calculate and highlight the standard error of the estimate on each side of the trend in an Excel chart to make exceptional results stand out.

Highlight Normal Results in Line Charts to Make Exceptional Results Stand Out

Line charts that show trends in performance are the most useful type of chart that management reports can contain. All managers want good performance to...
You can use probability distributions to manage the uncertainty about your assumptions when you create simulations in Excel. Here's how.

How to Return Random Numbers from a Normal Distribution for Your Excel Forecasts

(This is the first of two articles about normal distributions. The second article is, How to Create Monte Carlo Models and Forecasts Using Excel Data...
Excel provides several worksheet functions for working with normal distributions or 'bell-shaped curves.' This introduction to Excel's Normal Distribution functions offers help for the statistically challenged.

An Introduction to Excel’s Normal Distribution Functions

(Download the workbook.) When a visitor asked me how to generate a random number from a Normal distribution she set me to thinking about doing statistics...
Using Excel 2007 and above, you can create shaded areas in charts to specify areas of special interest. Here's how to do this using normal curves.

How to Create Normal Curves With Shaded Areas in Excel

Adding shaded areas to normal curves like this is a challenging task in Excel charting. But once you know how, it's not difficult to...

Latest Articles

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...
Advertisement
Advertisement