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 - Intermediate
A vast majority of projects that suffer cost and time overruns do so because they lack professional scheduling. This course focuses on key tools of Microsoft Project needed by schedulers and planners; the Work Breakdown Structure (WBS) and the Critical Path Method (CPM).

Level - Fundamental
Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make!

Level - Advanced
Working with long documents in Microsoft Word can be a challenge. We will show you how to format documents quickly and consistently, how to add numbered headings, create a table of contents, an index, table or figure captions and cross-references. 

Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs