Calculate Mortgage Payments and Your ROA with an Excel CalcPlot Chart
An Excel CalcPlot Chart allows you to plot values in three dimensions, not merely two. Here are two examples.
Mortgage Paments
Mortgage interest rates are at...
Find Leading Indicators Using Automated Cross Correlations in Excel, Part 2
In Part 1 of this discussion about automated cross correlations, I explained how to set up the cross-correlation Data Table shown below, in columns...
Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1
It all seems so simple...
To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...
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...
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...
Excel Charts, Seasonality, & Analysis: Five Lessons from the WSJ
A 2009 article in the Wall Street Journal offered some great advice for Excel users in business. The article, New Light on the Plight of...
Introducing the Power of Year-Over-Year Performance Charts in Excel
The purpose of management reports should be to help readers find and track patterns of performance…quickly and easily.
That’s the attraction of charts, of course....
Three Simple Tricks to Improve Analytical Charting in Excel
For years, my Excel charts of trends used a simple idea: To gain insights about periodic data, just chart it.
What else was there to...
Three More Simple Tricks to Improve Excel Charts for Business
In 3 Simple Tricks to Improve Analytical Charting in Excel, I showed you how to shift time periods, index your data, and chart your rate...
Latest Articles
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...
Consumer Sentiment Suggests a 2022 Recession
In recent months, business websites have speculated about recessions and stagflation in 2022.
These predictions could affect your Excel work significantly in the next few...
Advertisement