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://kuherbal.com/
Xem thêm bài viết khác: https://kuherbal.com/category/cong-nghe
❗ Subscribe To Our Main YouTube Channel
https://www.youtube.com/user/howtechpc
thanksss
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.
thanks, you save my time 🙂
thank you
you're a life saver man
Big thanks, TT
Thank you! You just saved me so much time and aggravation!
This might be the best Excel tutorial video ever. Thank you for not putting useless BS. You rock!
Thank you😎😎😎
Clear and simple. Thanks
what a soothing voice
Thanks for your kind help. Working….
Very helpful, easy to get it ! Thanks.
yo motherfuckers i dont have add-ins as a category in options where the fuck can i find it!!??
thank you thank you very much
Great 🙂 Thnx 🙂
Thank you so much bro
Thank you very much my man, couldn't figure it out
Omg, thanks you're a savior!
thanks for saving my time bro.
Very concrete and useful, thankyou
Thank you!
Thanks Sir, much help.
Cheers 🙂
thank you good sir
so helpful mate
ive followed the instructions however the only thing in my analysis box is the solver… is this the same as data analysis?
Wow awesome.. Thanks..
Thanks a lot for your helpful video.
I could not find the 'add-in' button
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! 🙂