Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions.
Creating a slow spreadsheet is easy. Creating an efficient spreadsheet requires more thought and application of specific techniques.
Solver Max provides a collection of optimization model examples in Excel (using the Solver and OpenSolver add-ins) and Python.
Our spreadsheet methodology has criteria for designing, building, and validating spreadsheets to ensure that they work correctly.
Do you document your spreadsheets? We use the FizzBuzz word game to illustrate the importance of documenting your spreadsheets.
Spreadsheet errors are reduced by using good design. Our students do three assignments to acquire good spreadsheet design skills.
Spreadsheets have errors like dogs have fleas. Nine out of every ten spreadsheets suffer some error, and consequences can be severe.
"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.
We can help you make better spreadsheets:
Contact us