Thursday, October 22, 2020

Recent Content

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...

Featured 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...
Excel databases can be Tables of data, Pivot Tables, or even lists that your reports and analyses can use easily. This introduction will get you started.

What the Heck is an Excel Database?

You can improve your Excel reports and analyses significantly if you keep your data in an Excel database. Microsoft, Oracle, IBM, and others sell...

Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1

It all seems so simple... To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...

Blog

Add Low-Overwhelm Context to Your Line Charts

The data you display in charts often takes on new meaning when you display it in the context of other data. One way to add...

Business & Economics

Formulas & Functions

The Basics of Professional Excel Charting

When you're reporting, you can't run a cable from your data to your readers' brains. But the next-best alternative is to use great charts. By "great...

Excel Methods

A Volatile Workbook to Test Calculation Times for Excel Lookup Methods

In Use Excel VBA to Test Report Calculation Times I described a macro that finds the total time necessary to calculate Excel for a specified number...

Popular

Most loans and many investments are annuities, which are payments made at fixed intervals over time. Here's how to use Excel to calculate any of the five key unknowns for any annuity.

Excel’s Five Annuity Functions

“Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
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...
The Monte Carlo method allows you to forecast performance using probability distributions for your assumptions. And Data Tables provide a quick and easy way to implement the Monte Carlo method. Here's how to do it.

How to Create Monte Carlo Models and Forecasts Using Excel Data Tables

(Download the workbook.) (This is the second of two articles about normal distributions. The first article is, How to Return Random Numbers from a Normal...