LITMIR.BIZ

       When you first install Excel 2016, the program automatically loads all four add-ins (Analysis ToolPak, Analysis ToolPak – VBA, Euro Currency Tools, and Solver Add-In) displayed in the Add-Ins Available list box. (For more about these add-ins, see the following section, “Managing Excel add-ins.”) The tools in the two Analysis ToolPaks are added as special functions to the Function Library group and the Euro Currency tools to a Solutions group on the Formulas tab. The Solver add-in appears in the Analysis group on the Data tab.

      c: \Program Files\Microsoft Office\Office16\Library

       If you ever copy an XLAM add-in program to a folder other than the Library folder in the Office16 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.

      ✔ Analysis ToolPak: Adds extra financial, statistical, and engineering functions 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 currencies 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.