Microsoft® Excel Power Query Training

Microsoft® Excel Power Query Training Course Microsoft® Excel Power Query Training
By Sivanasan Sivarajah Julian
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
Jul 2017 ›
Venue:
ComSystem Solutions Training Centre, Wisma Goshen, Plaza Pantai, Kuala Lumpur, Malaysia
Schedule:
Tue 11 Jul 2017 9:00AM - 5:00PM
Fee Per Person:
RM1,400.00
Promotions:
  • Register before 01 Jul 2017 for only RM1,200 per person.
  • For 3 paxs registration, the 3rd person will receive a complimentary seat.
  • For 2 paxs registration, the 2nd person will be entitled to 20% discount.
Register Now!

* Other terms & conditions apply.

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 : [email protected], [email protected]

Related Courses ›

Published by: ,