After opening Excel, click File. At the bottom of the File menu, click Options. Click Add-Ins and then Go… . This opens an additional pop-up window that allows you to select the Analysis ToolPak.
During a What-If Analysis, the worksheet is altered to see how the changes will affect the formulas. Scenarios, Goal Seek, and Data Tables are three types of What-If Analysis tools in Excel. With ...