How to load Add-Ins Tool in Excel 2013?

How to load Add-Ins Tool in Excel 2013?

Add-Ins tool comprises four different tool packs. For example:

1. Analysis ToolPak - Provides data analysis tools for statistical and engineering analysis
2. Analysis ToolPak - VBA - VBA functions for Analysis ToolPak
3. Euro Currency Tools - Conversion and formatting of Euro currency
4. Solver Add-in - Tools for optimizing and equation solving

But before we go and load the above tools you first need to have the "Developers" ribbon in place. If you do not know how to get the "Developers" ribbon then please follow the below blog.

How to load Developer's Ribbon?

Once the Developer ribbon is loaded click the Add-ins option available under tool Add-ins. This will provide you a pop up tool kit having list of all the above four tools. To load any of them you have to click the check box and hit ok. And there you go...

Users having interest in statistical tools and its usage can try and use the Analysis ToolPak option. This is really a wonderful tool. It provides you enormous amount of calculations in seconds; provided you have to give the right inputs.

For more details you can reach me...

Visit Other MS Excel Tips and Tricks
Use of Advance Filter in MS Excel

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316
https://www.facebook.com/Samrat.Biswas