Power Query Courses

Onsite Group Courses in Sydney or Virtual
Get a Quote

Power Query Courses Onsite or Virtual

 

Learn how to get the most out of Power Query, Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs, all with an easy to use, engaging, no-code experience.

Power Query

Course Overview

This hands-on course is suitable for users who need to prepare data for analysis the smart way. Power Query works across several Microsoft products, so whatever you learn for Power Query in Excel can be applied to Power BI and other products too.

Prerequisites

Participants will need to have intermediate knowledge of Excel.

What you will learn

How to use Power Query to import data from many different data sources into Excel while transforming them into appropriate tabular forms that can be used by Excel’s powerful tools.

Course Topics

 

Overview

  • Purpose of Power Query
  • Accessing Power Query

Understanding Query Editor

  • Components of Query Editor
  • Applied Steps
  • Advanced Editor

Accessing Different Data Sources

  • Accessing Excel Tables
  • Import Data from Text Files
  • Import Data from a Folder
  • Working with Excel files
  • Working with data from current workbook
  • Import from Web
  • Import from SQL Server database
  • Import from Access database

Data Transformation

  • Name, remove, split, merge and add columns
  • Filter rows
  • Remove duplicate rows
  • Change values in a column
  • Filling up and down
  • Aggregate values
  • Create custom columns
  • Duplicating columns
  • Unpivot columns
  • Merge queries
  • Group by functionality
  • Combining Queries
  • Duplicating and Referencing Queries
  • Viewing Query Dependencies

Handling Queries

  • Refresh queries
  • Delete a query

NOTE: This course can be run as a half day virtual training course.

Credible

Our live online reviews are proof that you can trust Trainers Direct to deliver. Book an Excel Trainer onsite today

Flexible

Our tailored training workshops are completely flexible to fit in with your busy schedule. 

Z

Experienced

Our instructors have a minimum of 15 years industry experience and carry relevant vendor qualifications such as Microsoft or Adobe Certified 

FIND US

 

Level 3, Suite 2, 828 Pacific Hwy, Gordon NSW 2072

02 9454 7702

Privacy