Microsoft Office Tutorials and References
In Depth Information
Using Excel Add-Ins
If you don’t see any of your installed apps in the Apps for Office dialog box
after clicking the My Apps link, click the Refresh link to refresh the list. Use
the Manage My Apps link in this dialog box to keep tabs on all the apps you’ve
installed for Office 2013 and SharePoint as well as uninstall any app that
you’re no longer using.
Using Excel Add-Ins
Excel add-in programs are small modules that extend the program’s power
by giving you access to a wide array of features and calculating functions not
otherwise offered in the program. There are three types of add-ins:
✓ Built-in add-ins available when you install Excel 2013
✓ Add-ins that you can download for Excel 2013 from Microsoft’s Office
Online website ( www.office.microsoft.com )
✓ Add-ins developed by third-party vendors for Excel 2013 that often must
When you first install Excel 2013, the built-in add-in programs included with
Excel are fully loaded and ready to use. To load any other add-in programs,
you follow these steps:
1. Choose File ➪ Options to open the Excel Options dialog box and then
click the Add-Ins tab or press Alt+FTAA.
The Add-Ins tab lists the name, location, and type of add-ins you have
2. Click the Go button while Excel Add-Ins is selected in the Manage
drop-down list box.
Excel opens the Add-Ins dialog box (similar to the one shown in Figure
12-2) showing all the names of the built-in add-in programs you can load.
3. Select the check boxes for each add-in program that you want loaded
in the Add-Ins Available list 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.
4. Click the OK button to close the Add-Ins dialog box.
An alert dialog box may appear, asking whether you want to install each
5. Click the OK button in each alert dialog box to install its add-in.