excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2007

Samantha has attended:
Excel Introduction course

Excel

what are sinarios

RE: excel

Hi Samantha,

Welcome to the forum, thank you for your post, in response:

A scenario is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to predict the outcome of different situations in your spreadsheet.

For example, you could use a scenario to determine the average temperature if each monthly temperature rose by 2, 5, or 10 degrees. You can create and save different groups of values on a worksheet and then switch to any of those scenarios to view different results.

Scenarios are a great way to explore different values in a spreadsheet and to test out "what-if" possibilities.

1. Start Microsoft Excel and either open a file that includes some formulas that you would like to test, or start from a new spreadsheet, and then type in your text and formulas.
2. Plan how you would like to test different changes to the values in your spreadsheet.
3. To create a new scenario, select Scenarios from the Tools menu.
4. Click Add.
5. In the Scenario name box, type a name for the new scenario.
6. In the Changing cells box, enter the references for the cells that you want to change.

Note: To preserve the original values for the changing cells, create a scenario that uses the original cell values before you create scenarios that change the values.

7. Under Protection, select the options that you want, and then click OK.
8. Next, in the Scenario Values dialog box, type the values that you want for the changing cells and then click OK.
9. If you want to create additional scenarios, click Add again, and then repeat the steps above. When you finish creating scenarios, click OK, and then click Close in the Scenario Manager dialog box.
10. Try out the different scenarios by clicking Scenarios on the Tools menu. See how your spreadsheet changes as you analyse the "what-if" possibilities.

I hope that has given you a bit of an explanation, regards Pete


 

Excel tip:

Generating simple column charts

1.Select cell range containing data/figures
2. Press F11

View all Excel hints and tips


Server loaded in 0.11 secs.