-->

Microsoft-Excel 2007 Study Material Day-Thirty One

Scenario Manager :
A Scenario can have multiple variables, but it can only accommodate up to 32 values.














Steps :
  • First create above Table
  • Select the input cells (B2,B3,B4) in the above data 
  • Click on Data Tab
  • Then Click on What if analysis
  • Select Scenario Manager

  • Click on Add Button and type Scenario Name "Marketing" (Ctrl + Click cells to select non-adjacent changing cells).













  • Click on OK Button
  • Click on Close Button
  • Enter the New Value in Excel Table















  • Select the input cells (B2,B3,B4) in the above data 
  • Click on Data Tab
  • Then Click on What if analysis
  • Select Scenario Manager 


  • Click on Add Button and type Scenario Name "Finance"(Ctrl + Click cells to select non-adjacent changing cells).













  • Click on OK Button


  • Click on show "Marketing" or "Finance".
  • Click on Close Button

No comments: