Microsoft Office Tutorials and References
In Depth Information
Analyze Data with Scenarios
Analyze Data
with Scenarios
You can analyze the result of a formula by creating
sets of values that enable you to quickly use those
values as the inputs for a formula.
For example, one set of values might represent a
best-case approach, while another might represent
a worst-case approach. In Excel, each of these
coherent sets of input values — known as changing
cells — is called a scenario . By creating multiple
scenarios, you can easily apply these different value
sets to analyze how the result of a formula changes
under different conditions.
Analyze Data with Scenarios
Create a Scenario
1 Set up your worksheet model.
2 Click the Data tab.
3 Click What-If Analysis (
).
4 Click Scenario Manager .
Search JabSto ::




Custom Search