Microsoft® Excel Power Query Training

Microsoft® Excel Power Query Training Course Microsoft® Excel Power Query Training
By Sivanasan Sivarajah Julian
Microsoft Office Family:

Integrating Microsoft® Excel Power Query Technology

“Simplifying data discovery, access and collaboration...”

By Sivanasan Sivarajah Julian


PSMB Certified Trainer
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
Contact Customer Service +603-5162-8254
+603-2201-4622
Email Customer Service maler@comsystemsolutions.com
comsystem@comsystem . . . .com
Course Title:
Integrating Microsoft® Excel Power Query Technology
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 organisation. Attendees on the course will be existing users of Microsoft Excel 2010 or 2013 who are new to Power Query and whose role requires the use of data tools for analysis purposes.
Duration:
1 Day
Public Training Events
Oct 2019 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Wed 16 Oct 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,400.00
Promotions:
  • Register before 06 Oct 2019 for RM1,200 discount per person.
  • For 3 paxs registration, the 3rd person will receive a complimentary seat.
Register Now!

* Other terms & conditions apply.
Dec 2019 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Mon 16 Dec 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,400.00
Promotions:
  • Register before 06 Dec 2019 for RM1,200 discount per person.
  • 20% Discount for the 2nd seat registration.
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact ComSystem Solutions
Contact customer service +603-5162-8254
+603-2201-4622
Email customer service maler@comsystemsolutions.com
comsystem@comsystemsolutions.com
Delivery Methods
  • Language: English
  • Workshop
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

Microsoft Excel Power Query technology enhances the self-service business analytics experience in Excel by simplifying data discovery, access and collaboration. Power Query for Microsoft Excel functioned as an Excel add-in that can be downloaded and installed on Excel 2010 and 2013. When comes to data transformation, Power Query can be a good alternative to VBA as it does not require programming effort.

Course Objectives ›

Upon completion of this Power Query training, participants should be able to:

  • Connect to many new data sources, such as Facebook and Salesforce, to import the data
  • Extract a preview of the data and load it to the Query Editor to define transformation steps that will allow you to transform the data to the format that meets your needs, such as remove, group, pivot or unpivot columns, and filter rows
  • Find the data you need by searching the Power BI
  • Simply click the Refresh All button on the Data ribbon to repeat the import and transformation of the data to your workbook

Prerequisites ›

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

Course Outline ›

DAY 1
  • Introduction to Microsoft Power Query for Excel Concepts and Components Compatible Data Sources Data Import Process
  • Import Data from External Data Sources Connect To and Query Compatible Data Sources Using the Default Excel Table Output
  • Transforming Table Data Filter, Sort and Group Data Group Rows Shape Data Replacing Values, Text Transforms, Number Transforms, Date and Time Transforms Data Aggregation Unpivoting Transposing a Table Work with Columns Name, Move, Split, Merge
  • Using the Query Editor Edit Query Steps Edit Query Step Settings Refresh a Query Combine Multiple Queries Merge and Append Queries Manage Queries
  • Shape Data from Multiple Data Sources Power Query and Table Relationships Table Links and Navigation Choose a Destination for your Data Add a Query to an Excel Worksheet Add a Query to the Data Model Advantages of using the Data Model
  • An Introduction to Advanced Queries Creating an Advanced Query Modify a Formula Power Query Formula Language

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-5162-8254, +603-2201-4622
Email Customer Service E-mail : maler@comsystemsolutions.com, comsystem@comsystemsolutions.com

Related Courses ›

Published by: ,
online learning icon Request for Online Training
Contact Us
Animated Progress Icon

Contact Assistant