Page 228 - Excel Data Analysis

12 537547 Ch11.qxd 3/4/03 12:48 PM Page 214

EXCEL DATA ANALYSIS

INSTALL EXCEL ADD-INS

ou can use Excel to take advantage of a number of • The Conditional Sum Wizard, which lets you quickly
add-ins — enhancements that provide additional create a formula that only calculates under situations
Y financial and scientific functions and options. In that you specify. For more information, see the section
addition to Excel's add-ins, you can also load add-ins that "Using the Conditional Sum Wizard."
other individuals create. Among the add-ins that come
standard with Excel, you should consider loading: Excel recognizes any file with an .xla file extension as an
add-in, lists them in the Add-ins dialog box, and
automatically loads the add-in files to one of the following
• The Analysis ToolPak, which provides financial and
scientific functions and options. For example, this add-in folders on your hard drive:
contains a set of functions for performing Engineering c:\Program Files\Microsoft Office\Office 10\
calculations, along with other financial, date and time, Addins
and mathematical functions. The Analysis ToolPak also
contains the Statistical Analysis Tools described in this c:\Documents and Settings\user name\
Application Data\Microsoft\Addins
chapter.
After loading the add-ins, Excel adds their new options to its
• The Analysis ToolPak – VBA, which has financial,
menus. For example, if you load the Conditional Sum Wizard,
mathematical, and date and time functions. For example, Excel adds a Conditional Sum option to the Tools menu.
you load the ACCRINT function to calculate the amount
of accrued interest. To free up the memory usage, you should only load the
add-ins that you intend to use and unload add-ins you no
longer need.

INSTALL EXCEL ADD-INS

Analysis ToolPak

⁄ Click Tools ➪ Add-Ins. ■ The Add-Ins dialog box ■ You can click an item in Note: The material in this chapter
displays. the Add-Ins box to view its mainly discusses the Conditional
description. Sum Wizard and the analysis tools
added with the AnalysisToolPak.
¤ Click the Add-ins you
214 want to add.