scenarios

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Scenarios

resolvedResolved · Low Priority · Version 2003

Samantha has attended:
Excel Advanced course
Excel Advanced course

Scenarios

How do I create a scenario?

RE: Scenarios

Hello Samantha

Thank you for your question and welcome to the forum.

When working with scenarios, it is a good idea to save the original spreadsheet that you start with as a scenario first.

To do this:

1. Go to Tools - Scenarios.

2. Then click the Add button.

3. Enter a name for your scenario.

4. In the changing cells box, select the cell or cells you will be altering in other scenarios that you will be creating to compare with the original version of the spreadsheet you are saving now.

5. Click OK.

6. At the next screen, you don't need to change the values in any of the cells you have selected to change, just click OK.

This then brings you back to the first Scenarios window.

To create additional scenarios, follow steps 2 through to 6, entering the values that you want to change in your changing cells at step 6.

To view various scenarios, go to Tools - Scenarios, select the scenario you want to view and click Show.

I hope this helps.
Amanda


 

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips


Server loaded in 0.09 secs.