From time to time, you might have noticed the Add-Ins item on the Tools menu and wondered what that option does. Excel add-ins are worksheet tools that bring more power to your desktop. Table 14.2 lists the Excel add-ins and explains what they do.
What It Does
Gives you several worksheet functions and macro functions for financial and scientific data analysis for use in a workbook, the Function Wizard, and the Tools menu.
Analysis ToolPak VBA
Provides developers with Analysis ToolPak syntax tools and functions for financial, statistical, and engineering analysis.
Conditional Sum Wizard
Assists you with summing data in lists.
Euro Currency Tools
Lets you format values as euros and provides the EUROCONVERT worksheet function for converting currencies.
Internet Assistant VBA
Allows developers to publish Excel data to the Web by using Excel 97 Internet Assistant syntax.
Allows you to create formulas to find data in Excel tables.
Lets you determine answers to complex what-if questions or equations by analyzing cells and determining the optimum value adjustments to arrive at a desired result.
If you want to know whether an add-in is installed, choose Tools, Add-Ins. The Add-Ins dialog box appears, as shown in Figure 14.29.
A list of add-ins that are available in Excel appears in the Add-Ins Available list box. If a check mark appears in the check box next to the add-in feature in the Add-Ins Available list, your add-in is installed. If a check box is empty, that add-in isn't installed.
If you want to install an add-in, use the Add/Remove Programs feature in the Windows Control Panel and your Microsoft Office or Microsoft Excel installation CD-ROM.