Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1

24 Excel


Excel then saves the workbook under the name Park Usage Report. Note
that if you can save the workbook under a variety of formats by clicking the
Save as type list box and choosing a fi le type.

Excel Add-Ins


Excel’s capabilities can be expanded through the use of special programs
called add-ins. These add-ins tie into Excel’s special features, almost look-
ing like a part of Excel itself. Various add-ins that allow you to easily gen-
erate reports, explore multiple scenarios, or access databases are supplied
with Excel. To use these add-ins, you have to go through a process of saving
the add-in fi les to a location on your computer, and then telling Excel where
to fi nd the add-in fi le.
Excel comes with an add-in called Analysis ToolPak that provides some
of the statistical commands you’ll need for this book. Another add-in, Stat-
Plus, you have already copied to your hard disk. Now you will install the
add-in in Excel.

Loading the StatPlus Add-In


The add-ins on your computer are stored in a list in Excel. From this list,
you can activate the add-in or browse for new ones. First you’ll browse for
the StatPlus add-in.

To browse and install the StatPlus add-in:

1 Click the Offi ce button and then click Excel Options located at
the bottom of the pop-up menu.
2 Click Add-Ins from the list of Excel options as shown in Figure 1-18.
Free download pdf