How to use Microsoft Power Query

In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.

• Additional resources:
  • Sample files: https://1drv.ms/u/s!AmxrofZZlZ-whKZQT…
  • Download Power Query for Excel 2010 or 2013: https://www.microsoft.com/en-au/downl…
• Timestamps
  • 00:00 Introduction
  • 00:59 Sample data
  • 2:14 How to get Power Query
  • 2:31 Get data
  • 3:35 Combine data
  • 5:26 Main Power Query interface
  • 7:00 Transform data
  • 11:21 Applied steps
  • 12:06 Close & Load
  • 12:33 Data imported into Excel
  • 13:34 Insert pivot table & chart
  • 14:46 Importing additional data
  • 16:00 Wrap up