Event Description

A spreadsheet can produce plausible numbers while hiding broken links, unexpected formulas, or circular references. Learn practical ways to inspect workbook structure, expose formula logic, and investigate errors before relying on the results.
This presentation answers the question:
How can I determine whether an Excel workbook is working as intended?

Topics typically covered
•  Workbook orientation: Workbook Statistics, Navigation Pane, external links.
•  Formula discovery: Selecting formula cells, FORMULATEXT.
•  Formula tracing: Identifying precedent cells, Evaluate Formula.
•  Error investigation: Error Checking, circular references.

Objectives

Learning objectives
•  Identify tools for reviewing workbook structure and external links.
•  Recognize ways to expose and trace worksheet formulas.
•  Describe how Error Checking and circular-reference tools help investigate exceptions.