Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Advanced
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel Advanced
Resolved · Medium Priority · Version 2003
Reply Wed 28 Jan 2009, 16:36Delegate Stefania said...
Stefania has attended:
Excel Introduction course
Outlook Advanced course
Outlook Introduction course
Excel Intermediate course
Excel Advanced course
Word Introduction course
Word Intermediate course
Word Advanced course
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
Dreamweaver Introduction (2 days) course
Excel Advanced
Hi,
I know that "Scenario manager" enables me to "try out" a set of values and watch the effect they have on some value which has been calculated using formula beacuse the teacher told me at the course, but I don`t remember how to do it.
Thanks a lot for your help
Stefania
For upcoming training course dates see: Pricing & availability
RE: Excel Advanced
Hi Stefania
To create a scenario, go to Tools - Scenarios.
Click Add to create a scenario.
Under Scenario Name, give the scenario a name.
In Changing Cells, select the cells that contain the values you are going to want to change in the different scenarios you are going to create. These cells must contain numbers/values, not formulas.
Click OK.
At the next screen, either leave the values in the changing cells as they are (if you have already entered the values you want to use) or enter values you want to put into the changing cells.
Click OK when you've finished putting in the Scenario Values.
Then repeat the above, entering different scenario names and values as many times as required.
There is an example you can follow on the page below if you like:
http://www.contextures.com/xlScenario01.html
Kind regards
Amanda
Fri 6 Feb 2009: Automatically marked as resolved.
|