Skip To Content
Microsoft Excel Power Query is a Program

Microsoft Excel Power Query

Self-paced

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

Pre-requisites

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

Price

 Original course fee $270 (before GST)
 After funding for NTUC Union Member $20 (with GST)


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

UDSIT08