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

U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats."However, a rising inflationary tide does not lift...

In How to Use Excel’s LET Function, I showed several examples of a powerful function that Microsoft added to Excel 365 in the summer...

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks.In fact, this income statement illustrates a...

Often, in accounting, marketing, and other departments, we'd like to report and analyze groups of items rather than one item at a time.In Part...

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

November 5, 2021Inflation is rising in the U.S. And that made me wonder how a higher rate of inflation could affect the price of...

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

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

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

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

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

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

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

November 5, 2021Inflation is rising in the U.S. And that made me wonder how a higher rate of inflation could affect the price of...

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

November 5, 2021Inflation is rising in the U.S. And that made me wonder how a higher rate of inflation could affect the price of...

I recently read an article in the Wall Street Journal about the expected increase of electric vehicles in the US. That made me wonder...

At first glance, the following report is an ordinary one. It merely sums an Excel Table by Product and Region, and then foots and...

Excel's XLOOKUP function searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't...