The Two Functions You MUST Know to Return Values from Excel Tables
“Export to Excel is the 3rd most common button in BI apps…after OK and Cancel.”
—Rob Collie, one of the founding engineers behind PowerPivot at...
Sample Excel Dashboard Reports from Forbes and Business Week
This mock-up is based on a format that Business Week used about thirty years ago. However, their report used a different color scheme. As...
Read a Text File with VBA in Excel, and Write the Text to a...
"I need to write a text file into one row of my Excel spreadsheet, cell by cell, 20 characters at a time. It's urgent....
How to Create Bullet Graphs to Replace Gauges in Excel
Business presentations desperately need a replacement for dashboard gauges. Gauges consume too much space in a report. They use excessive "chart junk." They're not...
How to Report GL Account Groups in Excel
Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks.
In fact, this income statement illustrates a...
How to Define General Ledger Account Groups in Excel
In Part 1 of this series, How to Report GL Account Groups in Excel, we explored the strategy for creating financial reports that use...
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....
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...
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...
Show Useful Year-to-Date Variance Charts in Your Excel Dashboards
Many companies have a difficult time creating charts of spending variances. In fact, many companies rely on charts that are nearly useless for that...
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