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 Reproduce Your Excel Work Across Many Categories, Part 3 of 3
Part 1 of this series about analytical spawning with Excel described how Excel users often need to spawn one model or report across many related...
How to Reproduce Your Excel Work Across Many Categories, Part 2 of 3
As I explained in Part 1 of this series, Excel users often need to apply many instances of data to one model or forecast, list...
How to Reproduce Your Excel Work Across Many Categories, Part 1 of 3
A member of an Excel forum recently asked how to solve a problem that many Excel users face in various forms.
In his particular case,...
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 Read and Update Excel Tables Using SUMIFS and INDEX-MATCH
A growing number of Excel users in business are linking their reports and analyses to Excel tables. By doing so, they can update them...
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...
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...
How to Create Cycle Plots in Excel to Chart Seasonal Sales Data
If your company's sales are seasonable, you've probably seen a chart that looks something like the first one below.
This Excel chart shows the continuous...
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...
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