How To Install Power Query For Excel 2010 Or 2013 On Windows

Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
Learn how to install Power Query with this step-by-step tutorial for Excel 2010 or 2013. If you have Excel 2016 then Power Query is already built-in and located on the Data tab of the ribbon.
The first step is to determine what bit version of Excel you have, 32-bit or 64-bit. This can be found on the File menu under Help (2010) or Account (2013).
Once you know the bit version you can install Power Query from the following link.
www.microsoft.com/en-us/downlo...
Next, completely close Excel. You might need to close other Office apps like Outlook or Power Point.
Run the Power Query installer.
Once it finishes, open up Excel. You should see the Power Query tab in the Ribbon.
Here is a link to an article with step-by-step instructions.
www.excelcampus.com/install-po...
Checkout my article on an overview of Power Query to learn more.
www.excelcampus.com/powerquer...
00:00 Introduction
00:37 Determine Excel Bit Version
01:19 Download Power Query
02:58 Power Query Tab

[@raeconnelly]

Thank you for creating this concise, easy-to-follow tutorial.

[@maycaroig8374]

Thank you for the great and clear instructions! By the time I watched your video, I had Power Query installed. Thank you.

[@StefanoBreschi]

Great explanation, thanks. Now I can start looking at how to merge workbooks into 1. DO u have a video for that?

[@triciaguy7183]

Great Video Jon! It was very easy to follow. Thanks so much for your help!

[@cliffordeaton5455]

I'm just sorry that I found this video now, instead of earlier, but better late than never. Great instructions, easy to follow, and now I am off to see what other videos you offer.

[@leosdanilima]

Excellent! Informative, effective & concise. Thank you!

[@edwardamartey-tagoe4987]

Thanks for this tutorial Jon. It was very helpful.

[@rashmib123]

Quick and Clear explanation, thanks

[@judysmith5188]

Thanks in June 2023... the DOWNLOAD link still works!!!

[@georgecarter8104]

Just what I was looking for. Excellent. Many thanks.

[@AV-cj6li]

Thank you so much, this was very easy and helpful!

[@vijaymalkar9942]

Thanks, i was searching for this since one year

[@maryamfatima5882]

Excellent! and easy way to express the information- Short and Sweet, Thank you!

[@stephenphan2761]

Very useful Jon. Thanks. Can you share some tutorials about practising of using Power Query ?

[@HAFEZALQUBBAJ]

you are great man, and your explanation direct ,clear and informative as well , waiting more videos about powerquery .

[@englishcafe9968]

Fabulous! Thanks a million. I have been looking for this for a long time.

[@MsNIRNAY]

Great explanation, thanks. Informative, effective & concise. Thank you!

[@maryamsaade5260]

Thank you! very helpful Tutorial.

[@gusy629]

Thank you so much for your instruction. I'm very grateful.

[@CraftingWithAprilD]

THANK YOU! I would have been sitting forever looking for the "Query" section.

[@ExcelCampus]

Awesome! Thanks! :-)

[@charlotteengerer6751]

Thanks, this was really helpful!

[@JosueVader]

Thanks for the clearly explanation... Awesome!

[@zoubaidaskalli5372]

Thank you! Really great, easy to follow!!

[@LisaEdney]

Most helpful! Thank you! :)

[@Olu_wakemi]

Quick, easy and resourceful ❤ Thank you 🙏🏾

[@ExcelCampus]

Thanks for your feedback! 😀

[@sergeitipia6760]

Nice and helpful, thank you!

[@dorissweanapo9860]

Thank you so sharing this information and putting time for this awesome video.

[@tehreembhatti2948]

Thank you so much Jon! How Very helpful of you :)

[@luismogollon2390]

easy, simple....great! congrats

[@malikastar9265]

Thank you , that was helpful and concise as usual

[@azeemmalik1012]

Thanks Jon for the video. Can we make invoicing system in EXCEL with stock-taking feature. Appreciate if you Please Advice. Thanks

[@monicahaigh4490]

Thanks for this information

[@judithurdaneta7764]

Thanks for your help

[@christinagire9346]

Thanks!! Quick and easy!

[@esthernjagi4886]

Thank you for the tutorial on how to install the power query.

[@umerrehmanaca2783]

You are awesome at teaching

[@lindaleach2060]

Great! Easy to follow directions!

[@abrahamramirezrodriguez7160]

Muy buen tutorial, excelente explicación. Me siento pleno y feliz.

[@vanipriya448]

That was very helpful....Thank you!

