ETEPQL1 – Excel Power Query

Enquire/Book this course

  • This field is for validation purposes and should be left unchanged.
Print this page
  • Code: ETEPQL1
  • Duration: 1 Day
  • Price per delegate: £575.00 +VAT

Trained over 60000 delegates

Course delivered by industry expert instructors

Highly competitive pricing

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