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. To access these tools click data analysis in the analysis group on the data tab. Also the functions in the toolpak can only be used on one worksheet at a time. Steps to load the data analysis toolpak add in. The analysis toolpak includes the tools described in the following sections. However you have to learn how to load it first since the toolpak is not automatically loaded.
The data analysis toolpak is a great addition to excel s default powerful tools. Load and activate the analysis toolpak.
Source : pinterest.com