Power Query Training with Microsoft Excel

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

Introduction to Power Query with Microsoft® Excel 2010/2013

“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
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Introduction to Power Query with Microsoft® Excel 2010/2013
Training Category:
Information Technology
Target Audience:
Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.
Duration:
1 Day
Public Training Events
Dec 2017 ›
Venue:
TED Learning Center, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 18 Dec 2017 9:00AM - 5:00PM
Fee Per Person:
RM1,200.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jan 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 15 Jan 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Mar 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 01 Mar 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Apr 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 09 Apr 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
May 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 14 May 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Jun 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 27 Jun 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Jul 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 23 Jul 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Aug 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 08 Aug 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Sep 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Tue 18 Sep 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Oct 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 15 Oct 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Nov 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 12 Nov 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
Dec 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 06 Dec 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,272.00
Register Now!

* Other terms & conditions apply.
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
  • Workshop
  • PowerPoint Presentation
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

Power Query can connect to wide range of data sources. Databases such as SQL Server, Oracle, Text files, Big Data and Hadoop data sources, online searches and OData feeds, Cloud storage, Facebook, SharePoint and many other types of data storage. Power Query extracts the data from sources, and performs transformations such as splitting columns, data conversions, lookups, merge, append, data cleansing and many other data transformations AUTOMATICALLY without the use of VBA. Power Query introduced a new expression language called "M" for data transformations.

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

Course Objectives ›

Upon successful completion of this course, the delegate should be proficient with Power Query and have the necessary skills to implement and automate the process of pulling in data, perform data transformation and data cleansing.

During the training, you will use Power Query to:

  • Import / connect to external data from multiple sources.
  • Automate the data transformation & data cleansing processes.
  • Combine data from multiple sources into a single source.
  • Merging data without the need of formulas such as VLOOKUP, INDEX & MATCH.
  • Perform calculation to aggregate data.

Prerequisites ›

Delegates should be proficient users of Excel and be familiar with PivotTables.

Course Outline ›

DAY 1

Introduction to Power Query

This module explains what power query is and how you can download and install the power query on your computer. Learn how data files are imported / connected whether it's a text files, CSV file, database or any other source. Once the connection is built, refreshing the connection will automatically load the latest changes.

Appending Data from Multiple Sources / Formats

In this module, you will append data together into one source from multiple file formats, multiple sources and even an entire folder for the purpose of analysis. If the source is an Excel file, learn to pull data from multiple workbooks, multiple sheets and multiple tables.

Merging Tables

This module shows how easy to merge data without using formulas such as VLOOKUP, INDEX & MATCH. Perform more advanced merges using Inner, Outer, Full, and Anti Joins. Learn to automate reconciliations and throw out exceptional items.

Power Query Formulas

This module shows how to perform calculations such as SUM, AVERAGE & COUNT just like a pivot table. More complicated data transformation can be done using "M" language for Power Query.

Transforming Data

In Power Query, you will be able to transform selected columns into attribute-value pairs where columns become rows for data analysis which is required for Pivot Tables. Data that is structured incorrectly can be transformed easily.

Cleaning Dirty Data

The complete removal of dirty data from a source is virtually impossible. Power Query has some tools which can be used to clean some common problems such as missing data, data formatted incorrectly or date problems.

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: ,