Excel Data Analysis
Table of Contents
Chapter 1: Building Formulas for Data Analysis
Reference Another Worksheet Range in a Formula
Switch to Absolute Cell References
Turn On Iterative Calculations
Chapter 2: Troubleshooting Formulas
Understanding Error Values in Excel
Show Formulas Instead of Results
Use a Watch Window to Monitor a Cell Value
Display Text Instead of Error Values
Check for Formula Errors in a Worksheet
Audit a Formula to Locate Errors
Get Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.