Using Data Tables
A data table, or sensitivity table, summarizes the impact of one or two variables on formulas that use those variables. You can click the What-If Analysis button in the Data Tools group on the Data tab and then click Data Table to create two kinds of data tables: tables based on a single input variable that test the variable’s impact on more than one formula, and tables based on two input variables that test their impact on a single formula.
Note
Some of the most powerful tools Excel offers for performing what-If analysis are not covered in this chapter because they are awesome enough to have a chapter of their own. Take a look at ...
Get Microsoft® Excel® 2010 Inside Out 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.
