Gary Berg

Beyond the mechanics of spreadsheets: Using design instruction to address spreadsheet errors

Essential reading

Spreadsheets have errors like dogs have fleas. Nine out of every ten spreadsheets suffer some error, and consequences can be severe.
Good spreadsheets are essential for informing decision making. But most spreadsheets are not good. We help you make better spreadsheets.
Our spreadsheet methodology has criteria for designing, building, and validating spreadsheets to ensure that they work correctly.
95% of all spreadsheets contain errors. So, it is almost certain that your spreadsheets are wrong.
The cascading structure of typical spreadsheet formulae means that just about every spreadsheet is almost certainly wrong.
"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.
A poorly documented spreadsheet erodes effective use. Our workshops help students develop good documentation habits and skills.
Once information is loaded into a spreadsheet, it acquires properties that it may not deserve – a process called reification.