PLEASE CLICK HERE to view upcoming event. Information here is outdated

Microsoft Excel Power Query

24 Mar, 2025, CONCORDE HOTEL KUALA LUMPUR

IPA Training is Registered with

Venue Details

CONCORDE HOTEL KUALA LUMPUR
2 Jalan Sultan Ismail, 50250 Kuala Lumpur, Malaysia,

https://kualalumpur.concorde hotelsresorts.com/


Phone : +603 2144 2200

Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

FOCUSING ON
  • Module 1: Introducing Power Query
  • Module 2: Types of Query Connections
  • Module 3: Transforming Data with Power Query
  • Module 4: Creating Custom Columns
  • Module 5: Table Transformations
  • Module 6: Loading Data to Excel
  • Module 7: Manage Query Editor
COURSE OVERVIEW
Power Query is a business intelligence tool available in Excel that allows you to access and import large corporate data from many different sources into the data model in a single Excel workbook. With the Power Query Editor, you can clean the raw data and transform it, then reshape it according to your needs.
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Importing and transforming data from multiple sources.
  2. Learning about data model creation.
  3. Combining data from folders and multiple worksheets.
  4. Merging data without having to use VLOOKUP, INDEX and MATCH functions.
  5. Analysing and Producing Reports.
WHO SHOULD ATTEND
Anyone who frequently uses Excel for data analysis, reporting, or data management will find Power Query invaluable. It simplifies complex data transformation tasks and automates repetitive processes.
METHODOLOGY
This course is a Instructor Led Training – interactive lectures which includes discussions and practical exercises.
COURSE CONTENT
9:00

MODULE 1: INTRODUCING POWER QUERY

  • Overview of Excel Power Query
  • Power Query Editor Ribbons
  • Creating a simple Query
  • Understanding Query Steps
  • Refreshing Power Query Data
 

MODULE 2: TYPES OF QUERY CONNECTIONS

  • Extracting Data from Excel files
  • Getting data from CSV & Text files
  • Getting data from folders
  • Importing Data from Database System
10.45

MODULE 3: TRANSFORMING DATA WITH POWER QUERY

  • Removing duplicate records
  • Changing Case
  • Trimming and cleaning text
  • Finding and replacing specific text
  • Extracting left, right and middle values
12.00

MODULE 4: CREATING CUSTOM COLUMNS

  • Splitting Columns
  • Naming Columns
  • Concatenate Columns
  • Custom Columns with functions
  • Adding conditional logic to Custom Columns
1:00 Lunch
2:00

MODULE 5: TABLE TRANSFORMATIONS

  • Pivoting and Un-Pivoting fields
  • Transposing a Table
  • Sort and Filter Data
3:00

MODULE 6: LOADING DATA TO EXCEL

  • Loading Data into a Worksheet
  • Loading Data into the Excel Data Model
  • Power Query and Table Relationships
3:45

MODULE 7: MANAGE QUERY EDITOR

  • Edit Query Steps
  • Edit Query Step Settings
  • Duplicating Queries
  • Refresh a Query
5:00 End of Course