[@romeomuyambo4393]

good and clear explanation

[@prakashgadupoodi7549]

Nicely explained Jon.. Keep doing good work

[@nailafaquir4543]

AWESOME EXPLANATION, THANKS

[@pankaj007arbia]

Nice video, thanks

[@roddo27]

Excellent well explanined - thanks!

[@hectorvergara4971]

Thank you!

[@sebghatulbarykhabaey6680]

Thank you It was great

[@preethiram02]

Very clear and Helpfull , Thank you

[@tuongdo2294]

Great video!

[@bostevens8617]

Very clear instructions.

[@fakheri]

Very very very informative and constructive!

[@isaacavornyo1807]

Thank you for this video, it was very helpful

[@jobrown8146]

Thank you. Very much appreciated.

[@wilsonsantiago39]

can I hv power query in 2016 and 2010 at the same time .. when Microsoft install 2016 my power query in 2010 was removed ... I hv a course on udemy on power pivot and like to hv both of them installed so I can learn them 2gether... what do you think?

[@Cunha162010]

Amazing! Thanks a lot!

[@JohnsonKongor]

Great job.

[@hlalaytin7056]

Thanks !

[@shamaprasad9324]

Very good Video. Easy to follow. Thanks

[@Ella290374]

So Clear and so easy to follow. Thank you so much

[@jadran_babura]

tnx m8, great tutorial

[@SalahDAOUDI-mf5mw]

Great, thank you very much sir, easy and very helpful tutorial.

[@mynutom6661]

Thank you so much!!

[@anjubhonah3367]

Thanks much Jon.

[@mtamgt]

Thanks, you lighten my burden.

[@vladimirbogdanovic4672]

Thank you it was helpfull

[@SunnySingh-iv9et]

thanks for the great video ...saved my lot of time

[@HibaSayed]

I Like that So much

[@bernardblumberg803]

Excellent teacher.

[@ExcelCampus]

Thank you Bernard!

[@zm35r2bn]

iNEW EXCEL COULD DO THIS -----I KNEW I COULDENT .........NOW I CAN GREAT VIDIO

[@wasimakhtar6082]

Great intro Jon

[@DougieMuringani]

Thanks. good video

[@carjai12]

Simple easy video explaining installation

[@OLFan29]

Thank you very much.

[@jamalakhan]

Kudos Jon. thanks alot

[@Rajanil]

THANK YOU SO MUCH SIR.

[@noelp.lunajr.3560]

Thank you very much sir...God Bless..

[@moumenzineb6672]

Thank you very much!!

[@ShrijaD-555]

Thank you so much. Downloaded in May 2024

[@ExcelCampus]

You're welcome! 😀

[@yuthasaetang6825]

Thanks for your sharing.

[@angadsingh9318]

Thanks for the video👌👌

[@gbolahantoluwalope1409]

Thanks...This is really helpful

[@iamliam1241]

Thank you so much 👍

[@sagarpatil2413]

Thank you so much

[@Richinator01]

I enjoyed the video... Thank you

[@ExcelCampus]

Glad you enjoyed it 😀

[@agsolutions1959]

thank u for help

[@josedgonzalez7776]

Can you help me on Mac?

[@abednegomulumbi6780]

Thank you Big.

[@jordisales8351]

thank you

[@vyasinfotechvs9200]

Thanks a lot

[@somrathossain3715]

thanks a lot

[@sandipbhapkar6360]

Excellent Sir 🙏🙏🙏

[@shaikumerhussain4911]

Thank you 😊

[@abahsain]

Hi Jon, I need help to resolve the error related to power query. I had installed the power query as instructed for office 2013. However; power query is not appearing in the ribbon. I had also tried to include through COM-Addin tab in Developer, it's not appearing. instead, I see a error " Not Loaded. A runtime error occurred during the loading of the COM Add-in.".

[@eswarikamireddy260]

same query here. can I use power query in Mac?

[@-rb_1]

thanks

[@mohammedissawi2253]

Thanks

[@sebastianschulz3906]

Big Thanks for this Video =)

[@mounikaperla4049]

Thank you, it is helpful

[@ExcelCampus]

Glad it was helpful! 😀

[@babymadeeha3320]

Hey Nam, I am unable to install Power query option in my excel. These are the four options I get once I click on Com Add-ins 1. Inquire 2. Powerpivot for excel 2013 3. Power view 4. Team Foundation for Add-in

[@vishnushinde7123]

It's very useful

[@jigscoolable1]

thank bro..... very usefull info.....