Formula Auditing and Formula Evaluation is a powerful component in Excel, and today's video lesson goes over the following topics:

- Show Formulas: How to change view to show formulas instead of cell results.

- Formula Evaluation: See how Excel views the formula as you walk your way through the calculations.

- Trace Precedents / Trace Dependents: Helps finding out where your data is coming from and/or going to.

- Watch Window: Allows for user to set certain cells into a window that can be viewed as you switched sheets.

Make sure to download the most recent Master Workbook to follow along:

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…