What if Analysis

[sandeep_1983]

Hi All


Hope you all are enjoying Excel.


I want to use "what if analysis", but not sure how? Please help me on this.

 

[bobhc]

sandeep_1983 I put what if analysis in the search box top right and up pops this very informative link

http://chandoo.org/wp/tag/what-if-analysis/

 

[sandeep_1983]

Thanks Sir


Will definitely go thru the same and will bother you if needed.


Thanks again.

 

[Hui]

Sandeep_1983


Firstly, Welcome to the Chandoo.org forums.


There are 5 areas in Excel for looking at What If's


1. Manual

2. Scenarios

3. Goal Seek

4. Data Tables

5. Solver


Bobhc's link above goes direct to Pt 4.


1. Manual

By design Excel allows you to alter cells and see what the effects on the Outcome/s are


2. Scenario manager: The Excel Scenario manager allows you to save setup configurations as Scenarios and then recall then as you please. eg: Best Case, Worst Case and Most Likely Case

There are also other methodologies for dealing with Scenarios refer:

http://chandoo.org/wp/tag/scenarios/

http://chandoo.org/wp/2011/06/01/switch-scenarios-dynamically-using-slicers/


3. Goal Seek

You probably should look at: http://chandoo.org/wp/2009/07/29/excel-goal-seek-tutorial/


4. BobHC's link above


5. Solver: Have a look at: http://chandoo.org/wp/tag/solver/

 

[Narend]

thanks