Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Scenarios
Resolved · Low Priority · Version 2003
Samantha has attended:
Excel Advanced course
Excel Advanced course
How do I create a scenario?
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 BoxWhen you are saving (or opening) a file, try these; |
We'll call during UK business hours
Server loaded in 0.09 secs.