John Hunt

An approach for the automated risk assessment of structural differences between spreadsheets (DiffXL)

Essential reading

"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.
Connexion is a collection of the most useful and interesting spreadsheet-related articles from the web.
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.
Spreadsheets can be considered to be the world's most successful end-user programming language. Spreadsheet formulas are Turing complete.
95% of all spreadsheets contain errors. So, it is almost certain that your spreadsheets are wrong.
The twenty principles for good spreadsheet practice aims to reduce the amount of time wasted and the number of errors.
Once information is loaded into a spreadsheet, it acquires properties that it may not deserve – a process called reification.