Tuesday, December 10, 2024
Here's how to calculate the annual rate of inflation both by comparing prices several years apart, and by several months apart.

How to Calculate Inflation in Three Different Ways

0
Today, in the third quarter of 2021, the business press is churning out an avalanche of articles about the return of inflation. Although some...
I used the FILTER function to give me IFS-like power for PERCENTILE.INC. But then I realized the same pattern brings IFS-like power to many functions—including MEDIAN, STDEV.S, GEOMEAN, and perhaps even the FORECAST functions!

Using the Hidden Power of Excel’s FILTER Function

0
When you take the time to explore a new worksheet function, it's amazing what you can discover! And I won't tell you about the really...

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?

(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