Data Analytics with Excel
1 day · Physical / Online · English (Bahasa Malaysia on request) · Public & In-house
A one-day, hands-on Excel course for working professionals. Participants clean data with Power Query, analyse it with XLOOKUP, dynamic arrays and PivotTables, build simple dashboards, and use Copilot in Excel to work faster, all with real workplace data.
Who should attend
Executives and staff who prepare reports, track numbers or work with spreadsheets every day, in any department.
Entry requirement
Basic Excel knowledge. Participants should bring a laptop with Microsoft Excel (Microsoft 365 recommended).
Learning outcomes
- Produce clean, reliable datasets that reduce manual errors in daily reporting
- Automate data cleaning and consolidation with Power Query to cut time spent on monthly reports
- Answer common business questions quickly using lookups, dynamic arrays and PivotTables
- Highlight exceptions and trends at a glance with conditional formatting
- Use Copilot in Excel to write formulas and draft insights, and check the AI output for accuracy
Course modules
- Excel foundations for clean data
- Data cleaning and transformation with Power Query
- Lookup and dynamic array functions
- Data summarisation with PivotTables and slicers
- Conditional formatting for exceptions and trends
- AI-powered analysis with Copilot in Excel
- Dashboard design and presenting insights
For Malaysian employers
Read the full HRD Corp claim guide →
Outside Malaysia, or not registered with HRD Corp? You can book this programme at standard fees.
Data Analytics with Excel
1 day · Physical / Online · English (Bahasa Malaysia on request) · Public & In-house
A one-day, hands-on Excel course for working professionals. Participants clean data with Power Query, analyse it with XLOOKUP, dynamic arrays and PivotTables, build simple dashboards, and use Copilot in Excel to work faster, all with real workplace data.
Who should attend
Executives and staff who prepare reports, track numbers or work with spreadsheets every day, in any department.
Entry requirement
Basic Excel knowledge. Participants should bring a laptop with Microsoft Excel (Microsoft 365 recommended).
Learning outcomes
- Produce clean, reliable datasets that reduce manual errors in daily reporting
- Automate data cleaning and consolidation with Power Query to cut time spent on monthly reports
- Answer common business questions quickly using lookups, dynamic arrays and PivotTables
- Highlight exceptions and trends at a glance with conditional formatting
- Use Copilot in Excel to write formulas and draft insights, and check the AI output for accuracy
Course modules
- Excel foundations for clean data
- Data cleaning and transformation with Power Query
- Lookup and dynamic array functions
- Data summarisation with PivotTables and slicers
- Conditional formatting for exceptions and trends
- AI-powered analysis with Copilot in Excel
- Dashboard design and presenting insights
For Malaysian employers
Read the full HRD Corp claim guide →
Outside Malaysia, or not registered with HRD Corp? You can book this programme at standard fees.