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: excelexposure.com/workbook
Loading more stuff…
Hmm…it looks like things are taking a while to load. Try again?