Some of the most widely used aspects of Excel are not automatically implemented
in the typical setup. For example, one of the classic instances of
this occurs in teaching quantitatively oriented courses. The Data
Analysis tools must be added in before use. This is an example of
what is called an Add-In. There are many others that provide
everything from sophisticated forecasting to special functions.
As a developer there are many reasons why it can be advantageous to develop add-ins.
There are many other reasons, but these should give you some basic motivation for this webpage. Typically, workbooks that benefit the most from being converted to Add-Ins are those that are mostly constituted by general purpose sub/function/macro procedures.
Now we will walk you through adding in the Analysis ToolPak, which will add a new item to the Utilities menu called Data Analysis.
Using an Add-In. You should work through the following steps to add in the Analysis ToolPak.
You should see a dialogue form like the following. Make sure to scroll through it some to see some of the other add-ins that are available.
|The following table describes a few of the add-ins that are available without purchasing anything from a third party source.|
|Access Links||This allows you to use Microsoft Access tables and forms in Excel.|
|Analysis ToolPak||Provides functions and interfaces for financial and statistical data analysis.|
|Analysis ToolPak VBA||Analysis functions that can be used in VisualBasic.|
|Euro Currency Tools||Conversion and formatting for the Euro currency.|
|LookUp Wizard||Helps create formulas to find data in lists/arrays.|
|MS Query||Works with Microsoft Query in macros.|
|ODBC||Open DataBase Connectivity standard allows fairly general accessibility of external data sources.|
|Report Manager||Helps create reports by combining spreadsheet views with data scenarios.|
|Solver||A fairly elaborate tool for optimization and equation solving.|
The following dialogue form should appear. You should scroll through it to see the large variety of tools that are available. Since this is not a course in quantitative methods or statistics we are not going to make much use of these, but this gives you some idea of the power available through add-ins.