Adding Data Analysis ToolPak in MS Excel (Office 365)

[@rikkithomasmartin3687]

Thanks Samer. It's people like you making videos to help others that make TH-cam a truly wonderful place to learn!

[@SamerHijaziStats]

Glad you think so!

[@showdownbandit6279]

Samer Hijazi you are the rockstar of Excell data analysis. Thank you for sharing this. "Knowledge is power"..

[@paulboudreau5882]

Thank you! I was stuck until this video because Excel was not allowing the add-in even though I could see it in the file structure. Great help at 1.16 fixed it.

[@DEWMINIC]

Thank you, im working on my statistics project. This saved my life.

[@cherylvillarbatin6426]

Thank you so much for the unchecked technique. I could see that the application was active but I can't see the button. When I did the unchecked it finally worked. Thanks

[@SamerHijaziStats]

Glad it helped!

[@sventilmanfischer4503]

Samer, thank you very much for the mentioning of the glitch. After unchecking and re-checking it happens to function again!!!

[@Jick33]

Thank you! I love the length of the video, it was perfect! Thanks again!

[@SamerHijaziStats]

Glad you liked it!

[@docvencil2222]

My spreadsheet says analyze Data until I press on Data, then it goes away. If I go to file the options it gives me no options.

[@KRAPYBARA84]

Yeah sounds like youre using a dumb ass version your school provided and that is so typical off these people - I am in the same boat

[@docvencil2222]

@@KRAPYBARA84 Actually, I didn't have the Add-in installed. Now all is well. Thanks.

[@enchantinglysimple]

I'm not sure what I'm doing wrong. When I go to file, the only options it gives me are, "Info", "new", "open", "save as", "print", "share", and "about". I'm using an online version, and maybe i'm in the wrong place. Any help would be appreciated. Thanks.

[@SamerHijaziStats]

Yes, this is for the desktop version of Excel.

[@harshitapangtey]

Yes same.. Please helppp

[@abdrahmangamal6795]

thank you ❤❤ from Egypt

[@alexisfrench8105]

I have a MacBook Pro with Office 365, and I dont even have "File" option. How do i download if my file option isnt showing?

[@ayanmiso2750]

I have the same problem please let me know how u did it ...I hope u see this 😣

[@SamerHijaziStats]

@@ayanmiso2750 For those who have Mac computer please follow the steps below to add the Data Analysis ToolPak in Excel.
Go to the Tools menu.
select "Add-ins"
Check "Analysis ToolPak" then click OK

[@hannahp2718]

Amazing thank you - easy to follow and did what I needed.

[@munenedenis3377]

Thank you sir, you have saved the day

[@isuruwwickramathunga1154]

Very useful. Thank you very much brother 🤗🤗

[@nathalyceballos763]

Extremely helpful and to the point!

[@fatemehkamkar3607]

Great , short and useful , Thank you so much

[@SamerHijaziStats]

Glad it was helpful!

[@manishasahu5570]

Thanks a lot man for keeping it short😀

[@aliamer9306]

thanks very much, this simple video helped me

[@akshaya7543]

Thank You for helping us..

[@hannahkylacual4245]

thank you so much this is very helpful!

[@healthbarrierstaff7016]

But in excel 2007 there is no option for file also than what should I do to download data analysis option

[@flerydelacruz9670]

Super helpful! Thank you sir!

[@luiginavarro]

Many thanks Samer.

[@genovalinde5773]

Wow I had no idea. Thanks for this.

[@Daisy-ew3cs]

How do you get this to work on a HP Chromebook

[@raabikhan8447]

Thank u so sir, sorted my issue

[@maryln8019]

Thank you so much. Helpful

[@brycedreghorn5950]

Thankyou very much Samer! Very good

[@riyamittal9420]

i dont have the "options" option.

[@alig4164]

click more. it should pop up after that

[@CD_coffeegeek]

Very Helpful! Thanks a ton!

[@rosvianarosida4244]

sorry sir,, i had problem to add in analysis ToolPak. The informations trouble Microsoft Excel cannot access the file, how solutions about this?

[@crouxp1912]

Very helpful. Thank you.

[@carolinegichero2227]

Thanks,,it really works.

[@socialmedia8100]

Very usefull video

[@gaganpreetkalkat2600]

In my options it shows local country n nothing else what should I do please help

[@GEB-Loop]

This is very helpful. Thank you!!!

[@mercedeshall600]

My excel doesn't show an options button under the file tab. Why not? Please help

[@SamerHijaziStats]

Are you using Office online? Are you using MAC?

[@elizabethormond4549]

Thank you! This was so helpful

[@athenaasamiya2995]

Thank you so much sir

[@ritarahayu8184]

Thank you lifesaver!

[@Rakeshvarma-zi4qi]

Thanks sir 😍😘

[@jefftrader1]

this is the desktop version of Excel isnt it?

[@SamerHijaziStats]

Jeffrie Shipley yes it is

[@rishad9667]

Worth. ✌🏻

[@hazelymaiee7149]

Thank you!

[@markcovercover7914]

Thankyou sir. very helpful

[@salifhaidara7802]

1000% helpful

[@argieconcha9684]

Thank you.

[@nadianursyuhaidah7286]

thank you so much!

[@ahmedmoslem5842]

thankyou so much

[@cima2010]

Helpful thank you

[@sukesiedahwiranti8310]

Thank u so so much!!!

[@anonymous-rt9qb]

what about the web version?

[@SamerHijaziStats]

You can not add an Add-ins to the web version

[@worldsknowledgelibrary8928]

Thank u bro

[@robcoIncorp]

not working ... this is driving me crazy, I checked and unchecked that box a1000 times, restarted excel restarted the computer... nothing worked

[@SamerHijaziStats]

Do you have a PC? Are you using desktop version of Excel?

[@robertjohnson-noaaaffiliat5205]

@@SamerHijaziStats I have same issue, it still does not show up. Excel 2019 on laptop.

[@fabriziofaccilongo30]

@@robertjohnson-noaaaffiliat5205 how you resolve it?

[@robertjohnson-noaaaffiliat5205]

@@fabriziofaccilongo30 Still an issue.

[@robertjohnson-noaaaffiliat5205]

But! Try opening excel as admin then it works. That was a temp work around that I found.

[@sammypalms]

Legend.

[@isr901]

thank you, thank you, thank you!!!

[@SamerHijaziStats]

Any time!

[@blaivyapereira7393]

Thank you so much

[@SamerHijaziStats]

You're most welcome

[@souhakabtni5192]

thank you!!!

[@juhikumari7728]

Tysm

[@ahmadehsan4525]

Thank you :)

[@arunishgarg1644]

thanks

[@almaidemamiscal3769]

Thanks

[@michaelbundy2997]

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

[@che2666]

Thank you

[@KRAPYBARA84]

says I have to change my regional format to my country and It was already that- then suggested its based off the a3rd party regional setting- I mean talk about trash man- I wish it was as easy as this lol

[@anshicaaron80]

thankyou!!

[@jamaalmohammad2020]

I will send tomorrow

[@renccris7705]

tytyty

[@mayanneadarlo4437]

thank you so much!

[@falomari2570]

Thank you so much

[@raajthegamer]

thanks

[@saikalyan3910]

Thank you

[@theysayimnub734]

Thank you so much

[@nurizyannabilah5580]

thank you

[@SamerHijaziStats]

You're welcome

[@tshenolomokhele3721]

Thank you so much

[@jazvlogs7986]

Thank you very much