Solver is provided by Microsoft with Excel 2007 and later for free.Īnalysis Tookpak adds additional analysis functions such as statistics and engineering functions which are not available in Excel. Linear Programming Problems can be solved using Solver given some decision variables and constraints on these variables. Once Solver is added to Excel, it can be accessed from Data → Analysis → Solver. Solver uses techniques from Operations Research to find optimal solutions for problems involving decision making where the goal of the problem is to maximize or minimize some target value. It solves a problem by adjusting a number of input cells according to a set of criteria or constraints defined by user. Solver falls under the category of What-if Analysis tools which can solve problems by enabling a target cell to achieve some goal. Let us see some of these add-ins for data analysis, not in any particular order: If this option is not visible you may need to first install these add-ins by selecting Office Button → Excel Options → Add-Ins in Excel 2007 or File → Help → Options → Add-Ins in Excel 2010/2013, and clicking the Go button at the bottom of the window. A number of data analysis tools are accessible via Data → Analysis → Data Analysis.

You can utilize any of the following Excel Add-ins based on your data and analytical requirements irrespective of whether you are a researcher, a student or a business man. There are various add-ins for Excel which makes your data analysis quite easy. Whenever I think of doing any computation or analysis, Excel comes to my mind first because of its varied functionalities.

Excel bundles data manipulation features with statistical and mathematical functions which are utilized for qualitative analysis. Its user friendly interface and available help makes it one of the most acceptable tools around the world. Excel is widely accepted as a feature rich data analysis tool, sometimes also referred to as a number cruncher.

Uf excel data analysis add in