scenarios
TRANSCRIPT
![Page 1: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/1.jpg)
Excel ScenariosforData Analysis
![Page 2: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/2.jpg)
What is a Scenario?
• Scenarios are easy-to-use Data Analysis tools • Scenarios give a snapshot of what things would be like if
certain conditions were to change. • A scenario contains sets of values that influence an outcome• They can be used to forecast the effects of just about
anything• They are particularly useful in financial models
![Page 3: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/3.jpg)
Using Scenarios for “What-If” Analysis• Scenarios can be named and saved with different sets of
figures to represent specific values. •When several scenarios have been saved they can be viewed
to compare the different results each would bring. • An example would be where you create a budget but are not
sure of the amount of revenue your business will generate• A scenario can be defined for each predicted revenue figure
and then switched between to calculate “what-if” analysis.
![Page 4: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/4.jpg)
Scenario Reporting
• You can create a Scenario Report from the scenarios you generate• This report can also be turned into a Pivot Table report • This makes it ideal for further analysis• Scenarios are great when the data sets become large.
![Page 5: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/5.jpg)
How to Add a Scenario
• From the Data tab navigate to What-if Analysis• Click Scenario Manager
![Page 6: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/6.jpg)
Adding a Scenario
• The Scenario Manager dialogue box will be displayed• Click Add to add your first set of
figures
![Page 7: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/7.jpg)
Edit the Scenario
• Select the cells that will change • These should be value cells not
formula cells• Click OK
![Page 8: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/8.jpg)
Change the Scenario values
• The Scenario Values dialogue box will be displayed:
• If necessary change the values for the changing cells• Click OK
![Page 9: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/9.jpg)
The first Scenario
• The first Scenario is added
![Page 10: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/10.jpg)
Adding another Scenario
• Click Add to add another scenario• Type the scenario name•Modify the Changing cells • Set any other required
options and click OK
![Page 11: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/11.jpg)
Adding another Scenario
• Change the Scenario values• Click OK
![Page 12: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/12.jpg)
The second Scenario
• The second Scenario is added to the Scenario Manager• Click Add to add another
![Page 13: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/13.jpg)
Adding a Third Scenario
• Enter the name and the changing values• Click Add to add another or OK then Close• The Scenario Manager dialog box closes
![Page 14: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/14.jpg)
Switching between Scenarios
• Click on the name of the scenario and click Show• The appropriate values appear in the spreadsheet•When you have finished click Close.
![Page 15: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/15.jpg)
Switching with the Scenario box
• The Scenario Box is a better way of displaying scenarios• Simply add it to the Quick Access Toolbar• You can switch between scenarios with ease• It makes it very easy to compare different outcomes
![Page 16: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/16.jpg)
Adding the Scenario box
• From the drop-down menu at the right of the Quick Access Toolbar, click Customize Quick Access Toolbar.• Click More Commands
![Page 17: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/17.jpg)
• Under Choose Commands From: pick Commands not on the Ribbon
• Find Scenario in the list and click Add.
Adding the Scenario box
![Page 18: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/18.jpg)
Adding a Scenario Summary
• Add a Scenario Summary from Scenario Manager• Choose either a Scenario summary or a Pivot Table Report• You can change the Result cells for specific results
![Page 19: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/19.jpg)
The Scenario Summary
• The Scenario Summary is added to a new sheet
![Page 20: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/20.jpg)
Scenario Pivot Table Report
• The Pivot Table is also placed on a new sheet
![Page 21: Scenarios](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c39ac1bb61ebdb718b47b3/html5/thumbnails/21.jpg)
Thanks for Watching!Learn more about Outlook at
www.NetresultTraining.co.uk