How to Calculate BOTH Types of Compound Growth Rates in Excel
If you search the web to learn how to calculate a compound growth rate in Excel, you’ll likely find instructions for calculating only one...
How to Audit and Improve Excel Business Plans
A client, who's a business-finance consultant, recently was hired to improve the financial forecast for a major startup company. He recently sent me the...
How to Add Background Images in Excel
"How can I place a background image and still use the cells that the image covers?" -- Sally M.
Sally,
You can do this, but possibly...
How Excel’s MIRR Function Can Fix the IRR Function
The calculation of an Internal Rate of Return is very appealing...at first glance.
When you know the IRR of a prospective investment, you seem to...
How and Why to Define Excel Range Names with a Worksheet Scope
In Excel, a name can be global to a workbook or local to a worksheet. The traditional method we all use when we create...
Highlight Normal Results in Line Charts to Make Exceptional Results Stand Out
Line charts that show trends in performance are the most useful type of chart that management reports can contain.
All managers want good performance to...
Good Examples of Bad Charts: Chart Junk from a Surprising Source
For years, I’ve written that we Excel users should create “magazine-quality” charts for our reports and analyses.
However, we must be very careful of the...
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...
Five Ways to Make Your Excel Reports Incredibly Popular
Years ago, I was the young CFO of a small company that was purchased by a Fortune-200 company. Within days of the sale, I...
Five Ways to Improve Business Insight in Your Excel Reports
Is there a systematic way that you can help your readers to gain more insight from your Excel reports? There just might be.
The November,...
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