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...
Seven Ways to Avoid Errors In Excel Reports & Analyses
You can find many stories on the web about problems with spreadsheet errors. So I thought it would be useful to review some practical...
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...
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....
Quickly Find a Worksheet in an Excel Workbook With Many Sheets
I’m not opposed to using VBA. I think it’s great fun and it can be very useful. But in a business setting, if VBA...
Map Your Financial Health With an Excel DuPont Dashboard
Management reporting is all about communication. Reporting Return On Equity (ROE) is a case in point.
The ROE financial ratio is a key measure of...
Map Costs and Sales in Excel with a Classic Breakeven Chart
When I worked as a CFO, my monthly reports always included a breakeven chart. It was one of the most popular reports I produced.
But...
How to Make Top-Ten Charts Easier to Read
Managers need to know where the greatest opportunities and the worst problems can be found. This is why top-item figures are so popular.
These figures...
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....
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