tool, known as the Solver, to deal with such problems. The Solver works by carrying
out a smart search over all possible solutions. Details of Solver and how to use it are
beyond the scope of this book.
Scenario Manager
We have already looked at the Data Tableand Goal Seekingfeatures of the What-If-
Analysis command in Excel. The remaining option of the What-If-Analysis is the Scenario
Manager feature that enables you to define different scenarios and the correspond-
ing outcome in each case. The Scenario Manager is a useful tool to summarize different
options for an activity, say budgeting ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.