How to Install Power Query in Excel 2010 or 2013 for Windows



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.

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.

Checkout my article on an overview of Power Query to learn more.

Nguồn: https://kuherbal.com/

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

36 Comments

  1. Very good Video. Easy to follow. Thanks

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

  3. Great! Easy to follow directions!

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

  5. Simple easy video explaining installation

  6. thanks & installation done ……….

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

  8. tnx m8, great tutorial

  9. Thanks for the video👌👌

  10. I don't think so 64bit of Excel 2010 would work with Power Query Addin? I tried installing 64bit version of Addin but it asked me to install 32bit version of Excel for Addin to work (I am referring to Office 2010)

  11. Nice and helpful, thank you!

  12. Very very very informative and constructive!

  13. Thank you! very helpful Tutorial.

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

  15. Thanks, this was really helpful!

  16. Thank you so much Jon! How Very helpful of you 🙂

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

  18. Thank you it was helpfull

  19. Thanks!! Quick and easy!

  20. Very clear and Helpfull , Thank you

  21. Most helpful! Thank you! 🙂

  22. Hi, I am Khayrul Amin, I have facing a problem to split a
    column. My Excel row like that.

    100% CTN INDIGO 3/1 7X10 11.6OZ 58/60".-S19BS1109
    Fabric 1 Cotton 100% Y/D Oxford 110X54/40X30/2-S19BS1128
    60% Cotton 40% Viscos, 110×70/40/40, Regular Finis-S19BS1041

    Now i want to split this row like that.

    100% CTN INDIGO
    Fabric 1 Cotton 100% Y/D Oxford
    60% Cotton 40% Viscos

    Is it possible to use power query?

  23. Eveline, Received code from *Xuesoftware . com*, It works! like it

  24. Thanks for the clearly explanation… Awesome!

  25. easy, simple….great! congrats

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

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

  28. Thanks for this tutorial Jon. It was very helpful.

  29. Excellent well explanined – thanks!

Leave a Reply

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