How to Excel

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

Your spreadsheets may be disasters in the making. Strive for spreadsheets that are validated, reliable, and auditable.

Do you document your spreadsheets? We use the FizzBuzz word game to illustrate the importance of documenting your spreadsheets.

Research concludes unanimously that spreadsheet errors are both common and non-trivial. We must seek ways to reduce spreadsheet errors.

Spreadsheets have errors like dogs have fleas. Nine out of every ten spreadsheets suffer some error, and consequences can be severe.

This article walks you through different methods and built-in tools that can be used to audit and debug Excel spreadsheets.

Only a quarter of survey participants were satisfied with their spreadsheet testing. Their techniques are largely manual and lack formalism.

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