Tuesday, April 13, 2021
Benford's Law reveals an amazing characteristic of data. Not only does it help to identify fraud, it could help you to improve budgets and forecasts.

Use Benford’s Law & Charts in Excel to Improve Business Planning

Unless you're a public accountant, you probably haven't experimented with Benford's Law. Auditors sometimes use this fascinating statistical insight to uncover fraudulent accounting data. But it might reveal...
Here's how I created the formula that calculates the breakeven sales volume for a prospective change in product prices.

Should You Raise Prices? Should You Lower Them? Derivation of the Formula For Planning...

The article, Should You Raise Prices? Or Should You Lower Them? These Excel Charts Can Help You Answer Those Questions, introduces the Price-Change formula....
How healthy is your company? Here's a mathematical method that can help you to predict whether a business is headed for bankruptcy…if it's still accurate.

Predict Business Bankruptcy Using Z Scores with Excel

"General Motors Corp. and Ford Motor Co., the two biggest U.S. automakers, have about a 46 percent chance of default within five years, according...
In a list of items that could appear in a worksheet any number of times, here's how to count the number of items that appear only once. Or twice. And so on.

How to Count the Occurrences of Items in a List

"I have a list of repair orders (RO). I want to know how many one line repair orders there are in the list. So...
The Internal Rate of Return calculation has very real problems, no matter where it's calculated. But with its MIRR function, Excel could offer a solution.

How Excel’s MIRR Function Can Fix the IRR Function

The calculation of an Internal Rate of Return is very appealing...at first glance. When you know the IRR of a prospective investment, you seem to...
Beginning in Excel 2016 in Office 365, your formulas can set gaps in your line and scatter charts. Here are two ways to use the feature in your reports.

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...
When you include recessions and economic downturns in your charts, you can show your company's performance in a much better context. Here's how to set up your Excel charts to display those recessions and downturns.

How to Show Recessions in Excel Charts

I showed you the following figures in Chart Your Rate of Change to Reveal Hidden Business Performance. The line in the first chart below shows Apple's...
By charting the annual Rate Of Change (ROC) of key measures, you can uncover significant information about your time-series data. And by using the right recession measure, you can put that information into better context.

Chart Your Rate of Change to Reveal Hidden Business Performance

What insights can you gain from the following Excel chart of Apple's quarterly revenues over the past 18 years? I see three things. First, their...
On Valentine's Day, 2018, tens of thousands of major sites warned their readers that inflation is rising. But that might not be true. These analytical Excel charts suggest a different conclusion.

What Inflation? How Excel Charts Can Help You Avoid Fake Economic News

The business news on Valentine's Day, 2018, was dominated by talk of rising inflation. A search of Google News showed 67,100 results for the...
You can uncover new insights about your company by transforming your data before you chart it. This method of data transformation has revealed a long-term weakness in the U.S. economy.

This Excel Analytical Charting Strategy Reveals an Economic Warning

With normal charts, you find data and then you plot it. But with analytical charts, you transform your data in various ways to discover...

Latest Articles

Using Excel's LET, SORTBY, and SEQUENCE functions, and dynamic arrays, you easily can list any number of top and bottom results from a Table.

How to Report Top and Bottom Results Using Dynamic Arrays in Excel

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...
The LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

How to Use Excel’s LET Function

In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...
You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
Advertisement
Advertisement