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
   
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.