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 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...
Fourteen Ways to Improve Your Monthly Board Reports with the Help of Excel
Board reports should answer four types of questions:
1. What were the significant operating events last month? Are you on target?
2. How has your view...
Excel Is Great for Business Intelligence!
With the right access to data, Excel can become an outstanding Business Intelligence (BI) system.
Business Intelligence (BI) is the systematic use of information about...
The Excel-Friendly Database Strategy
Here's the key to slashing both your Excel errors and the time it takes you to create and update your Excel reports...
Get your plumbing...
The First Excel Dashboard Report Shown in Public
Tektronix invented one of the early moderately priced color printers. When one of their employees saw a sample of my Excel dashboards from 1992, the...
How to Save Multiple Excel Reports to One PDF File
A great way to distribute your Excel reports is to save them in a PDF file and then distribute the file.
People who receive your...
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...
The First Spreadsheet Dashboard: Mini-Graph Reports in Lotus 1-2-3
This is the first dashboard report ever created with spreadsheets. I worked on this reporting technique in the early 1980s, then included this report...
How to Fight Spreadsheet Hell with Three Excel Lookup Functions
(I wrote this long ago, and there's much to be added. It's high on my Update list. Charley)
Many Excel users build their reports like...
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