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.

Nguồn: https://daihocphuongdong.com

Xem thêm bài viết khác: https://daihocphuongdong.com/cong-nghe/

  • ❗ Subscribe To Our Main YouTube Channel

    https://www.youtube.com/user/howtechpc

    Excel, Word and PowerPoint Tutorials from Howtech 26/04/2020 07:16 Reply
  • Thank you!!!

    Milytoni Ebo 26/04/2020 07:16 Reply
  • Thanks for helping me…

    Kalyani Mhaskar 26/04/2020 07:16 Reply
  • Thank you very much! I was struggling to have that data analysis tool and thought i had no hope, but here i am! Yey! Thankssss

    Melissa Acuna 26/04/2020 07:16 Reply
  • thank you man

    Angel Manev 26/04/2020 07:16 Reply
  • thanksss

    Bushy Khan 26/04/2020 07:16 Reply
  • 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.

    Ken Masters 26/04/2020 07:16 Reply
  • thanks, you save my time 🙂

    Nureyn A 26/04/2020 07:16 Reply
  • thank you

    Kaewkan Duksukkaew 26/04/2020 07:16 Reply
  • you're a life saver man

    KRESNA YUDANTO - 26/04/2020 07:16 Reply
  • Big thanks, TT

    Lee Dong San 26/04/2020 07:16 Reply
  • Thank you! You just saved me so much time and aggravation!

    Kirissa Padilla 26/04/2020 07:16 Reply
  • This might be the best Excel tutorial video ever. Thank you for not putting useless BS. You rock!

    Omar Khan 26/04/2020 07:16 Reply
  • Thank you😎😎😎

    Indri Tolulele 26/04/2020 07:16 Reply
  • Clear and simple. Thanks

    Joseph Joram 26/04/2020 07:16 Reply
  • what a soothing voice

    Tony Ly 26/04/2020 07:16 Reply
  • Thanks for your kind help. Working….

    Md. Maruf Hasan 26/04/2020 07:16 Reply
  • Very helpful, easy to get it ! Thanks.

    Benny Won 26/04/2020 07:16 Reply
  • yo motherfuckers i dont have add-ins as a category in options where the fuck can i find it!!??

    A7madada D-bag dabbagh 26/04/2020 07:16 Reply
  • thank you thank you very much

    lala la 26/04/2020 07:16 Reply
  • Great 🙂 Thnx 🙂

    mravecsk1 26/04/2020 07:16 Reply
  • Thank you so much bro

    إسمَاعيل 26/04/2020 07:16 Reply
  • Thank you very much my man, couldn't figure it out

    צביה בר 26/04/2020 07:16 Reply
  • Omg, thanks you're a savior!

    Mercy Olaguer 26/04/2020 07:16 Reply
  • thanks for saving my time bro.

    Dan David 26/04/2020 07:16 Reply
  • Very concrete and useful, thankyou

    Mónica Quezada Espinoza 26/04/2020 07:16 Reply
  • Thank you!

    Thiện Phạm 26/04/2020 07:16 Reply
  • Thanks Sir, much help.

    Athi Mfikili 26/04/2020 07:16 Reply
  • Cheers 🙂

    Moin Ahmed 26/04/2020 07:16 Reply
  • thank you good sir

    Jorge A. 26/04/2020 07:16 Reply
  • so helpful mate

    Ebraheem Hassan 26/04/2020 07:16 Reply
  • ive followed the instructions however the only thing in my analysis box is the solver… is this the same as data analysis?

    Lillian Jai 26/04/2020 07:16 Reply

Leave a Reply

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