Welcome to our free Advanced Microsoft Excel tutorial. This tutorial is based on Webucator's Advanced Microsoft Excel 2019 Training course.
In this lesson, you will learn about auditing worksheets.
Lesson Goals
Large spreadsheets are often very complicated with formulas referring to many cells each of which contain their own formulas referring to other cells that might be contained in other worksheets or even other workbooks. Excel's Formula Auditing commands are very helpful when working in large worksheets.
The two most common uses of the Formula Auditing commands are:
Detailed instructions for using the most commonly used Formula Auditing commands follow.
Tracing precedents in Microsoft Excel allows you to visually see which cells impact a given cell. To trace precedents:
In this exercise, you will practice tracing precedents.
Tracing dependents in Microsoft Excel allows you to visually see which cells are impacted by a given cell. To trace dependents:
In this exercise, you will practice tracing dependents.
Sometimes it is useful to see the formulas in all the cells in a worksheet rather than the values. To show formulas: