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....
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 week as...
The First Excel Dashboard Report
The Excel dashboard below is from the first-ever package of dashboard reports, which I created to show Excel's power to a client back then....
What the Heck is an Excel Database?
You can raise your Excel productivity significantly and slash your Excel errors—if you keep your data in an Excel database.
Microsoft, Oracle, IBM, and others...
Weekly Dashboard Reporting with Excel
"I work for a small (private) company whose owners have requested WEEKLY dashboards on various aspects of the business. Do you have a sample...
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...
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...
Use this Excel ‘Cash Flow Balance Sheet’ to See Sources & Uses of Funds...
For most businesses, cash flow is more important than profits and losses.
The reason is clear. A profitable company with negative cash flows may not...
Use Excel to Fix Your Broken AR Measure of Days Sales Outstanding in Receivables
During tough economic times it's particularly important to manage your Accounts Receivable balance carefully. Unfortunately, the traditional way to measure AR performance is badly...
Use Common-Age Excel Charts to Compare and Forecast Performance for the Same Number of...
In the early lives of new products or new stores, managers often are anxious to track and improve sales performance. To do so, it's...
Latest Articles
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
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...
Advertisement