Awesome Add-ins for Excel
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.
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.
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.
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:
Visualize your data and quickly identify patterns in a fun and interactive way.
Transform raw data into a cool infographic.
Plot locations and visualize your data.
Geographic Heat Map
Visualize data across geographic locations. U.S. and world maps are available.
Mini Calendar and Date Picker
Add a mini monthly calendar to your spreadsheet and quickly insert dates.
Record activity times using a stopwatch and then copy/paste data into Excel.
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.
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 https://www.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.