How To Use Excel Data Analysis Toolpak

If the data analysis command is not available you need to load the analysis toolpak add in program.
How to use excel data analysis toolpak. Click the data tab in the main excel interface and the data analysis button can be found in the analyze section of the menu. Data analysis toolpak in excel is an addin in excel which allows us to do data analysis and various other important calculations this addin is by default not enabled in excel and we have to manually enable it from the files tab in the options section and then in the addins section we click on manage addins then check on analysis toolpak to use it in excel. However you have to learn how to load it first since the toolpak is not automatically loaded. Also the functions in the toolpak can only be used on one worksheet at a time. Using the analysis toolpak after installing the tool the button to use it is found in the same location as the solver tool.
The analysis toolpak includes the tools described in the following sections. To access these tools click data analysis in the analysis group on the data tab.