Basic Excel Business Analytics #30: Excel 2016 Power Query: Data Ribbon Tab, Get and Transform

Learn how to import multiple Text Files (.txt) from a folder into Excel using the new Excel 2016 Power Query: Data Ribbon Tab, Get and Transform group.

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[PedroCabraldaCamara]

I'm sorry about this stupid question, but do you have any video that explains the "load to" button? I haven't use it yet but what's the difference between add or not to data model? I'm sorry again but i can't find an answer.

[juanmoragaaraya]

you have link to download power query for mac ?

[carltonseymour]

I have Microsoft Office Standard Excel 2016 version. Where can I get the Power Pivot add in. Appreciate assistance

[mahreenathar]

You forgot to tell that you need to have explorer 9 or it's latest version to make that 'browse for data' or, in this video, the "folder" dialog box appear... :)

[jiayuezhan]

Thank you so much for this tutorial!! It is so helpful!

[siddhantnaik]

Thank you for your amazing videos on Power Query. Can we do the same thing if we get the data from share point list ?? Kindly let me know. Thank you

[spik]

I don't have the new Query button

[matijacerne]

Imagine Ross from Friends narrating this video :D

[xcaliber]

I see, but i can't hear. Check your audio my friend!