Load and activate the Analysis ToolPak - Windows
-
Click the File tab, click Options, and then click the Add-Ins category.
If you're using Excel 2007, click the Microsoft Office Button , and then click Excel Options
-
In the Manage box, select Excel Add-ins and then click Go.
If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins.
-
In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.
-
If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
-
If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
Note: To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you can load the Analysis ToolPak - VBA Add-in the same way that you load the Analysis ToolPak. In the Add-ins available box, select the Analysis ToolPak - VBA check box.
Load and activate the Analysis ToolPak -Mac OS
Note: Please make sure Mac is updated. This is free for student and employee personal use, and installation directions can be found here: Installing Microsoft Office At Home. For College-owned computers, please contact Information Technology at helpdesk@cedarcrest.edu.
Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac:
-
Click the Tools menu, and then click Excel Add-ins.
-
In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
-
If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
-
If you get a prompt that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
-
Quit and restart Excel.
Now the Data Analysis command is available on the Data tab.