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
- Trace Precedent
- Trace Dependent, and
- Remove arrows
To see the full course contents click here.