John Cummings

Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions.

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

"Oh My God" my formulas are not working! This article covers most of the reasons for Excel formulas not working. And how to fix them.

The cascading structure of typical spreadsheet formulae means that just about every spreadsheet is almost certainly wrong.

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

Only a quarter of survey participants were satisfied with their spreadsheet testing. Their techniques are largely manual and lack formalism.

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

Overconfidence is one of the main causes of spreadsheet errors. Being informed about overconfidence leads to more accurate spreadsheets.