Using the Scenario Manager to Create Scenarios in Excel

About this tutorial:

Video duration: 9:48
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…


Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

25 thoughts on “Using the Scenario Manager to Create Scenarios in Excel

    Jay Saffarzadeh

    (May 17, 2017 - 7:19 am)

    Very good explain. Great job. Thanks

    rose rose

    (May 17, 2017 - 7:19 am)

    Thank u sir…. super explanation…

    Elena Stanica

    (May 17, 2017 - 7:19 am)

    You are amazing, better than my teacher.

    Gonzalo Fernandez

    (May 17, 2017 - 7:19 am)

    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

    Hao Liu

    (May 17, 2017 - 7:19 am)

    Thanks, a good tutorial.

    Sương Nguyễn

    (May 17, 2017 - 7:19 am)

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

    Chilicious 7

    (May 17, 2017 - 7:19 am)

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

    Lynne Clement

    (May 17, 2017 - 7:19 am)

    Thank you — very clear!

    Ajay Kumar

    (May 17, 2017 - 7:19 am)

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

    Luis Delgado

    (May 17, 2017 - 7:19 am)

    This helped a lot. Thank You.

    Juhi Srivastava

    (May 17, 2017 - 7:19 am)

    🙂 thank u

    Tania Arab

    (May 17, 2017 - 7:19 am)


    Bernette Lowry

    (May 17, 2017 - 7:19 am)

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

    Opal Parikh

    (May 17, 2017 - 7:19 am)

    thanks much very easy to follow

    Ursula Strydom

    (May 17, 2017 - 7:19 am)

    Very good and clear explanation, thank you so much!

    Lynne Pike

    (May 17, 2017 - 7:19 am)

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

    Aju Mohan

    (May 17, 2017 - 7:19 am)

    Awesome .  .  🙂

    Biswajit Hore

    (May 17, 2017 - 7:19 am)


    David Erhart

    (May 17, 2017 - 7:19 am)

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

    Segun Adebayo

    (May 17, 2017 - 7:19 am)

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

    subash Gupta

    (May 17, 2017 - 7:19 am)

    very good and explained in best way..

    Paddy Robinson-Griffin

    (May 17, 2017 - 7:19 am)

    Really clear and useful demo thank you


    (May 17, 2017 - 7:19 am)

    Exactly what I needed to see! Thank You!


    (May 17, 2017 - 7:19 am)

    thank you!!!

    hadi wadod

    (May 17, 2017 - 7:19 am)

    very good.ممتاز

Leave a Reply

Your email address will not be published. Required fields are marked *