Updated: Jan Microsoft Excel is by far the most used application for data analysis.
Mastering Excel is a must-have skill in many companies. It can also be a huge time-saver: an Excel master can be tens or hundreds of times more productive than a beginner. In this post, we list and describe over 75 add-ins, plugins and apps that complement Microsoft Excel with additional features and options to be even more productive and impress with your abilities with Excel.
Some of them are free and some are not, but each of them perform tasks that can greatly help you becoming an Excel rock star. It has dozens of impressive features designed for anyone who use the Office Suite on a frequent basis:.
Tools to clean your data from merged cells, remove empty cells or simplify formulas. Click to watch the demo video of Power-user:. You have to start by connecting it to your data. Tableau claims its software is one of the fastest on the market; a well-created Tableau report should allow to quickly filter or zoom on part of the data to answer a specific question. Tableau is available on both Windows and iOS. Some of your data can be linked between Excel and your accounting system.
Excel Stock Market Functions is available on Windows only. The cons of this add-in is that is has a lot of features, but a large numbers of them you will probably never use. The pros is that several tools can be really useful, such as the possibility to paste data only to visible cells, to count cells by colors or to combine sheets. Basically, PowerPivot could be described as "Microsoft Access for dummies".
Since ExcelPowerPivot is built-in and doesn't need to be downloaded. You can activate it like any add-in. For prior versions of Excel, you need to download it from the Microsoft website. GL stands for the accounting term General Ledger. Using XLGL, you can use formulas to work with updated data on customer orders, employee hours, inventories, etc.
For instance, you can leave comments or questions for analysts to take into account later, or you can deconstruct Excel formulas to track errors or components. Analystix Tools works on Excel and later on PC.Learn how to build, test, debug, and publish Excel add-ins.MS Excel 2016: Create an Excel Addin in VSTO Ribbonbar
Learn about the components and capabilities of an Excel add-in. Learn how to add custom functions to Excel. Learn how to test and debug an Excel add-in.
Learn how to deploy and publish an Excel add-in. All Office Add-ins are built upon the Office Add-ins platform. They share a common framework through which certain capabilities can be implemented. Explore the following articles for information that's relevant to building any Office Add-in. Note : See the Core concepts section of this documentation for the full set of articles that apply to all types of Office Add-ins.
For information about additional resources, see Office Add-ins additional resources. Skip to main content. Exit focus mode. Overview Learn about the components and capabilities of an Excel add-in. Custom functions Learn how to add custom functions to Excel. Testing and debugging Learn how to test and debug an Excel add-in. Publishing Learn how to deploy and publish an Excel add-in. Fundamental concepts Learn basic concepts about Office Add-ins. Advanced concepts Explore key aspects of Office Add-ins development.
Ask questions. Request features. Report issues.Quantity Discounts Money back guarantee. Need more help? We're here 7 days a week.
Excel add-ins overview
Call us at US or e-mail us and let us know what you need. Odds are we have a Microsoft Excel add-in that will do what you want or we may create it! What is an Add-in? An add-in is software that adds new features into Microsoft Excel. Add-ins save you time. Using an add-in helps to avoid errors and do repetitious work in minutes that could take hours manually.
The Spreadsheet Assistant adds over time saving features to Microsoft Excel. We have created 78 Microsoft Excel add-ins to do many tasks related to data, accounting, business analysis, charting, and specialty needs.
All are menu driven for ease of use and all have help and exercise files to make learning to use easy. And, we have two downloadable books on how to write your own Excel macros.
The following are the top reasons why customers said they purchased our Excel add-ins:. Quick answers to questions you may have on our Microsoft Excel add-in products:. You can also browse for an add-ins by any of the following add-in categories :.
East Coast Time 7 days a week. Complete add-in list New add-ins Free add-ins Trial versions Accounting add-ins Business and risk analysis add-ins Charting add-ins Data add-ins Downloadable macro books Specialty add-ins Time Saving add-ins Our favorites. Download information Download purchased software Add-in improvements and upgrades Trial versions.
Let us connect computers. About Add-ins. View Cart. Or browse our complete list of all our Excel add-ins. If the Excel add-in you want is not in the above list, then use the search box at the top right to find it among our 78 Excel add-ins. Copyright Add-ins. Spreadsheet Assistant is a registered trademark of Add-ins.Quantity Discounts Money back guarantee.
All of our add-ins work in Excel to and Office All work in 32 and 64 bit Windows 7, 8, and Windows 10 All work in 32 and 64 bit Microsoft Excel. The Productivity Suite has all of our add-ins. The Spreadsheet Assistant is our most popular add-in.
The following are our ribbon tabs, which provide quick access to all of our add-ins:. We have the following collections:. Any new add-ins we add to a collection you purchase in the year following your purchase are free! Just log back in with your download information to get the new add-ins. East Coast Time 7 days a week. Complete add-in list New add-ins Free add-ins Trial versions Accounting add-ins Business and risk analysis add-ins Charting add-ins Data add-ins Downloadable macro books Specialty add-ins Time Saving add-ins Our favorites.
Download information Download purchased software Add-in improvements and upgrades Trial versions. Let us connect computers. About Add-ins. View Cart. Top reasons to use our products:. Copyright Add-ins. Spreadsheet Assistant is a registered trademark of Add-ins.Excel Add-Ins are similar to smart phone apps and graphic plug-ins.
That is, they are separate applications written by independent programmers that provide enhanced capabilities for the primary software. Most Add-Ins are either free or have a minimal cost and, generally, use very little memory. Add-Ins are very diverse, so they function quite differently. These are the 10 main types, though many of these categories overlap:. Many of them are backward- and forward-compatible, but check the system requirements before you download anything.
50 Best Excel Add-Ins That Will Make Your Life Easier
Generally, the Active Add-Ins are displayed somewhere on the Ribbon menu. There are two ways to locate and install Excel Add-Ins. The first way is to search online for Excel Add-Ins, browse and review the many hundreds of applications, access the website with the Add-Ins you like, then download and install the application directly from that website. The second way is to search and install the Add-Ins directly from Excel.
In the Apps for Office section, select an individual category or click All ; or enter an Add-In type in the Search box. Also, note that if the Add button says Try instead of Addthe application is not free. Most of the fee-based Add-Ins charge minimal fees, but a few of them are actually very expensive.
Be sure to check this before you download the app. Notice that the SmartCharts Add-In starts out with a menu, which is active and ready for you to begin using.
We tested most of the Add-Ins mentioned in this article, and many of those that received low ratings are actually quite helpful.
Add or remove add-ins in Excel
Also, I have Excel and Exceland everything we tested here works in both versions probably because they are so similarregardless of the versions listed some Add-Ins need to be updated. Now that you understand how to locate and install Excel Add-Ins, here below are some of our favorites. Note that some are new and some have been around for a while. Time management Add-Ins are very popular because they track your activities, then produce a host of reports to illustrate how you and your staff spend your time.
This Add-In time tracker is part of the XLTools suite, which is accessed directly through the Ribbon menu on its own tab.
Use the Popup Clock to populate an entire range with time values. You can insert time data into tables, columns, rows, merged cells, non-adjacent cells, or any custom range and the settings can all be customized. Utility Add-Ins cover a number of processes such as screenshots, renaming current files, finding and removing external links, setting default paths to current file, closing multiple files at once, removing all macros VBA code from current file, barcode scanner, and much, much more.
This Add-In is a real treasure. It has so many features, it could almost be a standalone program. You can color code some of the formulas so it SUMS and COUNTS based on the cell color, it repairs trailing minus signs with ease, transpose a single column into a table in seconds, select or filter by strikethrough formatted cells, and dozens more utility features to make tasks faster and easier. Everyone needs a barcode scanner at some point in time, and this one is quite versatile.
Provides an adjustable barcode prefix and postfix, adjustable character sets for encoding, batch-scanning mode, and more. And you can scan data with one device into several documents, or you can use multiple devices simultaneously to scan data into a single document.
Another time-saver Add-In that accelerates the long, slow, painstaking process of searching defining, and filtering data in columns, ranges, and tables. Uses a feature called Filter Hop to jump between filtered columns with a click, ends time-consuming horizontal scrolling across the spreadsheet, and provides built-in filter menus for easy changes. In addition to the standard line, bar, pie, and bubble charts, SmartCharts SC provides a variety of trend and multi charts, all with no modeling.
Just point and click any Excel table to see which of the SC best represent your data. If in doubt, SC makes suggestions. See this link for additional pricing options.Ever wish there was a tool that would remove extra spaces and line breaks in Excel with a click?
How about an app that translates Outlook emails into another language? Microsoft Office add-ins let you do this—and much more—without switching programs. When you want a bit more from Office, these add-ins each make Microsoft Word, Excel, PowerPoint, and Outlook more powerful with new features for free.
Best of all, they work in the free Office Online apps as well as newer versions of Office for Mac and Windows. New to Office Online? There are over 2, add-ins for Microsoft Office —and more that only work on specific versions of Office for Windows and Mac. To simplify things, we looked through over of the highest-rated apps for each product Outlook, Word, Excel, and PowerPointinstalled and tested 47 add-ins that stood out for their different features, and narrowed the results down using the following criteria:.
Using these criteria, we narrowed the list down to the following 22 add-ins for Outlook, Word, Excel, and PowerPoint, all of which are free unless otherwise noted:.
A note on system compatibility: We tested each add-in using Office Onlinethe free online version of Microsoft Office, and they should at least also work in any version of Office There are a lot of different ways to use Microsoft Office applications—the various Mac and PC versions of Office including Office, and the Office subscriptionswith the newer mobile apps for iOS and Android, or with the Office Online free web apps.
Not all add-ins work on every different version of Office, though, and how you install and access the add-ins varies across different apps, versions, and platforms. All of the add-ins in this article work in Office Online applications. To determine if an add-in you want to install will work with other versions of Office, follow the link we included for each add-in to see its description page on Microsoft Office's Add-in Marketplace.
That will open the Add-ins pane which shows add-ins you've installed, ones your company or school has added for your team, along with a store to select new add-ins. In Outlook Online, open Outlook. Either way, once you've installed an Office Add-in, you'll always have that add-in whenever you open an Office Online app in any browser. You'll need to do that separately. It works a bit differently in Outlook.
After installing the add-ins you want, it can be a little tricky to find and use them. Here are a few common places where the buttons for add-ins appear.Add-ins are different extensions of excel which when enabled they activate when the excel is started and a user can use its functions, excel has various different add-ins and they are in the options section of the file tab, the first box shows the enabled add-ins in the system and if the user wants to enable more add-ins we need to click on manage add-ins.
Add-In looks like a new word if you do not have any idea of additional excel features. Excel Add-in is nothing but additional features and options added to your existing Microsoft Excel. Adding additional functions to you will help you in terms of new features advantages. I would say Add-in is a kind of custom function that increases the power of Excel. Some of the Add-ins are readily available in excel but are hidden in default excel.
If the add-ins are already unhidden in your excel then you must see all these add-ins in your Data tab. These Add-Ins are built by individuals who regularly work on Excel Macros.
Some of them are free and some of them are involved cost to use them.
Excel Add-ins documentation
These are designed to support the basic functionality of the excel. We will look at how to create custom functions using VBA Add-ins later in the post.
Ok in this article I will show you a simple custom function that we can create and add that as an Add-In to our all excel files. In this example, I will show you how to hide worksheets in excel except for the active sheet and add that as an Add-In to the excel.
Worksheets If Ws. Name Then. In this example, I will show you how to unhide those hidden sheets. Follow the same procedure and copy-paste the below code.
Worksheets Ws. Filed Under: ExcelExcel Tools. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Login details for this Free course will be emailed to you. Free Excel Course. Skip to primary navigation Skip to main content Skip to footer Add-Ins in excel. Excel Add-Ins,Add-ins are different extensions of excel which when enabled they activate when the excel is started and a user can use its functions, excel has various different add-ins and they are in the options section of the file tab, the first box shows the enabled add-ins in the system and if the user wants to enable more add-ins we need to click on manage add-ins.