Creating Scenarios and Scenario Manager

I have created Scenarios in Excel before and an trying to 'teach myself' from
the Help menu but am getting rather confused.......

Is there a difference between creating a Scenario and using Scenario
Manager?? I understand that the Scenario Manager allows you to create
various scenarios so you can change particualar figures on your worksheet and
it shows you each for comparison. The bit I think I am getting confused with
- do you create the Scenario yourself or is there a formula Excel does for
you???

I'm gettin' a bit lost!!!

Any help/advice would be appreciated.

Thank you.

Louise

You set up the Scenarios yourself, then use the Scenario Manager to show
or summarize them. There's an example here:

http://www.contextures.com/xlScenario01.html

Louise wrote:
> I have created Scenarios in Excel before and an trying to 'teach myself' from
> the Help menu but am getting rather confused.......
>
> Is there a difference between creating a Scenario and using Scenario
> Manager?? I understand that the Scenario Manager allows you to create
> various scenarios so you can change particualar figures on your worksheet and
> it shows you each for comparison. The bit I think I am getting confused with
> - do you create the Scenario yourself or is there a formula Excel does for
> you???
>
> I'm gettin' a bit lost!!!
>
> Any help/advice would be appreciated.
>
> Thank you.
>
> Louise


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks very much for this, Debra. These examples are much easier to
understand. The others I have read lead me to believe that the Scenarios
themselves are created by Excel too.

Thanks again.

"Debra Dalgleish" wrote:

> You set up the Scenarios yourself, then use the Scenario Manager to show
> or summarize them. There's an example here:
>
> http://www.contextures.com/xlScenario01.html
>
> Louise wrote:
> > I have created Scenarios in Excel before and an trying to 'teach myself' from
> > the Help menu but am getting rather confused.......
> >
> > Is there a difference between creating a Scenario and using Scenario
> > Manager?? I understand that the Scenario Manager allows you to create
> > various scenarios so you can change particualar figures on your worksheet and
> > it shows you each for comparison. The bit I think I am getting confused with
> > - do you create the Scenario yourself or is there a formula Excel does for
> > you???
> >
> > I'm gettin' a bit lost!!!
> >
> > Any help/advice would be appreciated.
> >
> > Thank you.
> >
> > Louise
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome. Thanks for letting me know that it helped.

Louise wrote:
> Thanks very much for this, Debra. These examples are much easier to
> understand. The others I have read lead me to believe that the Scenarios
> themselves are created by Excel too.
>
> Thanks again.
>
> "Debra Dalgleish" wrote:
>
>
>>You set up the Scenarios yourself, then use the Scenario Manager to show
>>or summarize them. There's an example here:
>>
>> http://www.contextures.com/xlScenario01.html
>>
>>Louise wrote:
>>
>>>I have created Scenarios in Excel before and an trying to 'teach myself' from
>>>the Help menu but am getting rather confused.......
>>>
>>>Is there a difference between creating a Scenario and using Scenario
>>>Manager?? I understand that the Scenario Manager allows you to create
>>>various scenarios so you can change particualar figures on your worksheet and
>>>it shows you each for comparison. The bit I think I am getting confused with
>>>- do you create the Scenario yourself or is there a formula Excel does for
>>>you???
>>>
>>>I'm gettin' a bit lost!!!
>>>
>>>Any help/advice would be appreciated.
>>>
>>>Thank you.
>>>
>>>Louise

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html