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-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:20260611T093000
DTEND;TZID=Asia/Kuala_Lumpur:20260611T123000
DTSTAMP:20260604T112125
CREATED:20260525T045045Z
LAST-MODIFIED:20260525T045045Z
UID:14755-1781170200-1781181000@www.excelacademy.my
SUMMARY:Turning HR Data into Insightful Dashboards with Excel (Complimentary Sessions)
DESCRIPTION:Download The Course Brochure Link \nThis half-day interactive session equips HR professionals with the practical skills to transform raw HR data into automated reports and interactive dashboards using Microsoft Excel. Whether you are spending too much time manually compiling HR figures or struggling to present workforce data in a clear and compelling way for leadership\, this session gives you the hands-on tools and techniques to work smarter. Through live demonstrations\, guided practice and real HR dataset exercises\, participants will experience firsthand how Excel can streamline data cleaning\, automate reporting and bring HR metrics to life through professional\, interactive dashboards. By the end of the session\, participants will walk away with the confidence and capability to turn messy spreadsheets into meaningful HR insights\, making data-driven decisions faster and more effectively. \nWhat Will You Learn in Turning HR Data Into Insightful Dashboards with Excel? \n\nClean and structure HR data accurately to eliminate duplicates\, inconsistencies and missing values\, ensuring a reliable foundation for analysis.\nAutomate HR reports using Excel formulas and PivotTables\, reducing manual effort and enabling reports to refresh dynamically.\nVisualise key HR metrics with meaningful charts and conditional formatting to communicate workforce trends clearly and professionally.\nBuild a complete\, professional interactive HR dashboard with slicers\, timelines and linked summary tables for executive-level reporting.\n\nCourse Outline \nModule 1: Foundation\, Understanding HR Data \n\nTypes of HR data: headcount\, attendance\, turnover\, performance\nCommon HR data problems: duplicates\, inconsistencies\, missing values\nBest practices for structuring data in Excel\n\nModule 2: Data Cleaning and Preparation \n\nRemoving duplicates\, Text to Columns\, Flash Fill\nStandardising data with TRIM\, PROPER\, IF\, IFERROR\nConverting raw data into structured Excel Tables\n\nModule 3: Automating HR Reports \n\nCOUNTIFS\, SUMIFS\, AVERAGEIFS\nPivotTables for HR metrics\nRefreshing reports automatically\n\nModule 4: Visualising HR Data \n\nChoosing the right chart for HR metrics\nHeadcount trend and turnover charts\nConditional formatting for insights\n\nModule 5: Building the HR Dashboard \n\nDashboard layout principles\nSlicers and Timeline interactivity\nLinking charts and summary tables\nHands-on dashboard activity\n\nWrap-Up and Q&A \n\nKey takeaways recap\nCommon mistakes to avoid\nOpen Q&A session
URL:https://www.excelacademy.my/event/turning-hr-data-into-insightful-dashboards-with-excel-complimentary-sessions/
LOCATION:Excel Academy\, Excel Academy\, VSQ@PJCC Block 6 Level 5\, Jalan Utara\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Human Resource,Microsoft Excel
ATTACH;FMTTYPE=image/jpeg:https://www.excelacademy.my/wp/wp-content/uploads/2026/05/WhatsApp-Image-2026-05-15-at-11.36.01.jpeg
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260707T093000
DTEND;TZID=Asia/Kuala_Lumpur:20260707T123000
DTSTAMP:20260604T112125
CREATED:20260522T034924Z
LAST-MODIFIED:20260525T045745Z
UID:14743-1783416600-1783427400@www.excelacademy.my
SUMMARY:Strategic Workforce Planning (Complimentary Session)
DESCRIPTION:Download The Course Brochure Link \nThis half-day interactive session equips HR professionals and managers with practical workforce forecasting strategies to align talent planning with business growth and future workforce challenges. Facilitated by a seasoned Human Resources specialist with over 28 years of cross-industry experience\, this session brings together proven techniques in talent demand and supply analysis\, strategic staffing approaches\, and workforce forecasting — helping organisations build a resilient and future-ready workforce. \nWhether you are navigating labour shortages\, managing workforce surpluses\, or aligning HR strategy with long-term business direction\, this session provides the tools and frameworks to make confident\, data-informed workforce decisions. \nWhat Will You Learn in Strategic Workforce Planning? \n\nIdentify the role of Strategic Workforce Planning within the broader business context and understand why it is one of the most critical HR functions supporting organisational continuity and growth.\nAppreciate current and emerging workforce management challenges\, including shifts in internal and external labour demand and supply.\nDefine workforce planning within the Human Resources management function and understand its scope and application.\nUnderstand the relationship between workforce planning and organisational strategic planning\, and how to align both effectively.\nFormulate staffing strategies to address labour shortages and surpluses\, and develop both short-term and long-term workforce solutions.\n\nProgramme Outline \nModule 1: Roles and Responsibilities — Roles and responsibilities in Workforce Planning — Importance of Management Support in Workforce Planning — Internal vs External Labour Challenges \nModule 2: Workforce Analysis — Strategic vs Operational Manpower Review — Current Issues and Challenges in Workforce Analysis — Alignment of Workforce Planning towards Business Strategies \nModule 3: Forecast Needs — Historical Analysis — Forecasting Techniques — Right Number with the Right Skills at the Right Time \nModule 4: Analyse Gaps — Challenges in Talent Attraction and Retention — Square Pegs in Round Holes — Rightsizing vs Downsizing Approaches \nModule 5: Develop Strategies — Understanding Internal and External Labour Demand and Supply — Matching Strategies with Business Direction — Short-Term Strategies vs Long-Term Strategies \nModule 6: Implement Strategies — Implementing the Appropriate Strategies — Getting Support in Implementing Workforce Strategies — Roles and Responsibilities in Implementing Strategies \nModule 7: Putting It All Together — Preparing the Overall Workforce Planning for Management Approval — Convincing Management on Workforce Requirements — Workforce Review Where Necessary
URL:https://www.excelacademy.my/event/strategic-workforce-planning-complimentary-session/
LOCATION:Excel Academy\, Excel Academy\, VSQ@PJCC Block 6 Level 5\, Jalan Utara\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Human Resource
ATTACH;FMTTYPE=image/jpeg:https://www.excelacademy.my/wp/wp-content/uploads/2026/05/WhatsApp-Image-2026-05-15-at-10.16.11.jpeg
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260812T000000
DTEND;TZID=Asia/Kuala_Lumpur:20260813T000000
DTSTAMP:20260604T112125
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