What is Scenarios and How to Use It in Microsoft Excel

A scenarios is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.

Steps to perform scenarios in MS Excel 2003 are ::

Select only data (not heading & item name) > Go to Tools menu > Scenario > Add > Type scenario name > OK > Cell address for changing data > OK > Scenario Values dialog box open, enter the new value > OK > Scenario Manager dialog box opens, click on Summary > Result Cells > OK
    

   

     


Steps to Edit Scenarios in MS Excel 2003

Go to Tools menu  >  Scenarios  >  Click on the  name of the scenarios which you want to edit, and then click Edit  >  Make the changes you want  >  In the Scenarios Values dialog box, type the values you want for the changing cells  >  To save the changes click OK. 

To return to the Scenarios Manager dialog box without changing the current scenarios, click Cancel.
What is Scenarios and How to Use It in Microsoft Excel What is Scenarios and How to Use It in Microsoft Excel Reviewed by Mani on November 22, 2012 Rating: 5

No comments:

Powered by Blogger.