Saturday, May 15, 2021
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.

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...
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...
Simple spreadsheet edits can introduce costly Excel errors. Here are three techniques that can help you to reduce your errors in Excel.

Three Ways to Reduce Errors in Your Excel SUM Formulas

If you aren't careful, simple edits to your reports and analyses can cause significant errors. Years ago, for example, I heard about an expensive error...
Excel has a reputation for having many errors in reports and analyses. But you can use simple methods to reduce errors significantly. Here are seven of them.

Seven Ways to Avoid Errors In Excel Reports & Analyses

You can find many stories on the web about problems with spreadsheet errors. So I thought it would be useful to review some practical...
Many Excel reports leave managers knowing less than they did before. Here are five best practices to follow in planning your management reports.

Five Best Practices in Your Excel Reporting Strategies

Most Excel reports, forecasts, and analyses I've seen in my career could serve as excellent examples of what NOT to do in Excel. These reports...
If the formulas in your Excel reports and analyses display errors like #DIV/0! or #VALUE!, here are some simple ways to trap them.

Error Handling in Excel Spreadsheets

It’s virtually guaranteed. If you have a bunch of formulas like this… M43:   =C43/D43 …then the divisor, D43 in this instance, will have a value of...

Latest Articles

A Lesson in Excel Analysis Learned from Rising US Inflation

Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...
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

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

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