In the Data Tools group, click the What-if Analysis drop-down and choose Scenario Manager (Figure B). Figure B Click Add and give the scenario a name, such as BestCase ( Figure C ), and click OK.

In Excel 2003, choose Goal Seek from the Tools menu. Enter -1200 in the To value control and C4 in the By changing cell control. Click OK to see the results ( Figure E ).

How Do I Add Power View To Excel 2016? Select File -> Options -> Add-Ins from the Excel 2016 menu. COM Add-Ins can be selected from the drop-down menu, then you should click Go. COM Add-Ins dialogue ...