Powering Up with Power Query in Excel (Basics) – 2 Days

Date : 10/06/2026 - 11/06/2026
Time : 9:00 am - 5:00 pm
Location : The HUB @ Jaya One, PJ

Contact Person : Esther Yong
Email : inquiry@knowledgehub-asia.com
Mobile : +012-2662728
Office Tel : +603-7622 0578
Normal Rate : MYR 0.00
Promotion Rate : Contact us for discounted rate.

Course Objective

1. Understand the fundamentals of Power Query and its significance in data analysis.
2. Learn how   to    import    data    from    different sources into Excel using Power Query.
3. Master data    transformation    techniques   to clean, reshape, and merge data.
4. Discover the basics of Power Query formulas and expressions.
5. Build a foundation for more advanced Power Query usage and automation.

Learning Outcome

Upon completion, participants will be able to:

1. Navigate and    utilize   Power    Query    within Microsoft Excel proficiently.
2. Import data from various sources, such as databases, spreadsheets, and web data.
3. Transform and clean data effectively, including filtering, sorting, and removing duplicates.
4. Combine and merge multiple data sets into one coherent data set.
5. Create basic custom formulas and expressions in Power Query.
6. Automate data refresh and transformations for improved productivity.

For registration please Contact :

Email : inquiry@knowledgehub-asia.com
Contact Person : Esther Yong
Mobile : +012-2662728
Office Tel : +603-7622 0578