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.