Vision & Mission
Upcoming Events
Training Programs
 
Industrial Relations
HR Management
& Development
Occupational Safety
& Health
Business Management
ICT
Certification &
Academic Courses
SWINBURNE
Certified Programs
UNIMAS
Certified Programs
In-house Courses
PSMB Scheme
Academy Staff
Contact Us
 
Training Directory 2024
 
MEF ACADEMY
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,
Malaysia

Tel: 603-7498 7200

 
 
Upcoming Trainings & Events
 
[IT] Power Query: Transforming Your Work Processes in Microsoft ExcelOnline Learning – Microsoft Teams 5 April 2023 (9.00 AM – 5.00 PM)
Download Registration Form
 
Course Fee
RM 700 (inclusive SST) per participant
 
If you can related to the following, Power Query will transform the way you work far more effectively than you have ever experienced
• I regularly get data from multiple sources e.g. Excel files, CSV/Text files, external databases (SQL, Access etc.), and bring it into Excel and consolidate it into one table so I can analyse it.
• My data is spread over multiple Excel worksheets/workbooks and I have to consolidate it into one table so I can use it
• The constant update of data received requires cleaning before I can use it -splitting text into multiple columns, remove columns/rows/duplicates , adding columns, Format text as dates or numbers, Other random data cleaning tasks that drive me crazy and waste my time
• I currently use Excel VBA/Macro to clean my data every week/month and it’s tedious
 
While normal Excel Functions or Macro/VBA can do all of the above tasks, Excel Power Query tool can perform far more
effectively - simply refresh Power Query and it gets your data and cleans it in seconds.
 
WHAT IS MICROSOFT EXCEL POWER QUERY?
Excel Power Query tool enables you to extract, transform and load data (ETL) very effectively. In this course, you will aquire the knowledge and skills in using Power Query which is far simpler, straight forward and easy to use when you need to extract, consolidate, merge data and automate work processes in Excel. Heavy users of Microsoft Excel will find this course very practical and useful. Basic knowledge of Microsoft Excel is assumed.
 
COURSE OUTLINE
LESSON 1 – INTRODUCTION TO POWER QUERY
LESSON 2 – GETTING STARTED WITH POWER QUERY
LESSON 3 – IMPORTING EXCEL DATA
LESSON 4 – CONSOLIDATE FILES IN A FOLDER
LESSON 5 – “UNPIVOT” PIVOT DATA
LESSON 6 – TRANSPOSING AND UNPIVOTING COMPLEX DATA
LESSON 7 – IMPORTING NON DELIMITED TEXT FILES
LESSON 8 – MERGING TABLES AND QUERIES
LESSON 9 – IMPORTING FROM DATABASES
LESSON 10 – OTHER POWER QUERY DATA SOURCES
LESSON 11 – DATA DESTINATIONS
LESSON 12 – GROUPING & SUMMARIZING
LESSON 13 – AUTOMATING REFRESH
LESSON 14 – POWER QUERY FORMULAS
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.