Hua Zhong

Our spreadsheet methodology has criteria for designing, building, and validating spreadsheets to ensure that they work correctly.

Creating a slow spreadsheet is easy. Creating an efficient spreadsheet requires more thought and application of specific techniques.

Incorrect use of Excel's NPV function is a common source of spreadsheet errors. We show several pitfalls and ways to avoid them.

Solver Max provides a collection of optimization model examples in Excel (using the Solver and OpenSolver add-ins) and Python.

Every study that has looked for errors has found them in considerable numbers. Spreadsheeting's childhood is over.

Connexion is a collection of the most useful and interesting spreadsheet-related articles from the web.

Once information is loaded into a spreadsheet, it acquires properties that it may not deserve – a process called reification.

"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.