Page 88 - Excel 2013 All-in-One For Dummies

70 Add-In Mania
Excel add-in programs are saved in a special file format identified with the .XLA or .XLAM (for Excel Add-in) filename extension. These files are nor- mally saved inside the Library folder (sometimes in their own subfolders) that is located in the Office14 folder. The Office14 folder, in turn, is located in your Microsoft Office folder inside the Program Files folder on your hard drive (often designated as the C:\ drive). In other words, the path is
c:\Program Files\Microsoft Office\Office14\Library
After an add-in program has been installed in the Library folder, its name then appears in the list box of the Add-Ins dialog box.
If you ever copy an XLA add-in program to a folder other than the Library folder in the Office14 folder on your hard drive, its name won’t appear in the Add-Ins Available list box when you open the Add-Ins dialog box. You can, however, activate the add-in by clicking the Browse button in this dialog box and then selecting the add-in file in its folder in the Browse dialog box before you click OK.
Managing Excel add-ins
Whether you know it or not, you already have a group of add-in programs waiting for you to use. The following Excel add-in programs are loaded when you install Excel 2013:
✦ Analysis ToolPak: Adds extra financial, statistical, and engineering func- tions to Excel’s pool of built-in functions.
✦ Analysis ToolPak - VBA: Enables VBA programmers to publish their own financial, statistical, and engineering functions for Excel.
✦ Euro Currency Tools: Enables you to format worksheet values as euro currency and adds a EUROCONVERT function for converting other cur- rencies into euros. To use these tools, click the Euro Conversion or Euro Formatting buttons that appear on the Ribbon in the Solutions group at the end of the Formulas tab.
✦ Solver Add-In: Calculates solutions to what-if scenarios based on
cells that both adjust and constrain the range of values. (See Book VII, Chapter 1.) To use the Solver add-in, click the Solver button that appears on the Ribbon in the Analysis group at the end of the Data tab.
To use one of the additional statistical or financial functions added as part of the Analysis ToolPak add-in, you don’t access the Add-Ins tab. Instead, click the Function Wizard button on the Formula bar, select either Financial or Statistical from the Select a Category drop-down list, and then locate the function to use in the Select a Function list box below.