How to Create a Scenario Summary Report in Excel 2010
Using Slicers to Filter Pivot Tables in Excel 2010
How to Use Excel 2010's Goal Seek Feature

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
How to Split Data into Multiple Columns in Excel 2010
How to Import Online Data into Excel 2010 with a Web Query
How to Query an Access Database Table in Excel 2010
Setting Up Your Baseline in Excel Sales Forecasting
How to Evaluate Scenarios with Excel 2010's Scenario Manager