Add or remove Add-ins in Excel
Microsoft Excel offers additional tool packs, such as Solver and Analysis Toolpak Add-ins, which are generally used for statistical analysis by academicians and researchers. These Excel add-ins reduce the time needed for data analysis and improve the functionality of the Microsoft Excel tool. Excel add-ins are paid, requiring an annual subscription, and few are available free of cost.
Popular Excel Add-ins
- Kutools
- PowerPivot
- MathType
- Solver
- Analysis Toolpak
- ChatGPT for Excel
- SAP Analytics cloud for Excel
- SQL Spreads
- Microsoft PowerMap for Excel
Add-ins for Data Visualization
Best Excel add-ins for Data Visualization are listed below −
- Supply Chain Add-ins
- Microsoft Visio Data Visualizer
- ChartExpo for Excel
- SmartCharts for Excel
- iGlobe CRM Excel Reporting Tool
Find Popular Excel Add-ins
Go to the Home tab and click on the Add-ins under the Add-ins group. In this option, you may search for add-ins that add functionality to the Excel tools to ease your work and permit you to connect to the services.
Once you click on Add-ins, a list of popular Add-ins is showcased in the drop-down menu. You can also click the More Add-ins button to search for specific add-ins.
After that, the Office Add-ins dialog box appears. The different categories, such as CRM, Data Analytics, Document Review, Financial Management, and so on, are listed under the Category section.
How to Add Add-ins in Microsoft Excel?
Below are the steps to add-ins in the worksheet −
Step 1 − First, you may switch to the File tab, select the More.. category, and click on the Options from the drop-down menu.
Step 2 − After that, the "Excel Options" will appear, where you can select the "Add-ins" category from the given category list. You can view and easily manage the Excel Add-ins in the Add-ins category. Active application Add-ins like Analysis Toolpak and Euro Currency tools are displayed in the first section, and inactive add-ins like Date(XML) and Microsoft Actions Pane 3 are shown in the next section.
After that, click the Go button in the Manage section and hit OK.
The Add-ins dialog box will appear. The free Excel add-ins are Analysis ToolPak, Analysis ToolPak-VBA, Euro Currency Tools, and Solver. You may select any add-ins or Browse the Add-ins from the Microsoft Excel Add-ins folder.
Let's say you click on the "Analysis Toolpak," one of the most important data analysis tools for statistical analysis, and click the OK button.
Once you click on the OK button, the "Data Analysis Tool" will be added to the Analysis group under the Data tab.
Similarly, you can add other available add-ins to Microsoft Excel.
Remove Add-ins in Microsoft Excel
The step-by-step instructions are written below −
Step 1 − To remove the add-ins in Microsoft Excel, go to the File tab, click on the More category, and select "Options."
Step 2 − After that, click on the "Add-ins" and select the "Go..." button.
Step 3 − Moreover, the Add-ins dialog box will appear. To remove this add-in, untick the "Analysis ToolPak" checkbox and click OK.
Therefore, the Analysis Toolpak is successfully removed and disabled from the Analyze group.
