Excel power query tutorial video. Download excel file 1. Highline college busn 216 class. The following video shows one way to display the. Limited time offer get a launch discount for my new power query course.
Download excel start file. From the get external data section in the power query ribbon tab select from other sources blank query. To view the query editor without loading or editing an existing workbook query. For more about information and to see an example of these steps in action see getting started with power query.
Features in power query are available in excel and power bi desktop. The following video shows the query editor window appearing after editing a query from an excel workbook. Using power query often follows a few common steps. As part of this process youll navigate across tables available on a web page and apply data transformation steps to display just the data you want to see.
In this tutorial youll use excels power query experience to create a query that imports data from a web page.