Rules of Thumb: Avoiding Spreadsheet Pitfalls

• Plan ahead.

• Make accurate assumptions.

• Double-check formulas and values.

• Make formulas readable.

• Check output against other calculating devices.

• Build in cross-checks.

• Take advantage of preprogrammed functions, templates, and macros.

• Don’t use spreadsheets as a substitute for thinking.

Previous slide

Next slide

Back to first slide

View graphic version