Tuesday, April 13, 2021
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...
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...
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

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