Excel Power Query

At the end of this course you will be able to:

• Import data into Excel Using Power Query
• Create connections to external data sources and use the Data Model
• Edit Power Queries
• Work with Tables and Fields

Course Outline

Lesson 1: Introduction to Microsoft Power Query for Excel

• Concepts and Components
• Compatible Data Sources
• Data Import Process

Lesson 2: Import Data from External Data Sources

• Connect To and Query Compatible Data Sources
• Using the Default Excel Table Output

Lesson 3: Transforming Table Data

• Filter, Sort and Group Data
• Group Rows
• Shape Data
• Replacing Values, Text Transforms, Number Transforms, Date and Time Transforms
• Data Aggregation
• Unpivoting
• Transposing a Table
• Work with Columns
• Name, Move, Split, Merge

Lesson 4: Using the Query Editor

• Edit Query Steps
• Edit Query Step Settings
• Refresh a Query

Lesson 5: Combine Multiple Queries

• Merge and Append Queries
• Manage Queries

Lesson 6: Shape Data from Multiple Data Sources

• Power Query and Table Relationships
• Table Links and Navigation
• Choose a Destination for your Data
• Add a Query to an Excel Worksheet
• Add a Query to the Data Model
• Advantages of using the Data Model

Lesson 7: An Introduction to Advanced Queries

• Creating an Advanced Query
• Modify a Formula
• Power Query Formula Language