Pro Armor. From humble beginnings to industry leader, Pro Armor has been doing business for 13 years. Located in Riverside, CA Pro Armor has quickly become a giant in the Off Road Industry.
Goal Seek in Excel: Instructions. 1  To use Goal Seek in Excel, click the âWhat-If Analysisâ button in the âData Toolsâ group on the âDataâ tab in the Ribbon.  Select the âGoal Seekâ¦â command from the drop-down menu to open the âGoal Seekâ dialog box.
d) In the By changing cell box, enter O14, the reference to the cell that contains the value that you want to adjust. e) Click OK and the result would come up as 12.3% after rounding off. I have also created a video to help you understand how to use sensitivity analysis for DCF valuation.n this scenario âGoal Seekâ is an excellent function for sensitivity analysis in Excel. The methodology of using âGoal Seekâ is as follows. a) On the Data tab, click What-If Analysis and then click âGoal Seekâ.