Skip To Content
Microsoft Excel Power Query is a Program

Microsoft Excel Power Query


Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Microsoft Excel Power Query

Course Duration

1 Day / 7 Hours

Course Outline

Introduction to Power Query

  • Installing Power Query
  • Creating a Simple Query
  • Editing a Simple Query

Common Data Import Sources

  • Working with CSV files
  • Working with Text Files
  • Working with Excel Files
  • Working with other file types

Working with Data from the Web

  • Scraping Data from Web Pages
  • Calling a Web Service
  • Finding Data Using a Power Query Online Search

Working with Folders and Multiple Files

  • Working from Data from the Windows File System
  • Combining Data from Multiple Files

Working with Columns

  • Moving Columns
  • Removing Columns
  • Splitting Columns
  • Merging Columns

Filtering and Sorting Rows

  • Using AutoFilter
  • Using Number, Text and Date Filters
  • Filtering Rows by Range
  • Removing Duplicate Values
  • Filtering out Rows with Errors
  • Sorting

Changing Values in a Table

  • Replacing Values
  • Text Transformations
  • Number Transformations
  • Date/Time Transformations
  • Replacing Missing Values

Table Transformations

  • Unpivoting Columns to Rows
  • Transposing a Table
  • Creating Custom Columns

Loading Data

  • Loading Data into a Worksheet
  • Loading Data into the Excel Data Model
  • Power Query and Table Relationships
  • Refreshing Queries Manually and Automatically


  • Proficiency in usage of computers
  • Already users of Microsoft Excel
  • Write formula and functions in their work
  • Create reports for presentation of information


Original course fee  $200 (with GST)

Union Training Assistance Programme (UTAP)

NTUC members enjoy UTAP* benefit of up to $250 each year when you sign up for courses with NTUC LearningHub.

* UTAP supports 50% of the course fees paid cap at $250 per year. You must be a union member throughout the course duration and at the time of claim. You must achieve a minimum of 75% attendance for each application and have sat for all prescribed examinations. Other terms and conditions apply.

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees