Auditing Toolbar

Please purchase the course before starting the lesson.

The Formula Auditing Tool is one of the most important tools you will learn about. It helps you visualise where a formula is looking and can be used when checking whether a formula has been correctly built in Excel.

We use the Formula Auditing Tools to:

  • Check which cells are being referred to in a calculation
  • Identify differences in formula in rows or columns
  • Check whether cells are important to the spreadsheet when we want to delete them (or rows or columns)

where-is-the-formula-auditing-toolThe main buttons we will focus on are:

  • Trace Precedent
  • Trace Dependent, and
  • Remove arrows

To see the full course contents click here.

Back to: Beginner Excel Course > Excel Functions