Excel - Power Query

Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.

Location
Date
Duration

Half-day

Time (AWST)
Address
Participants
Total

Overview

The Excel - Power Query course will enable you to understand how to connect to a variety of data sources and extract data, group and summarise data and transpose and unpivot complex data. After completion of this course you will be able to understand basic Power Query formulas and the M language.

Content

  • Import data from databases and text files
  • Aggregate Excel worksheets
  • Group and summarise data
  • Transpose and unpivot complex data
  • Automate refreshing
  • Introduce Power Query formulas and the M language.

Learning Outcomes

Participants should be able to:

  • Connect to a variety of data sources and extract data
  • Clean and load the data into PowerPivot
  • Understand basic Power Query formulas.
Related Results

Level - Fundamental
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.

Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

Level - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.

Level - Advanced
This course is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. This course is for you, if you are a confident Word user.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs