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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9Md5W8hQijGdJUEvYeD18OwmTkq74g1IgdQo5zl6M6C3h2-siqulWX7imGSuU6uamJv4gesvGsJoaEALo3VA34Mp4sgiVCmRrmYkMRqce0iaRv6CyyqwklCMmvX7aGTQDWWoZzI8kIQQ/s400/sc1.jpg)
- 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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOdUGjT-38G0DprfY9aSRyyiEhLEjCXOykh9wutJ1b3fDObODJ-L84acEVqbHAXGGlfDTeD5mVrvXELIdPsM522c2IeVaozSWByGBW5MdxCu_GH__YlFZhVyI2q7aFJ9taDe-RE6oxXkw/s400/sc4.jpg)
- Click on Add Button and type Scenario Name "Finance"(Ctrl + Click cells to select non-adjacent changing cells).
- Click on OK Button
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhid3544DxPVniU4WSzLkiSLq6GaOcFS2sMOF7P0ikQquEt0MNCG9IdDmGKMU0dZU0t8-dpcdczIKsANC_ss2F6EtMxhN3t0otU2Ap4R5iblsDcsmEkjPKqojrVKLzPkP2rX8duS1NBsGI/s400/sc6.jpg)
- Click on show "Marketing" or "Finance".
- Click on Close Button
Follow @Sarvavasi.com