To use the Analysis ToolPak in Excel, however, you need to load it first.

[Lin Weidong]

In Excel 2010, improvements have been made to many of the functions that the Analysis ToolPak uses. Read a blog post or try Office 2010!

The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.

To use the Analysis ToolPak in Excel, however, you need to load it first.

1.     Click the Microsoft Office Button , and then click Excel Options.

2.     Click Add-Ins, and then in the Manage box, select Excel Add-ins.

3.     Click Go.

4.     In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

1.     Tip    If Analysis ToolPak is not listed in the Add-Ins available box, clickBrowse to locate it.

2.     If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

5.     After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.

 

http://office.microsoft.com/en-us/excel-help/load-the-analysis-toolpak-HP010021569.aspx