Introducing the Power of Year-Over-Year Performance Charts in Excel
The purpose of management reports should be to help readers find and track patterns of performance…quickly and easily.
That’s the attraction of charts, of course....
Introducing Excel-Friendly Databases
The most productive way to flow data to your Excel reports and analyses is to use Excel formulas to flow data from an Excel-Friendly...
An Excel Chart of a Major U.S. Supply Chain Problem
October 23, 2021
A shortage of truckers now appears to be the greatest problem with the United States' supply chain.
In fact, President Biden said in...
Document Excel Worksheets with Pictures that Include Row and Column Headings
This image is a picture of a section of an Excel worksheet. Be sure to include pictures like this when you create your own...
Professional Quality Excel Chart Labels, Legends, and Colors
The following Excel chart shows that Excel really CAN generate professional-quality chart figures.
Here are some general strategies to consider…
1. Set up your data-plumbing correctly....
Chart of the New Economic Index that Tracks GDP Weekly
In April 2020, the Federal Reserve Economic Database (FRED) added a measure that will be followed closely during the Covid-19 economic devastation and recovery....
Using Excel XY (Scatter) Charts for Stock Analysis with HLOC Plots
One way to improve your abilities in Excel is to improve your understanding of the kinds of solutions Excel can generate when you use—or...
Error Handling in Excel Spreadsheets
It’s virtually guaranteed. If you have a bunch of formulas like this…
M43: =C43/D43
…then the divisor, D43 in this instance, will have a value of...
Weekly & Monthly Top-Ten Activity Reports
When one of my readers, Chris Helfrecht, sent the two sample Excel dashboards below, he wrote that he tried to follow my methods for...
The Most Powerful Ways to Summarize Excel Data for Reporting and Analysis
(Note: I wrote this before Microsoft introduced Excel Tables or SUMIFS. This post is scheduled for an update.)
Excel users often need to summarize data...
Latest Articles
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Consumer Sentiment Suggests a 2022 Recession
In recent months, business websites have speculated about recessions and stagflation in 2022.
These predictions could affect your Excel work significantly in the next few...
Advertisement