Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 1 Getting Started with Excel 29

When activated, the Data Analysis ToolPak appears in a new group named

Analysis on the Data tab. View the Data Analysis ToolPak now.

To access commands for the Data Analysis ToolPak:

1 Click the Data tab and then click Data Analysis from the Analysis

group.

The Data Analysis dialog box appears as shown in Figure 1-22.

The Analysis group is

added to the Data tab

Data Analysis ToolPak commands

Figure 1-22
Viewing the Data
Analysis ToolPak

The list of commands available with the Data Analysis ToolPak is

shown in the Analysis Tools list box. To run one of these commands,

select it from the list box and then click the OK button. You’ll have

an opportunity to use some of the Data Analysis ToolPak’s com-

mands later in this book.

2 Click Cancel to close the Data Analysis dialog box.