Course curriculum

    1. Power Query Introduction

    2. Power Query Course Files - Instructional Video

    1. What is Power Query

    1. Loading Data into Power Query - Overview

    2. Loading Data Into Power Query via Tables

    3. Loading Data via Files

    4. Loading Data via Files - Practice Exercises Solution

    5. Loading Data via Folders

    6. Loading Data via Folders Practice Exercises Solution

    7. Loading Data via the Web

    8. Loading Data via the Web Practice Exercises Solution

    9. Loading Data via PDF

    10. Loading Data via PDF Practice Exercise Solution

    1. Appending Files

    2. Appending Files Practice Exercises Solution

    1. Power Query Join Types

    2. Merge Files

    3. Merge Files Practice Exercises Solution

    1. Data Transformations Overview and Example 1

    2. Data Transformations Example 2

    3. Data Transformations Example 3

    4. Data Transformations Practice Exercises Solution

    5. Unpivot Data

    6. Unpivot Data Practice Exercises Solution

About this course

  • $49.99
  • 26 lessons
  • 2.5 hours of video content

Power Query is a game changing-skill that every FP&A professional should learn.