Data+Analysis


 * = What If Analysis = ||
 * What-if analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

Three kinds of what-if analysis tools come with Excel: scenarios, data tables, and Goal Seek. Scenarios and data tables take sets of input values and determine possible results. A data table works only with one or two variables, but it can accept many different values for those variables. A scenario can have multiple variables, but it can accommodate only up to 32 values. Goal Seek works differently from scenarios and data tables in that it takes a result and determines possible input values that produce that result.

In addition to these three tools, you can install add-ins that help you perform what-if analysis, such as the Solver add-in. The Solver add-in is similar to Goal Seek, but it can accommodate more variables.

You can also create forecasts by using the fill handle and various commands that are built into Excel. For more advanced models, you can use the Analysis Pack add-in.

[|Introduction to What-If Analysis] Source: Microsoft.com || Source: Home and Learn Tutorials || Source: Microsoft.com || Source: Dummies.com || Source: Home and Learn Tutorials || Source: Dummies.com || Source: Home and Learn Tutorials || Source: Dummies.com || Source: Microsoft.com || Source: aspfree.com || ||
 * = Data Table Tutorials = ||
 * [|Data Tables in Excel 2007]
 * [|Calculate multiple results by using Data Tables]
 * [|Playing What-If with Excel 2007 Data Tables]
 * = Goal Seek = ||
 * [|Goal Seek in Excel 2007]
 * [|Using Excel 2007's Goal Seek Feature]
 * = Scenario Tutorials = ||
 * [|Scenarios in Excel 2007]
 * [|Evaluating Scenarios with Excel 2007 Scenario Manager]
 * = Solver = ||
 * [|Perform What-If Analysis with the Excel 2007 Solver Tool]
 * [|Using Goal Seek and Solver in MS Excel]
 * Worksheet Download