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...
How to Create and Use Dynamic Range Names in Excel
(Download the example workbooks.)
We Excel users often refer to ranges that need to move or expand in future versions of our reports. For example:
...
Create Variable-Length, Dynamic Reports Linked to Excel Tables
Excel Tables are a powerful feature introduced in Excel 2007. Not only can you report from them directly, you can use them as a...
Chart Your Rate of Change to Reveal Hidden Business Performance
What insights can you gain from the following Excel chart of Apple's quarterly revenues over the past 18 years?
I see three things. First, their...
Excel Bar Charts with Economic Indicators
The Excel figure below shows three indicators of the US economy. Two show economic improvements and one doesn't.
The Excel Perspective
Using column charts rather than...
What Inflation? How Excel Charts Can Help You Avoid Fake Economic News
The business news on Valentine's Day, 2018, was dominated by talk of rising inflation. A search of Google News showed 67,100 results for the...
Good Examples of Bad Charts: Chart Junk from a Surprising Source
For years, I’ve written that we Excel users should create “magazine-quality” charts for our reports and analyses.
However, we must be very careful of the...
How to Report Periodic Data from Excel Databases
Sometimes, the best way to solve your Excel problem is to redesign your workbook.
Ron G. brought this thought to mind with a recent question....
How to Use Conditional-Format Formulas to Change Background Colors
"I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...
Five Really Useful Excel Keyboard Shortcuts
Most Excel users use some of Excel's shortcuts frequently, like F9, Ctrl + C and Ctrl + V.
However, Excel offers other shortcuts that are nearly as useful....