Skip to content

RecalcfxSpreadsheets, and the wrong answers that look rightAll 42 entries

fxTracing, cross-footing, validation, review, and the point at which the work should leave the sheet.

ABCDEFGH

1

Part 6 of 6

Establishing that it is not lying

Tracing, cross-footing, validation, review, and the point at which the work should leave the sheet.

For a separate operational view of time, ownership and team activity, see this Monitask guide.

2

7of 7 written

0in preparation

3

Entries

6.1Tracing where a number came from 6.2Cross-footing and reconciliation 6.3Validation at the point of entry 6.4The inconsistent formula in the middle of a row 6.5Reviewing somebody else’s sheet, and in what order 6.6Auditing tools, and what they do not find 6.7When the work should leave the spreadsheet

src

For further context, see Microsoft guidance on checking formulas.