BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Academy Malaysia - HRD Corp Approved Training Provider
X-ORIGINAL-URL:https://www.excelacademy.my
X-WR-CALDESC:Events for Excel Academy Malaysia - HRD Corp Approved Training Provider
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Kuala_Lumpur
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:+08
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260812T000000
DTEND;TZID=Asia/Kuala_Lumpur:20260813T000000
DTSTAMP:20260604T153156
CREATED:20260525T032036Z
LAST-MODIFIED:20260525T043159Z
UID:14751-1786492800-1786579200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel With AI Tools for HR: Data Management and Reporting
DESCRIPTION:Download The Course Brochure Link \nThis practical two-day programme is designed for HR professionals looking to strengthen their proficiency in Microsoft Excel and AI-powered tools for managing employee data\, generating accurate reports and delivering meaningful workforce insights. Participants will learn to clean\, organise and analyse HR data efficiently\, create professional reports and interactive dashboards\, and apply automation techniques to significantly reduce manual effort. Using HR-relevant scenarios and real-world sample datasets throughout\, the programme ensures skills are immediately applicable to participants’ daily responsibilities — from routine headcount tracking to executive-level workforce analytics. \nWhat Will You Learn in Microsoft Excel with AI Tools for HR: Data Management and Reporting? \n\nStructure and manage HR datasets using Excel tables\, named ranges and data validation for organised\, error-free record-keeping.\nClean and standardise employee data using text functions and AI-assisted tools to ensure accuracy and consistency across HR records.\nApply logical\, lookup and date functions for key HR calculations including tenure\, leave balances and probation tracking.\nGenerate professional HR reports covering headcount\, turnover\, recruitment pipeline and compensation summaries for management review.\nAnalyse workforce data using PivotTables\, conditional formatting and statistical functions to surface actionable workforce trends.\nBuild interactive dashboards with slicers\, timelines and PivotCharts tailored for leadership reporting and strategic decision-making.\nLeverage AI features in Excel to automate repetitive reporting tasks and enhance the depth of data insights.\nApply data security and confidentiality best practices when handling sensitive employee information in compliance with organisational standards.\n\nCourse Outline \nModule 1: Excel Foundations for HR — Navigating Excel with HR workflows in focus — Setting up secure\, structured workbooks for employee data — Best practices for handling confidential HR information \nModule 2: Importing and Preparing HR Data — Importing data from external sources into Excel — Cleaning and standardising employee records using text functions (CONCAT\, TEXTSPLIT\, PROPER\, SUBSTITUTE) — Using AI tools to detect errors and suggest corrections \nModule 3: Essential HR Calculations and Data Organisation — Calculating tenure\, leave entitlements and probation dates using date functions — Applying logical functions (IF\, IFS) and lookup functions (XLOOKUP\, INDEX-MATCH) for employee data retrieval — Structuring data with tables and named ranges for efficient reporting and formula readability \nModule 4: Building Professional HR Reports — Creating standard reports: Headcount\, turnover\, recruitment pipeline and training participation — Formatting reports for clarity and executive presentation — Automating report updates with dynamic ranges and refreshable data connections \nModule 5: Workforce Analytics with PivotTables — Summarising employee data to analyse attrition\, diversity and compensation trends — Grouping and filtering data by department\, tenure or performance level — Using conditional formatting and sparklines to highlight key metrics and thresholds \nModule 6: Interactive Dashboards and Automation — Designing executive-ready dashboards using PivotCharts\, slicers and timelines — Incorporating KPIs and visual elements to communicate HR metrics effectively — Introduction to macros and AI-assisted automation for repetitive reporting tasks — Best practices for sharing and protecting HR dashboards
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-with-ai-tools-for-hr-data-management-and-reporting/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Human Resource,Microsoft Excel,Public training/course
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/05/AUG26_MicrosoftExcelDataAnalytics-1.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR