This session demonstrates both basic and more advanced built-in approaches to formula auditing and tracing the flow of values through a worksheet. It also demonstrates built-in techniques for identifying constants and inconsistent formulas.
It presents key information to aid in understanding the cause of errors, how to identify their sources and how to manage errors in modelling and analytical projects without sacrificing clarity and without making formulas more difficult to trace or audit. Having demonstrated why many common approaches make tracing or auditing difficult to undertake, steps to implement better approaches are canvassed and demonstrated to aid in the testing, checking, audit & maintenance of future models. Error checking approaches and error checking reports are also discussed.
Participants should be familiar with Excel and comfortable working with formulas and functions such as IF, SUM, COUNT, SUMIF, VLOOKUP, ISERROR.