Using the Analysis Toolpak Data Analysis Tools

The Analysis Toolpak add-in is part of the deal when you purchase Excel 2007, although you might not know it. Add-ins are little packages of tools that more or less seamlessly integrate into the user interface of Excel. However, they require you to install them first. The following sections discuss the installation of, and the tools included with, the Analysis Toolpak.

Installing the Analysis Toolpak

To see whether you have the Analysis Toolpak installed, click the Data tab on the Ribbon. If the Data Analysis button is there, then you’re good to go. If not, click the Microsoft Office Button, click Excel Options, and select the Add-Ins category. In the Manage list at the bottom of the dialog box, select ...

Get Microsoft® Office Excel® 2007 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.