Introduction to Power Query (Get & Transform Data) in Microsoft Excel

Introduction to Power Query (Get & Transform Data) in Microsoft Excel! Want to understand what Power Query is all about? You can easily use Power Query (Get & Transform Data) in Microsoft Excel with this tutorial.

Excel Power Query is one of the most powerful new features within Microsoft Excel and the easiest to learn.

It was first introduced as an Excel add-in in 2013 and was then made available in Excel 2010. In Excel 2016 it was renamed to Get & Transform and was available (without using an add-in) under the DATA tab in the ribbon menu. In Excel 2019, it will be renamed to Power Query once again!

You can use Power Query to clean & transform your data that you download from your ERP or accounting system and display it in a report for Excel to work with.

The best thing is that you can reapply the same transformation steps in just ONE single click, saving you HOURS! So next week when you get the same report with updated data, a simple REFRESH will transform your data once again!
------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 Microsoft Excel video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline

[wayneedmondson]

Hi Brian.. thanks for the quick into to Power Query. Looking forward to more. Thumbs up!

[ChrisRichardsonTV]

I can see the application for this with inventory related data, does this have other practical applications with other data, such as organizational information, strategy and to-do lists?

[youngistaanmerijaan]

I have 20 .csv file in a folder and i want merge all with power query...but problem is all file names are ending with .csv_ (i.e. reader7.csv_ and reader8.csv_ )...please help me how can i remove all underscores from all file simultaneously....because without removing underscore power query is not detecting format....

[roberthonahusona]

how to show on power query on excel 2019...