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...
Warren Buffett, Inflation, and Excel
On May 3, 2021, CNBC quoted Warren Buffett saying, “We are seeing very substantial inflation. We are raising prices. People are raising prices to...
Two Business Uses for Excel’s New Chart Feature
For decades, I've been whining about the need for Excel to have some way for our formulas to specify a gap in line and...
Conditional Formatting with Formulas
Excel offers two types of conditional formatting. Although both types are very useful, one of them is more widely used than the other…probably because...
How to Create Funnel Charts in Excel
Although “funnels” are a common term in selling, the concept also can apply to other business activities.
The general idea is that an organization begins...
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...
Five Really Useful Excel Keyboard Shortcuts
Most Excel users use some of Excel's shortcuts frequently, like F9, Ctrl + C and Ctrl + V.
However, Excel offers other shortcuts that are nearly as useful....
How to Debug INDEX in Excel
"I'm not a very experienced Excel user. Why does = INDEX(...) sometimes work and sometimes not.... :-)?" -- Suzan G.
Probably the best way to...
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...
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...
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