Creating a slow spreadsheet is easy. Creating an efficient spreadsheet requires more thought and application of specific techniques.
This article walks you through different methods and built-in tools that can be used to audit and debug Excel spreadsheets.
Only a quarter of survey participants were satisfied with their spreadsheet testing. Their techniques are largely manual and lack formalism.
60% of large companies feel 'Spreadsheet Hell' describes their reliance on spreadsheets either completely or fairly well.
Once information is loaded into a spreadsheet, it acquires properties that it may not deserve – a process called reification.
See our bibliography of spreadsheet best practice, risk management, errors and testing, and methods for improving spreadsheets.
Incorrect use of Excel's NPV function is a common source of spreadsheet errors. We show several pitfalls and ways to avoid them.
A poorly documented spreadsheet erodes effective use. Our workshops help students develop good documentation habits and skills.
We can help you make better spreadsheets:
Contact us