Answered By: Alyssa Mitchell
Last Updated: Oct 12, 2016     Views: 361874


If the Data Analysis command is not available in your version of Excel, you need to load the Analysis ToolPak add-in program. These instructions apply to Excel 2010, Excel 2013 and Excel 2016.

  1. Click the File tab, click Options, and then click the Add-Ins category.
  2. In the Manage box, select Excel Add-ins and then click Go.
  3. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

Tip: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

Once the add in has been successfully installed you will see data analysis when you click on the data tab (usually to the far right of the toolbar). Go back to the first screenshot in the instructions to see how it will look. The button will open the Data Analysis dialog, which offers access to a variety of analysis tools.


Quick Analysis is a similar set of tools available in Excel 2013.  See Microsoft documentation for more information. it applies to Excel 2013 and Excel 2016. 

~ Instructions provided courtesy of Excel Help


Comments (24)

  1. You have made some really good points there. I checked on the internet for more additional information about the issue and found most people will go along with your views on this site.
    by gary on May 02, 2016.
  2. You can find the instructions here along with the tutorial on how to use it to make a histogram:
    by Hans on Dec 28, 2016.
  3. When I open the Options menu the Add-Ins tab is not there. I have excel 2010. I need to be able to use data analysis for a stats class. Any ideas why it's not there?
    by awhitaker on Jan 30, 2017.
  4. it was totally a helpful one thanks a lot
    by zikersp on Mar 13, 2017.
  5. Thanks.. very insightful
    by usman on May 13, 2017.
  6. Thanks a lot for your instruction, was clear and useful.
    by ramadan on Oct 07, 2017.
  7. Thanks a lot for your instruction. It's help me to start analysis in xls.
    by Rajeev on Dec 10, 2017.
  8. Thank You!
    by Rivera on Jan 15, 2018.
  9. this really help me a lot. thanks!
    by cuja on Mar 23, 2018.
  10. This was really helpful, so clear and straight to the point. Thank you so much.
    by Mavis on Apr 09, 2018.
  11. The Analysis Toolpak is installed. The Data Analysis button is not there. This is Excel 2013. Frustrated!
    by Paul on Apr 19, 2018.
  12. I installed the Analysis toolpak, but there is no button for it. What's wrong?
    by Larry Brunner on May 09, 2018.
  13. Thank you very much for the easy to follow instruction !
    by Ashutosh on May 11, 2018.
  14. @Larry - you might need to close the program and open it again.
    by Katie Hutchison on May 14, 2018.
  15. Thank you very much for your help, it does even in my Microsoft Office 2007.
    From Dar es Salaam, Tanzania.
    by Ezekiel on May 16, 2018.
  16. i could not find slicer option in excel 2007 . please anybody help me.
    by Bedanta on Jul 04, 2018.
  17. @Bedanta - Unfortunately it looks like slicers are not available for any Excel product prior to 2010. That being said, I found this discussion thread that discusses possible alternatives, I hope this helps!
    by Alyssa Mitchell on Jul 05, 2018.
  18. fantastic
    thank you very much
    by charles on Jul 07, 2018.
  19. THANK YOU!!!
    by anonymous on Aug 10, 2018.
  20. Much appreciated!
    by El Ocho on Oct 14, 2018.
  21. Thanks really helpful
    by Navi Rathee on Oct 27, 2018.
  22. thank you very much
    by sateesh kumar tk on Jan 03, 2019.
  23. Thanks!
    by Raiz on Jan 11, 2019.
  24. Wow! Saved me hours of looking for something I didn't have. Thank you so Much. Bless your brain.
    by Pebbles on Mar 07, 2019.

Contact Us!

Main Library: (330) 490-7185

Questions? Ask Us!

Related Topics