Monday, December 5, 2022

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...
Two economists have introduced a new leading indicator, which predicts a recession soon. These Excel charts illustrate their insight. If they're correct, Excel users will be very busy in the months ahead.

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...
Your data can contain many important, hidden patterns. But simple transformations in Excel can help to reveal them—as this example illustrates.

Simple Transformations Can Reveal Hidden Patterns in Your Data

Excel users have at least two significant advantages over business professionals who rely on other analytical and reporting tools. First advantage: We Excel users can...
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

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...

How to Smooth Monthly Trends with Centered Moving Averages

I recently read an article in the Wall Street Journal about the expected increase of electric vehicles in the US. That made me wonder...
To reduce errors in reports, you should foot and cross-foot them. But Excel's floating-point arithmetic gets in the way. Here's how to fix the problem with a standard deviation calculation.

How to Foot and Cross-Foot Excel Reports in a Floating-Point World

At first glance, the following report is an ordinary one. It merely sums an Excel Table by Product and Region, and then foots and...
Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

How I Set Up SEARCH and FIND Formulas on Steroids

I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

Eight Great Tools for Your Quick Access Toolbar

I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...

How to Set Up Multiple Conditional Formats with Formulas

In How to Set Up a Square-Format U.S. Map in Excel, I showed how to create a square-format US map in Excel. I also...
When conditional formatting rules conflict, Excel can deliver unexpected formatting results. These two guidelines make Excel's logic clear.

How Excel Manages Conflicting Conditional Formats with Formulas

When we're working with conditional formatting with formulas, how does Excel manage conditional formatting rules that conflict with each other? And how does the "Stop...

Latest Articles

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?

(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...
Two economists have introduced a new leading indicator, which predicts a recession soon. These Excel charts illustrate their insight. If they're correct, Excel users will be very busy in the months ahead.

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