Advanced Excel 2007
© Premier Training Limited 2002 – 2007
The result is that you will have to sell 29 books to achieve the
target of £200.
A scenario is a set of values you use to forecast the outcome
of a worksheet model. You can create and save different
groups of values on a worksheet and then switch to any of
these new scenarios to view different results.
Excel has a function called the Scenario Manager which
enables you to create and save different scenarios and view
them one at a time.
Creating A Scenario
In the above example is the commission for the number of
training material sold. The commission is based upon the
number of books, CBT and videos sold. We are going to do a
What-If analysis on the number of items sold.
1. Select the cells that will change in the scenario. In this
case cells B7:D7.
2. From the Data Tools group in the Data Ribbon click onto
the drop down arrow next to What-if Analysis.
3. Select Scenario Manager.