MICROSOFT EXCEL 2010/2013/2016/2019: POWER QUERY

24-25 Jun, 2024, Wyndham Grand Bangsar Kuala Lumpur

IPA Training is Registered with

Learn from the Best

Morgan holds a Degree in IT & Tech Management from UTM, he has 20 years working experience as a trainer in the field of Information Technology. He has obtained ITIL Certification and also PSMB approved trainer (TTT). He has conducted various trainings. His key expertise are:

 

·       - Conducting IT Training in the area of Basic Networking, PC Repairing, PC Troubleshooting & Microsoft Office Training

·       - Conducting research on the latest development and requirement for training based on customer request Developing & Maintaining a sound marketing strategy

·        -Ensure KPI and Customer Satisfaction are meet

 

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia.

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia. He's also a well sought after consultant and works on several key IT projects each year, with leading brands in the region.

Venue Details

Wyndham Grand Bangsar Kuala Lumpur
Jalan Pantai Baharu, Jaya Tower 3,
Phone : 03-2298 1888

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Introduction To Power Query
  • Appending Data From Multiple Sources / Formats
  • Merging Tables
  • Power Query Formulas
  • Transforming Data
  • Cleaning Dirty Data
COURSE OBJECTIVES

Participants attending this course will learn about Power Query and its features, including the ability to import, transform, and clean data from various sources.

 

The course also will teach how to import data from various sources, such as Excel spreadsheets, text files, databases, and web sources. Participants will understand how to transform data using Power Query, including filtering, sorting, grouping, and pivoting data.

 

Cleaning and shaping data using Power Query, including removing duplicates, splitting and merging columns, and dealing with errors and inconsistencies in data will also be taught. Besides that, participants will learn how to combine data from multiple sources using Power Query, including merging and appending data, and using lookup functions.

 

At the end of the course, participants will be taught how to automate data transformations using Power Query, including creating and managing queries

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Understanding Power Query
  2. Importing Data
  3. Transforming Data
  4. Cleaning And Shaping Data
  5. Combining Data
  6. Automating Data Transformations
  7. Importing/Connecting To External Data From Multiple Sources.
  8. Automating Data Transformation & Data Cleansing Processes.
  9. Combining Data From Multiple Sources Into A Single Source.
  10. Merging Data Without The Need Of Formulas Such As VLOOKUP, INDEX & MATCH.
  11. Performing Calculation To Aggregate Data.

Upon successful completion of this course, you will be proficient with Power Query and have the necessary skills to implement and automate the process of pulling in data, perform data transformation and data cleansing.

WHO SHOULD ATTEND
Data Analysts, Business Intelligence Professionals, and anyone who works with large datasets and needs to clean, transform, and analyse data efficiently within tools like Microsoft Excel, Power BI, or other data analysis platforms.
METHODOLOGY
Instructor-Led Training with classroom-style training led by an experienced instructor who guides participants through structured lessons, demonstrations, and hands-on exercises.
DAY 1
9:00

INTRODUCTION TO POWER QUERY

  • Data Connectivity
  • Data Transformation
  • Query Editor
  • Data Load And Refresh
10.45

APPENDING DATA FROM MULTIPLE SOURCES / FORMATS

  • Combining Data From Multiple Excel Sheets
  • Combining Data From Multiple Excel Files
  • Combining Data From Multiple Excel Files With Multiple Sheets
  • Combining Data From Multiple File Formats
1:00 Lunch
2:00

MERGING TABLES

  • Merging Data From Multiple Excel Tables
  • Merging Data From Multiple File Formats
  • Creating Tables Within Power Query For Merging
5:00 End of Day 1
DAY 2
9:00

POWER QUERY FORMULAS

  • Creating Formulas Easily
  • Date Functions
  • Calculations
10.45

TRANSFORMING DATA

  • Creating Report From Raw File
  • Inserting Calculated Columns
1:00 Lunch
2:00

CLEANING DIRTY DATA

  • Automating Cleansing From Raw Files
  • Charts With PQ
  • Pivot Table With PQ
5:00 End of Course