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...
When you combine conditional formatting with charts you can create detailed chart legends that match the relative positions of the lines in your chart.

How to Create Dynamic Chart Legends in Excel

When I saw a chart designed like the ones below in the Wall Street Journal, I knew I had to create one just like...
Here's how I created the formula that calculates the breakeven sales volume for a prospective change in product prices.

Should You Raise Prices? Should You Lower Them? Derivation of the Formula For Planning...

The article, Should You Raise Prices? Or Should You Lower Them? These Excel Charts Can Help You Answer Those Questions, introduces the Price-Change formula....
When you include recessions and economic downturns in your charts, you can show your company's performance in a much better context. Here's how to set up your Excel charts to display those recessions and downturns.

How to Show Recessions in Excel Charts

I showed you the following figures in Chart Your Rate of Change to Reveal Hidden Business Performance. The line in the first chart below shows Apple's...
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...
Pivot Tables aren't merely a way to interact with your data. You also can use them as a rich source of data for standard reports and analyses. And you don't need to limit formulas to GETPIVOTDATA; you also can use SUMIFS, SUMPRODUCT, and all other Excel functions with pivots. Here's how.

How to Set Up a Pivot Table as an Excel-Friendly Database

You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs). In...
Mortgage lenders give you many options for your interest rate and amortization period. This workbook helps you to choose from among them.

Compare Loan Payment Options in Excel

When you’re comparing your payment options for mortgage loans, your choices can be overwhelming... When in St. Ives, I found a home, Then looked at seven...
Does your company need to make scheduled payments to companies that don't send invoices? This worksheet will help to plan those cash requirements.

Manage Periodic Payments with an Excel Cash Calendar

Most companies must write checks periodically to companies that don't send invoices. Often, their accounting systems provide little help in keeping track of these...
Now that you've calculated your cross correlations—that is, your time-shifted correlations—here's how to chart them professionally.

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

In Part 1 of this discussion about automated cross correlations, I explained how to set up  the cross-correlation Data Table shown below, in columns...
You need a volatile workbook to test Excel calculation speeds. Here's how I set one up to test lookup formulas.

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

Latest Articles

If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the strategy that will make it happen.

An Introduction to Excel Data Plumbing

Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...
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...
Advertisement
Advertisement