How to Download Data Analysis for Excel on PC or Mac

Co-authored by wikiHow Staff

Last Updated: May 7, 2018 Tested

This wikiHow teaches you how to install and enable the Data Analysis tool in your Data toolbar on Microsoft Excel, using a computer.

Method 1

Method 1 of 2:
Using Windows

1
Open the Excel file you want to analyze. Find the Excel file you want to edit on your computer, and open it.
2
Click the File tab. This button is next to Home in the upper-left corner of the app window. It will open the Info page.
3
Click Options on the left panel. You'll find it at the bottom of the green menu panel on the left-hand side of your screen. It will open a new pop-up window.
4
Click Add-ins on the pop-up menu. This option is between Quick Access Toolbar and Trust Center on the left-hand side of the pop-up window.
5
Select Analysis ToolPak on the list. Find this option on the Add-ins list, and click it.
6
Click the Go button. This button is at the bottom of the pop-up window. It will open a new pop-up.
7
Check the box next to Analysis ToolPak. Find this option in the Add-ins pop-up, and make sure the box next to it is checked.
8
Click OK. This button is in the top-right corner of the Add-ins window. This will add the Data Analysis tool to your Data toolbar.

Method 2

Method 2 of 2:
Using Mac

1
Open the Excel file you want to analyze. Find the Excel file you want to edit on your computer, and open it.
2
Click the Tools tab on your menu bar. This button is between Format and Data on the menu bar at the top of your screen. It will open a drop-down menu.
3
Click Add-ins on the Tools menu. This will open a list of all your available add-ins in a new pop-up window.
4
Check the box next to Analysis ToolPak. Find this option in the Add-ins pop-up, and make sure the box next to it is checked.
5
Click OK. This button is in the bottom-right corner of the Add-ins window. It will add the Data Analysis tool to your Data toolbar.

You Might Also Like

About This Article

Co-authored by:

wikiHow Staff Writer

This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 15,448 times.

How helpful is this?

Co-authors: 1

Updated: May 7, 2018

Views: 15,448

Categories: Microsoft Excel