Power Automate & Power Query Training Malaysia (2 Days)
Automate the workflows, then automate the reporting behind them
Microsoft Power Automate & Excel Power Query is a two-day hands-on programme (HRD Corp programme no. 10001727572) that automates the two biggest sources of manual office work. Day one builds Power Automate flows — approvals, notifications, connector integrations, and mobile administration across Microsoft 365. Day two moves to Excel Power Query: importing, cleaning, combining, and transforming data into refreshable reports, through to M-language custom functions and calendar tables. Redefine Learning Asia asks participants to bring their own repetitive processes, which become the lab material.
When This Programme Is the Right One
The symptom: The team spends hours every week on approvals, notifications, and copy-pasting data between files.
Start from the symptom your team is showing rather than the programme name — buying in the wrong order usually convinces leadership that training does not work. Compare every programme side by side in our symptom-to-programme comparison table.
Learning Outcomes
- Participants build, publish, and maintain automated flows from templates and from blank, including approval and notification workflows.
- Automation logic — conditions, switches, apply-to-each, do-until, scopes — is applied to real decision-based workflows.
- Data from multiple files and folders is combined, cleaned, and transformed in Power Query into refreshable Excel reports.
- Participants leave with at least one working automation and one refreshable report built on their own process.
Programme Agenda
| Time | Module | What Happens |
|---|---|---|
| Day 1, 9.00am – 10.30am | Getting started with Power Automate | What Power Automate is and its role in Microsoft 365; templates versus blank flows; the editor and flow management. Lab: building an absence business process flow. |
| Day 1, 10.40am – 12.30pm | Automation logic | Conditions, switches, apply-to-each, do-until, and scopes. Lab: documentation review scheduling and notification flows. |
| Day 1, 1.30pm – 3.30pm | Integration and connectors | Standard and premium connectors; web services and on-premises data. Lab: Power Automate with SQL to review sales data. |
| Day 1, 3.45pm – 5.00pm | Mobile, administration, and maintenance | Flows from the mobile app; approvals and push notifications; history, analytics, sharing, environments, and data policies. |
| Day 2, 9.00am – 10.30am | Power Query fundamentals and imports | First queries; importing CSV, text, Excel, multiple files, and web data. |
| Day 2, 10.45am – 12.30pm | Combining, columns, filtering, sorting | Folder-level file combination; splitting and merging columns; filters, duplicates, error rows, grouping. |
| Day 2, 1.30pm – 3.30pm | Values and table transformations | Replacing and handling missing values; text, number, and date transformations; unpivoting, transposing, custom columns. |
| Day 2, 3.45pm – 5.00pm | Loading, the data model, and advanced queries | Loading to worksheets and the Excel Data Model; refresh management; M-language syntax, merged queries, custom functions, parameter and calendar tables. |
Activities
Facilitator demonstrations
Step-by-step walkthroughs of flow building, connector setup, mobile approvals, and transformation techniques.
Own-process labs
Participants identify their real repetitive processes before the course; the labs automate those, not invented examples.
SQL integration lab
A guided exercise connecting Power Automate to SQL data — the bridge from office automation to business systems.
Delivery, Pricing & HRD Corp
- Formats
- Instructor-led classroom with hands-on labs; participants need laptops with Microsoft 365 access. English or Bahasa Malaysia.
- Group size
- Up to 25 participants
- Indicative investment
- Quoted per group; typically structured as two facilitated days under a single HRD Corp grant application. Full breakdowns in the 2026 cost guide, or model your claim with the HRD Corp claim calculator.
- HRD Corp claimable
- Yes. This programme is structured as HRD Corp claimable training under SBL-Khas — certified trainer, documented learning outcomes, minimum contact hours, attendance records, and a completion report formatted for your claim. The grant must be approved at least 14 calendar days before the training date under Employer’s Circular No. 2/2026, so book three to four weeks ahead. See the full claim walkthrough in our HRD Corp claimable training guide.
Microsoft Power Automate & Excel Power Query FAQs
Request a proposal for Microsoft Power Automate & Excel Power Query
Tell us your team size and the problem you need this to fix. You will get a customised proposal with pricing, agenda, and the HRD Corp claim pathway.
Related Programmes
Time Management & Personal Productivity
Prioritisation and focus systems for teams drowning in meetings and messages
View Details →Corporate Training · 2 DaysMicrosoft Power BI: Basic to Intermediate
From raw spreadsheets to published, decision-ready dashboards
View Details →AI Training · 2 DaysAI Productivity, Analytics & Workflow Automation
The two-day flagship: from prompting to dashboards to AI agents
View Details →See every programme and format on our Corporate Training Malaysia page, or browse all corporate training courses.