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 |
|
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… |
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 | |||||||||||||||
|
| DAY 2 | |||||||||||||||
|