Excel 2010 Bible

Chapter 45: Creating Custom Excel Add-Ins

905

FIGURE 45.1

The Add-Ins dialog box.

The user interface for some add-ins (including those included with Excel) may be integrated into

the Ribbon. For example, when you open the Analysis ToolPak add-in, you access these tools by

choosing Data ➪ Analysis ➪ Data Analysis.

The following table lists the add-ins included with Excel 2010. Some add-ins may not have been

installed. If you try to use one of these add-ins and it’s not installed, you receive a prompt asking

whether you want to install it.

Add-In Name What It Does Where to Find It

Analysis ToolPak Statistical and engineering

tools. See Chapter 38.

Choose Data ➪ Analysis ➪ Data Analysis.

Analysis ToolPak —

VBA

VBA functions for the

Analysis ToolPak.

The functions in this add-in are used by VBA pro-

grammers, and they are not accessible from Excel.

Euro Currency

Tools

Tools for converting and for-

matting the euro currency.

Choose Formulas ➪ Solutions ➪ Euro

Conversion and Formulas ➪ Solutions ➪ Euro

Formatting.

Solver Add-In A tool that helps you to use

a variety of numeric meth-

ods for equation solving

and optimization.

Choose Data ➪ Analysis ➪ Solver.

Add-Ins Included with Excel