Using the Analysis Toolpak Data Analysis Tools

The Analysis Toolpak add-in is part of the deal when you purchase Excel 2010, 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

image with no caption

To see whether you have the Analysis Toolpak installed, click the Data tab on the ribbon. If the Data Analysis button is there, you’re good to go. If not, click the File tab, click Options, and select the Add-Ins ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.