Monday, March 1, 2021
An article in the Wall Street Journal about babies born during the winter months offers some great advice about charts for Excel users in business.

Excel Charts, Seasonality, & Analysis: Five Lessons from the WSJ

A 2009 article in the Wall Street Journal offered some great advice for Excel users in business. The article, New Light on the Plight of...
The two Excel dashboard-like charts with May data show that consumer confidence has dropped like a rock since March. But Asia's data isn't available yet.

Dashboard-Like Excel Charts of International Consumer Confidence

The following Excel figure displays its charts in a dashboard-like format. At least, it's in a format that dashboards should use! When you use simple...
Excel includes many outstanding features that you probably don't know even exist. Here's how to find those features and to use the ones you need.

How to Find and Use Excel’s Best Hidden Features

Excel has many outstanding hidden features. Here are a few that I use frequently… In Excel 2013 and above, when you close Excel's last...
Business magazines and newspapers usually are an excellent place to find great ideas for Excel charts. But here's a Wall Street Journal chart figure that offers lessons about what NOT to do!

Bad Chart! Bad, Bad Chart!

(Download my improved Excel version of the bad charts show below.) The Wall Street Journal usually publishes excellent charts. And Excel users usually can duplicate those professional-quality...
This simple VBA procedure finds the precise time it takes to calculate a workbook. You can use it to test competing workbook design methods.

Use Excel VBA to Test Report Calculation Times

I once exchanged email with an experienced Excel jockey who insisted that VLOOKUP was Excel’s fastest lookup method. It was even faster, he said,...
This Excel figure shows three charts showing Covid-19's economic damage: Initial Claims, Business Loans, and Cass Freight Shipments.

Three Charts Showing Covid-19’s Economic Damage

The following Excel figure shows three indicators of the US economy.Chart 1 measures the number of new unemployment claims during the past...
A manager needs to assign employee color codes to various tasks they perform for customers. Here's one way to do it with Excel's conditional formatting.

Use Conditional Formatting with Formulas to Manage Employee Tasks

"I have a simple Excel sheet with a list of to-do items down the left hand column. I have clients along the top. For...
When you include several charts in one report, your managers must THINK about each chart to decide if it shows good news or bad. Here's a fix for that.

How to Remove a Speed Bump From Your Excel Charts

Because managers need QUICK insight, we should remove as many speed bumps as possible from our reports and analyses. The following figure with two Excel...
Excel's XY (or "scatter") charts provide amazing power. This introduction to XY charts offers a fun way to learn more about this powerful chart type.

Fun with XY (Scatter) Charts in Excel

Because I’d been working hard on a project for many months, I once decided to take a break and play around with XY charts…which...
Top-ten figures are useful because managers need to know where the greatest opportunities and the worst problems are. Here are ideas to make them readable.

How to Make Top-Ten Charts Easier to Read

Managers need to know where the greatest opportunities and the worst problems can be found. This is why top-item figures are so popular. These figures...

Latest Articles

The LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

How to Use Excel’s LET Function

In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...
You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
Here's how to create an Excel array from two others, with the arrays stacked either one on top of the other, or side-by-side, like books on a shelf.

How to Stack and Shelve Dynamic Arrays

While using Excel 365 recently, I needed to create one dynamic array that would consist of two arrays, with one stacked on top of...
Advertisement
Advertisement