THE GOAL SEEK TOOL || How to use Goal Seek Command In Microsoft Excel? || MS-Excel Tips

 The Goal Seek Tool 

The Goal Seek tool can be very useful in a forecasting situation. Your forecast predicts that you in December will reach sales of £ 9,000.00 but you really need the sales to be £ 10,000.00. 

The Goal Seek tool can now tell you what to do to get what you want. Open up the Goal Seek tool by clicking the Data tab and click the What-if Analysis button in the Data Tools group. Click Goal Seek and the Goal Seek dialog box will open. Click in the Set Cell: box and select the cell with the value you want to change. Click in the To Value: box and type the value you want the Set cell: cell to have. Click in By Changing Cell: box and click the cell you want Excel to change to get the result you want in the Set Cell: cell.

Click OK and you will get the result.

Procedures

1.       To create a scenario summary report, first click the Data tab.

2.       Click the What-If Analysis button.

3.       Click the Scenario Manager… button.

4.       In the Scenario Manager dialog box, click the scenario you want to view.

5.       Click the Summary… button.

6.       In the Scenario Summary dialog box, click the OK button.

7.       A Scenario Summary worksheet is displayed with the report.

8.       The effect for that scenario is now displayed.