Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Using Built-in Add-In Programs in Excel 2010

Add-in programs are small modules that extend the power of Excel 2010 by giving you access to a wide array of features and calculating functions not otherwise offered in the application. There are three different types of add-ins:

  • Built-in add-ins available when you install Excel 2010.

  • Add-ins that you can download for Excel 2010 from Microsoft Office Online.

  • Add-ins developed by third-party vendors for Excel 2010 that often must be purchased.

When you first install Excel 2010, the built-in add-in programs included with Excel 2010 are not loaded and therefore are not yet ready to use. To load any or all of these built-in add-in programs, follow these steps:

  1. Click the File tab and then click Options.

    The Excel Options dialog box appears.

  2. Click the Add-Ins tab.

    The Add-Ins tab lists all the names, locations, and types of add-ins to which you have access.

  3. At the bottom of the dialog box, select Excel Add-Ins from the Manage drop-down box and click Go.

    Excel opens the Add-Ins dialog box showing all the names of the built-in add-in programs you can load.

    Activating built-in add-ins in the Add-Ins dialog box.
    Activating built-in add-ins in the Add-Ins dialog box.
  4. 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.

  5. Click OK.

    An alert dialog box appears, asking you if you want to install each selected add-in.

  6. Click OK in each alert dialog box to install its add-in.

Excel automatically places command buttons for the activated add-ins in either an Analysis group on the Ribbon's Data tab or in a Solutions group on the Formulas tab, depending upon the type of add-in.

If you end up never using a particular add-in you've loaded, you can unload it (and thereby free up some computer memory) by following the previously outlined procedure to open the Add-Ins dialog box and then clicking the name of the add-in to remove the check mark from its check box. Then click OK.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.