Page 86 - Excel 2013 All-in-One For Dummies

68 Add-In Mania
Excel then inserts the app into your current worksheet so that you can start using its features. Some Office apps such as the Merriam-Webster Dictionary app and QuickHelp Starter open in task panes docked on the right side of the worksheet window. Others, such as Bing Maps and the Mini Calendar and Date Picker, open as graphic objects that float above the worksheet.
To close Office apps that open in docked task panes, you simply click the pane’s Close button. To close Office apps that open as floating graphic objects, you need to select the graphic and then press the Delete key. (Don’t worry — doing this only closes the app without uninstalling it.)
Note that after you start using various apps in Excel, they’re added to the Recently Used Apps section of the Apps for Office button’s drop-down menu. You can then quickly reopen any closed app that appears on this menu simply by clicking it.
If you don’t see any of your installed apps in the App for Office dialog box after clicking the My Apps link, click the Refresh link to Excel 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 to uninstall any app that you’re no longer using.
Add-In Mania
Add-ins are small, specialized programs that extend Excel’s built-in features in some way. Most of the add-in programs created for Excel offer you some kind of specialized function or group of functions that extend Excel’s com- putational capabilities. Before you can use any add-in program, the add-in must be installed in the proper folder on your hard drive, and then you must select the add-in in the Add-Ins dialog box.
There are two different types of add-in programs immediately available that you can use to extend the features in Excel 2013:
✦ Excel Add-ins: This group of add-ins (also known as automation add- ins) is designed to extend the data analysis capabilities of Excel. These include Analysis ToolPak, Euro Currency Tools, and Solver.
✦ COM Add-ins: COM (Component Object Model) add-ins are designed to extend Excel’s capability to deal with and analyze large amounts of data in data models (collections of related database tables). These include PowerPivot, Power View, and Inquire.
When you first install Excel 2013, 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: