Using the Scenario Manager to Create Scenarios in Excel

Rather than having lots of different copies of worksheets to look at different options on your spreadsheet you can use scenarios to keep them all together and create a useful summary. This is useful, for example, when you have a budget and there are a number of different variables. A lot of people make copies of the worksheets to make comparisons.
Although this tutorial uses Excel 2003, it works the same on 2007 and 2010 the only difference is that you have to start it buy going to the Data tab on the Ribbon and clicking on the What-If Analysis button and choosing Scenario Manager...
This video, like many on my channel, has been created using Camtasia techsmith.z6rj...
For more tutorials see my website www.jargonfreeh...
I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

[@chilicious7154]

Brilliant - not only did I learn about Scenario Manager but also naming ranges. Thank you so much for sharing!

[@jargonfreehelp]

+Chilicious 7 that's great. I need to do an update but here is more on naming cells and ranges to use them in formulas other than scenario manager and to find cells. I did this back when Excel 2003 was available but still works the same for the most part ruclips.net/video/-07b7LfHSaQ/видео.html

[@DavidErhartUSA]

Very helpful. Thank you for taking the time to explain this clearly with a good example.

[@shreyarawlley3869]

Extremely helpful - thank you so much for this video!

[@SegunAdebayo]

Amazing tutorial. Thank you very much. I just learnt something very important.

[@lynnepike8488]

I have always struggled with Scenarios, but this has made it so easy. Thank you very much

[@AjayKumarparmar]

great example. i also run excel vba channel and this example really keeps me going. good work jargon

[@alejandrotorres9270]

Great Job, thanks. Naming ranges description is brilliant

[@jargonfreehelp]

Thanks. Always nice to hear that.

[@chiragjinx9]

Clear and concise. Thank you, sir.

[@JH-nr9pw]

Thank you! Very clear and not confusing

[@kidsfriendly3583]

Thank you soooo muchhh sir... Man, you're the best teacher ever 🌷🌷🌷🌷🌷🌷

[@jargonfreehelp]

Thank you very much.

[@mickp4281]

Thank you for creating this! Really helped me and both Scenario Manager, and cell naming will be well used by me in the future! :-)

[@jessbray8567]

Great video! Thanks

[@bes4802]

Nice and clear with examples. Thank you so much!!!!

[@subhashini4242]

very good example you gave to explain about scenario manager thank you sir

[@helenclifford6344]

You are amazing, better than my teacher.

[@jargonfreehelp]

Thank you

[@pragyagahatraj9973]

Thank you! It is very helpful

[@jargonfreehelp]

Glad it was helpful!

[@BspoiledscrubsBJ]

i will use this for my supply chain class for the gas and miles scenario great information..

[@shravangattu5783]

Thank you for sharing

[@UrsulaStrydom]

Very good and clear explanation, thank you so much!

[@LD-ji5sz]

This helped a lot. Thank You.

[@pdrg]

Really clear and useful demo thank you

[@subashji]

very good and explained in best way..

[@mariajahan109]

Thanks .. this will help me a lot..🙂.

[@lraras]

Exactly what I needed to see! Thank You!

[@teddysuong263]

Now I can do my homework. Thanks for sharing =))

[@lynneclement6703]

Thank you -- very clear!

[@adighose]

Very good video

[@ajayshirwadkar1625]

Thanks, very useful

[@horebiswajit2010]

THANKS FOR THIS VIDEOS

[@jargonfreehelp]

Biswajit Hore my pleasure

[@shafeekmc2934]

Thank for valuable information..

[@opalparikh6483]

thanks much very easy to follow

[@andrewmarak7578]

Thank you so much sir

[@Rose9427]

Thank u sir.... super explanation...

[@Siberian_valenok]

Thx, awesome! What happens when you save the document, which values get saved??

[@jargonfreehelp]

It keeps the scenarios you have created so you can come back to them. It saves it where you left off.

[@haoliu350]

Thanks, a good tutorial.

[@15110494]

is there a reason why my result cells don't change in the summary? i made sure that my result cells contains a formula with all the variable cells but the resulting cells remains the same throughout all the scenarios

[@Apple-Bay]

hi i would like to ask for your help , i meed to created a price list but is a bit complicit as im not usr to excel
im planning to buy stuff and they are different grade of the same product
example : grade A = 100% Grade B= 85% grade C 65% and so on
many thanks

[@kamleshbhai4679]

Thank you very much

[@wesamaljabsheh5092]

thank u

[@ajufsd]

Awesome . . :)

[@hadiwadod3983]

very good.ممتاز

[@Dilz13]

hello. how did u add that signature to the excel sheet

[@jargonfreehelp]

What signature? Do you mean the logo?

[@Dilz13]

@@jargonfreehelp yes mate...can u teach me tht..how to add a logo or signature to excel sheet,when viewing like this

[@jargonfreehelp]

It was added when I was editing the video. It is not a feature of Excel.

[@106lotus]

thank you!!!

[@trayamsbysaumya6667]

:) thank u

[@taniatishchenko6989]

Good, but TOOO SLOOOOOOOOWWWWW!!!!!!! TAKES YEARS TO REACH THE POINT!

[@xzotzvvs6492]

+Tania Arab,
Some people are full of complain and i think u are one of them.Try and show case your own idea and let us see what you have got.Get a life.