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.
Solver Max provides a collection of optimization model examples in Excel (using the Solver and OpenSolver add-ins) and Python.
Errors in the data, formulas, or manipulation of spreadsheets could be costly, even devastating.
Once information is loaded into a spreadsheet, it acquires properties that it may not deserve – a process called reification.
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.
Connexion is a collection of the most useful and interesting spreadsheet-related articles from the web.
We can help you make better spreadsheets:
Contact us