Using the Scenario Manager to Create Scenarios in Excel

25
197




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…

For…

25 COMMENTS

  1. 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here