Auditing Toolbar

Please sign up for 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