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

Thanks dear…..

Very good Video. Easy to follow. Thanks

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

Great! Easy to follow directions!

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

thank u for help

Simple easy video explaining installation

thanks & installation done ……….

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

tnx m8, great tutorial

Thanks for the video👌👌

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)

Nice and helpful, thank you!

Very very very informative and constructive!

Thank you! very helpful Tutorial.

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

Thanks, this was really helpful!

Thanks much Jon.

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

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

Thank you it was helpfull

Thanks!! Quick and easy!

Very clear and Helpfull , Thank you

Du miese Sau

Most helpful! Thank you! 🙂

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?

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

Thanks for the clearly explanation… Awesome!

easy, simple….great! congrats

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

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

Thanks for this tutorial Jon. It was very helpful.

Good info

Excellent well explanined – thanks!

It's very useful

thanks