Enabling the Data Analysis tools in Excel

Open up Excel and go to the File menu. Select Options and then Add-Ins from the left hand panel.

 

From the Manage drop-down list at the bottom choose Excel Add-Ins and click Go.

 

dataanalysisaddin1

 

Click to select the Analysis ToolPak. Once you’ve done it, it will appear permanently on the Data tab in the Analysis section on the ribbon.

 

dataanalysisaddin2

Leave a Reply

Your email address will not be published. Required fields are marked *