Excel TV

Academy course

Intro to Power Query

15 lessons across 5 modules · Jordan Goldmeier

Intro to Power Query

What’s in this course

Get the Course Files

  • Download the course files

Introduction to Power Query

  • Intro to Power Query
  • A Short History of Power Query

Manipulating Data

  • Workflow Description
  • Data Wrangling Steps
  • Understanding “Applied Steps”
  • What is M Code and where to find it
  • Tour of Power Query Features
  • “Column From Example” for Tough Problems
  • Sending Feedback to Microsoft

Merging Datasets

  • Introduction to Merging Data Case Study
  • Merge Query

Reading Data from Folders

  • Description of Case Study
  • File From Folder
  • Editing the Sample File

Curriculum

Get the Course Files 1 lesson
  1. 1. Download the course files
Introduction to Power Query 2 lessons
  1. 1. Intro to Power Query
  2. 2. A Short History of Power Query
Manipulating Data 7 lessons
  1. 1. Workflow Description
  2. 2. Data Wrangling Steps
  3. 3. Understanding "Applied Steps"
  4. 4. What is M Code and where to find it
  5. 5. Tour of Power Query Features
  6. 6. "Column From Example" for Tough Problems
  7. 7. Sending Feedback to Microsoft
Merging Datasets 2 lessons
  1. 1. Introduction to Merging Data Case Study
  2. 2. Merge Query
Reading Data from Folders 3 lessons
  1. 1. Description of Case Study
  2. 2. File From Folder
  3. 3. Editing the Sample File
Member access: Lesson videos and downloadable resources require academy login. Existing members get the same access they had on academy.excel.tv.