Microsoft Office Tutorials and References
In Depth Information
Making the Case with Scenario Manager
After setting up the various scenarios for a spreadsheet, you can also have
Excel create a summary report that shows both the input values used in each
scenario as well as the results they produce in your formula.
Setting up the various scenarios
The key to creating the various scenarios for a table is to identify the
various cells in the data whose values can vary in each scenario. You then select
these cells (known as changing cells) in the worksheet before you open the
Scenario Manager dialog box by clicking Data ➪ What-If Analysis ➪ Scenario
Manager on the Ribbon or by pressing Alt+AWS.
Figure 8-7 shows the Sales Forecast 2014 table after selecting the three
changing cells in the worksheet — H3 named Sales_Growth, H4 named COGS (Cost
of Goods Sold), and H6 named Expenses — and then opening the Scenario
Manager dialog box (Alt+AWS).
to the Sales