Friday, January 08, 2016

Data analysis not available in Excel

If you are using MS Excel version older than 2016 and if Data analysis option is not available in Analysis section under Data tab then follow the instructions below.

Data analysis option is not available.






Go to File menu > Options > Add-Ins > Select "Excel Add-ins" in Manage drop-down list that is located at the end of the window and hit go.






















Then select Analysis ToolPak and click OK it will add Data Analysis option under Analysis group in Data tab.


























This is how it looks like after enabling the add-in.