Ferret out spreadsheet errors: use Excel's tools to uncover and correct formula problems.

Extract

---

Ferret out spreadsheet errors: use Excel's tools to uncover and correct formula problems.

Most spreadsheets are complicated files--not only because they contain a multitude of formulas and data, but because all the formulas are intricately linked to data distributed in various parts of the worksheet. As a result, even one small error--a transposed digit or an incorrect formula--can turn an entire spreadsheet into a useless jumble of numbers.

BUILDING AUDIT MODULES

There are several ways to prevent and uncover spreadsheet errors. One of the best is to embed self-checking tool sets, or modules, directly in worksheets--in effect, making them self-auditing. This is especially important in spreadsheet templates because any errors they contain are reproduced in each subsequent copy of the template.

But because ...

See the full content of this document

---