Every study that has looked for errors has found them in considerable numbers. Spreadsheeting's childhood is over.
95% of all spreadsheets contain errors. So, it is almost certain that your spreadsheets are wrong.
See our bibliography of spreadsheet best practice, risk management, errors and testing, and methods for improving spreadsheets.
Solver Max provides a collection of optimization model examples in Excel (using the Solver and OpenSolver add-ins) and Python.
Do you document your spreadsheets? We use the FizzBuzz word game to illustrate the importance of documenting your spreadsheets.
This article walks you through different methods and built-in tools that can be used to audit and debug Excel spreadsheets.
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.
We can help you make better spreadsheets:
Contact us