Roger L. Hayen

This article walks you through different methods and built-in tools that can be used to audit and debug Excel spreadsheets.

See our bibliography of spreadsheet best practice, risk management, errors and testing, and methods for improving spreadsheets.

Your spreadsheets may be disasters in the making. Strive for spreadsheets that are validated, reliable, and auditable.

Incorrect use of Excel's NPV function is a common source of spreadsheet errors. We show several pitfalls and ways to avoid them.

Creating a slow spreadsheet is easy. Creating an efficient spreadsheet requires more thought and application of specific techniques.

Do you document your spreadsheets? We use the FizzBuzz word game to illustrate the importance of documenting your spreadsheets.

The twenty principles for good spreadsheet practice aims to reduce the amount of time wasted and the number of errors.

95% of all spreadsheets contain errors. So, it is almost certain that your spreadsheets are wrong.