Power Query Tutorial – What is it, How to use, Full examples, Tips & Tricks

 Here is the article. 

Chandoo

Last updated: August 2020

Power Query (Get & Transform data in Excel) is a true game changer. It can simplify and automate various data activities. The key benefits of Power Query are,

• Connect to any type of data source and fetch data
• Define process for data cleansing and transformation
• Combine datasets (table joins, appends)
• Automate data collection & management tasks (refresh etc.)

In this Power Query Tutorial, learn what it does, how to use it with 4 practical examples, tips & tricks to work with Power Query better.