Excel Tutorial

Excel Add-Ins

Add-Ins are supplemental programs that adds custom commands or custom features to Microsoft Excel.

Add-in programs in Excel

The add-in programs listed in the following table are installed by default in one of the following places:

The Library folder or the Addins folder, or one of their subfolders, in the Microsoft Office\Office folder.

If the add-in program you want is not in the list under Add-Ins available in the Add-Ins dialog box, you might be able to install the add-in from the Microsoft Office Web site.

Add-in Description
Analysis ToolPakAdds financial, statistical, and engineering analysis tools and functions.
Analysis ToolPak VBAAllows developers to publish financial, statistical, and engineering analysis tools and functions using Analysis ToolPak syntax.
Conditional Sum WizardCreates a formula that sums data in a range if the data matches criteria you specify.
Euro Currency ToolsFormats values as euros, and provides the EUROCONVERT worksheet function to convert currencies.
Internet Assistant VBAAllows developers to publish Excel data to the Web by using Internet Assistant syntax.
Lookup WizardCreates a formula to look up data in a range by using another known value in the range.
Solver Add-InCalculates solutions to what-if scenariosbased on adjustable cells and constraint cells.