Page 15 of 15
This article walks you through different methods and built-in tools that can be used to audit and debug Excel spreadsheets.
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.
We are conscious of very few of our errors. When people are confronted with their actual error rates, they are typically shocked.
Only a quarter of survey participants were satisfied with their spreadsheet testing. Their techniques are largely manual and lack formalism.
Spreadsheets can be considered to be the world's most successful end-user programming language. Spreadsheet formulas are Turing complete.
60% of large companies feel 'Spreadsheet Hell' describes their reliance on spreadsheets either completely or fairly well.
95% of all spreadsheets contain errors. So, it is almost certain that your spreadsheets are wrong.
We can help you make better spreadsheets:
Contact us