Awesome Add-ins for Excel - Centriq Training
Centriq Training Print Logo

Friday

September 22 10:27 AM

75°F Sunny


Blog Banner Graphic

Blog

Awesome Add-ins for Excel

Awesome Add-ins for Excel

August 17, 2017 in Microsoft, Corporate IT Training / by Craig Gerdes

An add-in is a term used for a software utility added to a primary program.  In other words, add-ins are mini applications that extend what you can do with Microsoft Office programs.  When you enable an add-in, it adds custom commands and new features to programs that help increase your productivity.

By default, add-ins are not immediately available, so you must first install (and in some cases activate) these add-ins so that you can use them.  Many of the add-ins are free from the Microsoft Store.  You may also be able to search for add-ins from third party vendors.

To get started, click Insert and then Store.

Awesome-Addins-for-Excel-1

On the dialog box that pops-up, make sure you click the Store tab.  Then you can search by keyword, browse by category, or sort by name, rating, or suggestions.  If you click the add-in before adding it, you can read a description, see ratings and FAQs, and additional information.

Awesome-Addins-for-Excel-2

Once you install the add-in, it will be available to you in the future when you click My Add-ins from the Insert menu.

Awesome-Addins-for-Excel-3Awesome-Addins-for-Excel-4

Then you can double-click the add-in (or select it and click Insert) to add it to your document.  Finally, follow the instructions for each add-in to make it work including adjusting any settings or options.

Here are some popular add-ins for Excel:

Bubbles

Visualize your data and quickly identify patterns in a fun and interactive way.

Awesome-Addins-for-Excel-5

People Graph

Transform raw data into a cool infographic.

Awesome-Addins-for-Excel-6

Bing Maps

Plot locations and visualize your data.

Awesome-Addins-for-Excel-7

Geographic Heat Map

Visualize data across geographic locations. U.S. and world maps are available.

Awesome-Addins-for-Excel-8

Mini Calendar and Date Picker

Add a mini monthly calendar to your spreadsheet and quickly insert dates.

Awesome-Addins-for-Excel-9

Activity Timer

Record activity times using a stopwatch and then copy/paste data into Excel.

Awesome-Addins-for-Excel-10

If you need to disable your add-ins or remove them, you can do so by clicking Manage My Add-ins or by clicking the Options button (…).  You can also read details, ratings, and reviews with the Options button.

Awesome-Addins-for-Excel-11

For more information about Add-ins and other Excel features, take an Excel Class from Centriq. For course descriptions and dates, see our website at http://centriq.com/corporate/class-schedule/?q=Excel.

Be sure to watch for the last blog article in this Excel series. The next topic will feature Super Settings. A free Excel Lunch and Learn on Tuesday, September 12 will feature live demonstrations of all of the items covered during this Excel blog series. If you would like to attend, CLICK HERE to register.