Formula Auditing & Formula Evaluation

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.