Microsoft Office Tutorials and References
In Depth Information
Making the Case with Scenario Manager
Figure 8-8:
Scenario
Summary
report
showing
the various
scenarios
added to
the Sales
Forecast
2014 table.
Performing what-if analysis with the Solver add-in
In addition to the straightforward what-if
analysis offered by the Scenario Manager, Goal Seek,
and Data Table options on the What-If Analysis
button’s drop-down menu on the Data tab of the
Ribbon, Excel 2013 supports a more complex
what-if analysis in the form of the Solver add-in
program (see Chapter 12 for information on
addins). With the Solver, you can create models that
not only involve changes to multiple input values
but also impose constraints on these inputs or
on the results themselves. For details on using
the Solver in Excel 2013, see my Microsoft Excel
2013 All-in-One For Dummies .
Search JabSto ::




Custom Search