Excel 2016 All-in-One For Dummies. Harvey Greg
you first install Excel 2016, the add-in programs included with Excel are not loaded and therefore are not yet ready to use. To load any or all of these add-in programs, you follow these steps:
1. Click the File menu button, click Excel Options or press Alt+FT to open the Excel Options dialog box, and then click the Add-Ins tab.
The Add-Ins tab lists all the names, locations, and types of the add-ins to which you have access.
2. (Optional) In the Manage drop-down list box at the bottom, Excel Add-Ins is selected by default. If you want to activate one or more of your COM add-ins, select COM Add-Ins from the Manage drop-down list.
3. Select the Go button.
If Excel Add-Ins was selected in the Manage drop-down list box, Excel opens the Add-Ins dialog box (similar to the one shown in Figure 2-13), showing all the names of the built-in add-in programs you can load. If COM Add-Ins was selected, the COM Add-Ins dialog box appears instead.
4. Click the check boxes for each add-in program that you want loaded in the Add-Ins or COM Add-Ins dialog box.
Click the name of the add-in in the Add-Ins Available list box to display a brief description of its function at the bottom of this dialog box.
5. Click the OK button to close the Add-Ins or COM Add-Ins dialog box.
Figure 2-13: Activating built-in Excel add-ins in the Add-Ins dialog box.
Excel add-in programs are saved in a special file format identified with the .XLL or .XLAM (for Excel Add-in) filename extension. These files are normally saved inside the Library folder (sometimes in their own subfolders) that is located in the Office16 folder. The Office16 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\Office16\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.
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 2016:
✔ 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.
The following COM add-in programs are included when you install Excel 2016:
Конец ознакомительного фрагмента.
Текст предоставлен ООО «ЛитРес».
Прочитайте эту книгу целиком, купив полную легальную версию на ЛитРес.
Безопасно оплатить книгу можно банковской картой Visa, MasterCard, Maestro, со счета мобильного телефона, с платежного терминала, в салоне МТС или Связной, через PayPal, WebMoney, Яндекс.Деньги, QIWI Кошелек, бонусными картами или другим удобным Вам способом.