Add Some Style to Your Tables in Excel Reports
Excel tables in reports have always been difficult for me to format professionally. So every once in a while, I experiment with them.
The two...
You Usually Don’t Need to Select an Object in Excel VBA
An Excel VBA user asked in a forum recently how to select a sheet in VBA when the sheet name is stored as a...
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...
Excel Bar Charts with Economic Indicators
The Excel figure below shows three indicators of the US economy. Two show economic improvements and one doesn't.
The Excel Perspective
Using column charts rather than...
Save Time with Excel Range Selections
One of the big differences between early-stage Excel users and gurus is that gurus can do simple things in Excel much more quickly than...
How to Use Absolute and Relative Cell References in Excel Formulas
A reader sent me this question:
Could you send me more details about using $'s like the following: =AVERAGE($6:$6) averages all data in ROW 6....
Chart Recessions and Other Boolean Conditions in Excel
I doubt you’ve seen an Excel chart like this before. It shows multiple Boolean conditions that might affect the trend in the annual Rate...
How to Set Up a Data-Validation List Box in Excel
Often, we need to set up a list box in Excel, a sorted list that allows us to choose an item from an Excel...
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....
Should You Raise Prices? Should You Lower Them? These Excel Charts Can Help You...
In the early 1980s I was the CFO of a company owned by a man whose first instinct was to cut prices.
When business was...
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