Enable the Analysis ToolPak in Excel

Add to Favorites

How to enable the Analysis ToolPak in Excel.

This is an add-in program that comes with Excel and allows you to use powerful statistical and engineering analysis features.

Steps to Enable the Analysis ToolPak

  1. Click the File button (Microsoft Office Button for Excel 2007).
  2. Click Options from the left side of the menu that appears (Excel Options for Excel 2007).
  3. Click the Add-Ins option from the left side of the window that opens.
  4. Look to the bottom of the window for a drop-down menu that says Manage: next to it.  Click it and make sure it says Excel Add-ins and then click the Go... button.
  5. In the window that opens, select the Analysis ToolPak option and any other options you want.  Then hit the OK button.
  6. That's it.  Now, go to the Data tab and look all the way to the right and you will see the new button Data Analysis. That button takes you to all of the new statistical analysis feature that you can now use in Excel.


If you have the Analysis ToolPak already installed, you will find it on the Data tab all the way to the right.  There will be a button that says Data Analysis and that takes you to all of the Analysis ToolPak features.

To remove the Analysis ToolPak from Excel, follow the same steps as above except that in step 5 you will un-check the feature you no longer want instead of checking it.

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Print Preview Screen Display for The Entire Workbook in Excel
Macro: This free Excel macro allows you to quickly and easily display the print preview windo...
How to use the CONVERT Function in Excel
Tutorial: Use the CONVERT function in Excel to switch between measurements, including distance, tem...
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Minimize or Maximize the Ribbon Menu in Excel
Tutorial: This is a simple way to get more space in Excel, reduce clutter, and streamline the inte...
Display the Print Window in Excel
Macro: This free Excel macro displays the print window or dialog box in Excel. This is the s...
NOW() - Display The Current Time in Excel
Tutorial: This Excel tip will show you how to display the current time within any Excel spreadsheet....