0 of 135 lessons complete (0%)
Function and Formula Basics

Auditing Toolbar

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.