Formula Auditing and Formula Evaluation are powerful components in Excel, and today’s video lesson goes over the following uses of the Formula Auditing features:
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.