Creating a scenario

Create a scenario to manage and view data from different input values.

We start with a worksheet that already contains the data and formulas. The cells which are colored in grey color contain a formula wherein the result will change automatically when the data is modified in the other cells (input cells).

• Give a name to the input cells (this is easy when creating scenarios).

 

We make two scenarios:

• First select the cells (input cells) in which you can enter the changes (keep the Control button pressed).

• From the Tools menu (Tools), choose the ‘Scenario Manager’ (scenarios) option
• In the ‘Scenario Manager’ window click ‘Add’ (Add)

• Enter a name to the scenario eg: pcs / advertising
• Click OK
• Change the values of input cells in the next dialog
• Change the number of items and the amount of advertising

• Click OK
• The scenario manager appears again
• Click on “Add” (Add) for the second scenario
• Enter a new scenario name: eg: wages / advertising
• Click OK
• Change the values for items and wages
• Click OK
• Click ‘Close’
• Activate the ‘Scenarios” toolbar to view different scenarios

If this is not available, you can create this. (See Lesson 5: efficient use of toolbars)

Creating Summary Reports

If you want to see all the scenario data simultaneously, you can make a report in which all scenarios are executed.
Excel inserts a formatted summary report on a separate worksheet:

• Choose the ‘scenario management’ option from the Tools menu
• Click on the summary button
• Choose ‘Scenario summary’ (Scenario summary) for the report type
• Fill in the result cells:

• Press OK
• A new worksheet appears

• You can always format the worksheet as you wish.
• The buttons at various summary levels are available as active.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats