Power Query Training Intermediate Level: 1 Day

Power Query with Microsoft Excel 2013 / 2016 Training Course Power Query with Microsoft® Excel 2013/2016
By TED Integrated
Microsoft® Excel Series:

Mastering Microsoft® Excel 2013/2016 Power Query Intermediate

“Power Query is simply the best transformation and data manipulation tool for Excel and easier to use, understand and master than other tools.”

By TED Integrated

PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Mastering Microsoft® Excel 2013/2016 Power Query Intermediate
Training Category:
Information Technology
Target Audience:
Anyone who needs to work with Microsoft Excel in order to connect to external data and then process, analyse and display the data in order to produce suitable output at all levels within an organization. Excel Power Users, executives, managers, data & business analysts, IT professionals and BI Consultants.
1 Day
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English, Bahasa Malaysia
  • PowerPoint Presentation
  • Workshop
  • Presentation Handouts
  • Computer Lab Work
  • Lecture
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

This 1-day intermediate level Power Query training for Microsoft Excel 2013/2016 is suitable for partipants who are proficient users of Excel, familiar with PivotTables and understand the basics of Power Query Level One. The topics include importing data from Web, data restructuring, more advanced Power Query functions, understanding "M" code, and creating dynamic date table.

To request for in-house training, click on the Request for In-house Training link as displayed above for quotation. For a complete course cotent and more information about this course, feel free to contact the training provider as shown above. If the public program is available, you can request for a registration online by clicking on the Register for Public Training link. If the link is disabled, it simply means it has yet to be available for public. You can contact the training provider for further inquiry.

Course Objectives ›

During the training, you will use Power Query to:

  • Importing Data from Web Page and data feeds.
  • Transforming poorly structured data into useful data.
  • Use Power Query Functions & create customized functions.
  • Exploring the M code and take your Power Query skills to advance levels & create dynamic query.
  • Creating and implementing calendar tables.

Prerequisites ›

Delegates should be proficient users of Excel, familiar with PivotTables and understand the basics of Power Query Level One.

Course Outline ›


Importing Data from Web

This module explains to connect to website to import data from tables. Learn how to connect to OData feeds to get data. OData is a standard for providing access to data over the internet.

Data Restructuring

In this module, you will reshape data complex data structures such as cross tab tables, tables with multiple headers.

More Power Query Functions

This module shows how to use more power query functions and multiple condition logic, build customized functions and use it for repeated transformation.

Understanding M Code

In this module, you understand the logic of "M" code and how code is written. Complicated data transformation can be done using "M" language for Power Query. Learn how to access the HELP to Power Query functions. You will create a dynamic query using "M" code which makes the query flexible and allows others to use the query without having to modify it.

Creating A Dynamic Date Table

Date table is important with Time Intelligence scenarios with Power Pivot. With a dynamic date table, you will not need to extend your calendar manually as time goes by. You will also create Fiscal calendars which is a little more complicated than a normal fiscal year that ends in December.

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,