Auditing Toolbar

Please purchase the course before starting the lesson.

Auditing Toolbar

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 to find the Formula Auditing Tool

You can find the Formula Auditing tools in the formula tab

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: Intermediate Excel Course > Function and Formula Basics