Sunday, April 27, 2025
Home Blog

Blog

Check in often to our blog where we may just surprise you with quick random thoughts about Excel, business, and the economy.

The two Excel dashboard-like charts with May data show that consumer confidence has dropped like a rock since March. But Asia's data isn't available yet.

Dashboard-Like Excel Charts of International Consumer Confidence

0
The following Excel figure displays its charts in a dashboard-like format. At least, it's in a format that dashboards should use! When you use simple...
Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

How Fast Is Too Fast?

0
(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...
Here's how you can split delimited text into an array with a short Excel formula, and then wrap the formula with the INDEX function to return any value from the array.

How to Split and Index Delimited Text with Excel Formulas

0
For the longest time I've wished that Microsoft would add a SPLIT function to Excel. The function would have a syntax like this... =SPLIT(text, delimiter,...
This figure uses the Chicago Fed's National Financial Conditions Index to illustrate how to create an Excel panel chart.

US National Financial Conditions Using Excel Panel Charts

0
I’ll explain the meaning of this chart figure shortly. But first, let’s look at it from an Excel perspective. (Note: I’ve begun to use economic...
As inflation rises, so do mortgage interest rates—causing house prices to fall. Here's how Excel's PV function can help you estimate what you new house price will be.

Here’s How Inflation Could Affect the Value of Your Home

0
November 5, 2021 Inflation is rising in the U.S. And that made me wonder how a higher rate of inflation could affect the price of...
This Excel table shows the top and bottom five results, with charts that show the most recent three month trends. And it updates automatically.

Show Top and Bottom Results in a Chart-Table

0
The workbook that supports the following figure does a lot of work! First, it uses Power Query to download the weekly unemployment claims and the...
A shortage of truckers is one cause of the supply chain crisis in the US. This Excel chart suggests that the problem won't end soon.

An Excel Chart of a Major U.S. Supply Chain Problem

0
October 23, 2021 A shortage of truckers now appears to be the greatest problem with the United States' supply chain. In fact, President Biden said in...

A Lesson in Excel Analysis Learned from Rising US Inflation

0
Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...

Add Low-Overwhelm Context to Your Line Charts

0
The data you display in charts often takes on new meaning when you display it in the context of other data. One way to add...
Berkshire Hathaway is raising prices, and their costs are increasing. Inflation is on the rise. These Excel charts illustrate the the problem.

Warren Buffett, Inflation, and Excel

0
On May 3, 2021, CNBC quoted Warren Buffett saying, “We are seeing very substantial inflation. We are raising prices. People are raising prices to...

Latest Articles

Excel Flowbook Revolution

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,...
Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

How Fast Is Too Fast?

0
(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

0
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