How to Install the Data Analysis ToolPak for PC & Mac

This tutorial will demonstrate how to install the Data Analysis ToolPak add-in in Excel for both Mac and PC.

For PC Users:

Click on the File tab on the top left, then select Options.

pc-users-file      pc-users-options

Click Add-ins. Where it says Manage at the bottom, select Excel Add-ins from the drop-down menu and click Go.

pc users add ins

You should have a pop-up window on your screen; make sure Analysis ToolPak is checked.

pc-users-toolpak-select

If Analysis ToolPak does not appear as one of the Available add-ins, then click Browse to locate it. Click Yes to install the pack.

You should now be able to access the Data Analysis command under the Data tab.

pc users data analysis

For Mac Users:

In the top menu bar, navigate to Tools > Add-ins.

mac-users-tools

You should have a pop-up window on your screen; make sure Analysis ToolPak is checked.

If Analysis ToolPak does not appear as one of the Available add-ins, then click Browse to locate it. Click Yes to install the pack.

mac users add ins

mac users access data analysis

You should now be able to access the Data Analysis command under the Data tab.