How to Get Excel 2010 data analysis tool

Excel is a powerful tool but its usefulness can be expanded even further with the use of a data analysis tool

Don’t forget to check out our site for more free how-to videos!
– our feed
– join us on facebook
– our group in Google+

This tutorial will show you how to get excel data analysis tool which can greatly expand the functionality of Excel.

Step # 1 — Open Options

Start Excel and click on the “File” button in the top left hand corner. This will present you with a menu and you need to click on “Options”. The “Excel Options” window will then load.

Step # 2 — Accessing Add-Ins Settings

In this window you need to navigate to the “Add-Ins” option in the left hand menu. This will provide you with a list of all the available add ins for Excel. At the bottom there is a button called “Go…”, click on this. This will open the “Add-Ins” window.

Step # 3 — Locating Data Analysis

This window will give you several checkbox options. You need to click in the checkbox next to the “Analysis ToolPak” option then click “OK”. That is essentially how to get excel data analysis tool and to access it you need to navigate to the “Data” tab and you will see a new box called “Analysis” and within it the “Data Analysis” option.


Xem thêm bài viết khác:


  1. ❗ Subscribe To Our Main YouTube Channel

  2. While I'm ticked off that Microsoft hid this away so we have to dig to find it, I'm really happy with this quick video. Thank you.

  3. thanks, you save my time 🙂

  4. you're a life saver man

  5. Thank you! You just saved me so much time and aggravation!

  6. This might be the best Excel tutorial video ever. Thank you for not putting useless BS. You rock!

  7. Thank you😎😎😎

  8. Clear and simple. Thanks

  9. Thanks for your kind help. Working….

  10. Very helpful, easy to get it ! Thanks.

  11. yo motherfuckers i dont have add-ins as a category in options where the fuck can i find it!!??

  12. thank you thank you very much

  13. Thank you so much bro

  14. Thank you very much my man, couldn't figure it out

  15. Omg, thanks you're a savior!

  16. thanks for saving my time bro.

  17. Very concrete and useful, thankyou

  18. ive followed the instructions however the only thing in my analysis box is the solver… is this the same as data analysis?

  19. Wow awesome.. Thanks..

  20. Thanks a lot for your helpful video.

  21. I could not find the 'add-in' button 

  22. So after much googling I finally came across this! Saved some time finding a computer with it already installed for a silly weekly stats quiz for uni. Thanks! 🙂

Leave a Reply

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