Course Overview Print

Power Query revolutionises how data is collected, shaped, and analysed in Excel. This course helps participants automate data preparation from multiple sources and create repeatable workflows for reporting. They will build confidence in using Power Query Editor to transform raw data into meaningful insights.

Learning Outcomes:

  • Connect to and import data from various sources

  • Clean, filter, and shape data using Power Query Editor

  • Automate data refresh and transformation workflows

  • Merge and append queries to combine data sets

  • Prepare data for PivotTable and chart analysis

Key Topics:

  • Power Query interface and tools

  • Data connection and transformation steps

  • Merging, appending, and parameterisation

  • Applied steps, functions, and custom columns

Course Outline

Module 1: Power Query Overview

  • What is Power Query
  • Connect Data Sources
  • Use Power Query Editor  

Module 2: Shape and Transform Data

  • Apply Data Transforming Principles to a Table
  • Apply Data Transforming Principles to a Column
  • Add Custom Column
  • Use Applied Steps

Module 3:  Combine Data from multiple sources

  • Using Append Queries
  • Using Merge Queries (Left, Right, Inner, Full, Fuzzy)
*Important Note : Fees are subject to Singapore's prevailing Goods and Services Tax (GST).
Modern Data Analysis with Excel Power Query
Fees Enquire Now

Have Question?

We’re here to help — reach out anytime.

By submitting this form, you consent to be contacted via email and/or your mobile number regarding your enquiry. You consent to the collection, use, disclosure and processing of your personal data in accordance with our Personal Data Policy.