Adding Data Analysis ToolPak in MS Excel (Office 365)

[@rikkithomasmartin3687]

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

[@SamerHijaziStats]

Glad you think so!

[@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.

[@sventilmanfischer4503]

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

[@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!

[@showdownbandit6279]

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

[@DEWMINIC]

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

[@Jick33]

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

[@SamerHijaziStats]

Glad you liked it!

[@athenaasamiya2995]

Thank you so much sir

[@raabikhan8447]

Thank u so sir, sorted my issue

[@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.

[@aliamer9306]

thanks very much, this simple video helped me

[@fatemehkamkar3607]

Great , short and useful , Thank you so much

[@SamerHijaziStats]

Glad it was helpful!

[@munenedenis3377]

Thank you sir, you have saved the day

[@hannahp2718]

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

[@akshaya7543]

Thank You for helping us..

[@nathalyceballos763]

Extremely helpful and to the point!

[@luiginavarro]

Many thanks Samer.

[@abdrahmangamal6795]

thank you ❤❤ from Egypt

[@hannahkylacual4245]

thank you so much this is very helpful!

[@maryln8019]

Thank you so much. Helpful

[@jazvlogs7986]

Thank you very much

[@mayanneadarlo4437]

thank you so much!

[@isuruwwickramathunga1154]

Very useful. Thank you very much brother 🤗🤗

[@crouxp1912]

Very helpful. Thank you.

[@brycedreghorn5950]

Thankyou very much Samer! Very good

[@flerydelacruz9670]

Super helpful! Thank you sir!

[@manishasahu5570]

Thanks a lot man for keeping it short😀

[@socialmedia8100]

Very usefull video

[@carolinegichero2227]

Thanks,,it really works.

[@hazelymaiee7149]

Thank you!

[@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

[@ritarahayu8184]

Thank you lifesaver!

[@genovalinde5773]

Wow I had no idea. Thanks for this.

[@markcovercover7914]

Thankyou sir. very helpful

[@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

[@argieconcha9684]

Thank you.

[@CD_coffeegeek]

Very Helpful! Thanks a ton!

[@cima2010]

Helpful thank you

[@GEB-Loop]

This is very helpful. Thank you!!!

[@ahmedmoslem5842]

thankyou so much

[@salifhaidara7802]

1000% helpful

[@rishad9667]

Worth. ✌🏻

[@elizabethormond4549]

Thank you! This was so helpful

[@Rakeshvarma-zi4qi]

Thanks sir 😍😘

[@worldsknowledgelibrary8928]

Thank u bro

[@isr901]

thank you, thank you, thank you!!!

[@SamerHijaziStats]

Any time!

[@sukesiedahwiranti8310]

Thank u so so much!!!

[@healthbarrierstaff7016]

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

[@souhakabtni5192]

thank you!!!

[@sammypalms]

Legend.

[@ahmadehsan4525]

Thank you :)

[@michaelbundy2997]

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

[@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?

[@jefftrader1]

this is the desktop version of Excel isnt it?

[@SamerHijaziStats]

Jeffrie Shipley yes it is

[@riyamittal9420]

i dont have the "options" option.

[@alig4164]

click more. it should pop up after that

[@saikalyan3910]

Thank you

[@Daisy-ew3cs]

How do you get this to work on a HP Chromebook

[@rosvianarosida4244]

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

[@almaidemamiscal3769]

Thanks

[@gaganpreetkalkat2600]

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

[@juhikumari7728]

Tysm

[@raajthegamer]

thanks

[@anshicaaron80]

thankyou!!

[@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

[@jamaalmohammad2020]

I will send tomorrow

[@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.

[@renccris7705]

tytyty

[@anonymous-rt9qb]

what about the web version?

[@SamerHijaziStats]

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

[@tshenolomokhele3721]

Thank you so much

[@nadianursyuhaidah7286]

thank you so much!

[@che2666]

Thank you

[@arunishgarg1644]

thanks

[@theysayimnub734]

Thank you so much

[@falomari2570]

Thank you so much

[@blaivyapereira7393]

Thank you so much

[@SamerHijaziStats]

You're most welcome

[@nurizyannabilah5580]

thank you

[@SamerHijaziStats]

You're welcome