BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.18.3.1//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:20261208T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261209T170000
DTSTAMP:20261111T071055Z
CREATED:20260115T045734Z
LAST-MODIFIED:20261111T071055Z
UID:14394-1796720400-1796835600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Power BI with AI Tools: Data Analysis and Visual Reporting
DESCRIPTION:  Download The Course Brochure Link \nMicrosoft Power BI with AI Tools is a practical training programme designed to help professionals transform raw data into meaningful insights\, interactive dashboards and visual reports using Microsoft Power BI and AI-assisted capabilities. \nParticipants will develop practical skills in data preparation\, modelling\, analysis and visualisation while exploring how AI can support reporting\, identify patterns and simplify selected analytical tasks. The programme covers Power Query\, data modelling\, DAX\, interactive dashboards\, AI-assisted insights and report publishing. \nThrough hands-on exercises\, participants will learn how to turn business data into clear\, actionable information that can support better decision-making. By the end of this Microsoft Power BI with AI Tools programme\, participants will have greater confidence in building reports and dashboards that communicate data effectively. \nWhat will you learn in this Microsoft Power BI with AI Tools: Data Analysis and Visual Reporting\n\nUnderstand the fundamentals of Business Intelligence (BI) and how AI tools elevate data\nanalysis and reporting.\nNavigate the Power BI interface and integrate AI capabilities seamlessly into data workflows.\nUtilize natural language processing (NLP) tools like Q&A for instant data queries and smarter\nreporting.\nPrepare and transform raw data using Power Query Editor\, optimizing it with AI enhancements.\nDesign and customize visually compelling reports and dashboards with AI-generated\nnarratives and predictive analytics.\nPublish and share reports and dashboards securely\, ensuring collaborative engagement and\nadherence to best practices.\n\nWhy Attend This Microsoft Power BI with AI Tools Training?\nThis Microsoft Power BI with AI Tools training is designed for professionals who want to improve the way they analyse\, visualise and communicate business data. \nInstead of relying only on static spreadsheets or manually prepared reports\, participants will learn how Power BI can bring together data from different sources and turn it into interactive reports and dashboards. The programme introduces practical techniques for preparing data\, creating relationships\, performing calculations and presenting findings in a clearer visual format. \nAI-assisted capabilities are introduced alongside the core Power BI workflow to help participants explore data more efficiently\, identify useful patterns and communicate findings more effectively. By completing the Microsoft Power BI with AI Tools programme\, participants can develop a more structured approach to analysing business data\, creating interactive dashboards and presenting insights that support better workplace decisions. \nCourse Outline\nModule 1: Introduction to Self-Service BI and AI Tools\n– Overview of Business Intelligence (BI) Concepts\n– Introduction to AI Tools in BI: Transforming Data Analysis\n– Understanding Microsoft Power BI’s AI Capabilities \nModule 2: Getting Started With Power BI\n– Navigating the Power BI Interface and Features\n– Understanding the Differences Between Power BI Desktop and Power BI Service\n– Setting Up Power BI for Data and AI Integration \nModule 3: Power BI Data Sources and Preparation\n– Importing Data from Various Sources\n– Exploring Data Quality Enhancements\n– Utilizing AI to Power Query Editor for Data Cleaning and Transformation \nModule 4: Fundamentals of Data Modeling\n– Creating and Managing Relationships in Data Models\n– Utilizing AI to Optimize Data Types and Structures\n– Simplifying Data Models with Automated Insight \nModule 5: Advanced Data Analysis With DAX And AI\n– Introduction to DAX (Data Analysis Expressions)\n– Using Calculations and Measures for Advanced Data Analysis\n– Applying AI-powered to create a DAX Formula \nModule 6: Creating Advanced Dashboards With AI-Driven Insights\n– Designing Interactive Dashboards Using Slicers and Filters\n– Incorporating AI-Generated Predictive Analytics and Trends\n– Best Practices for Building AI-Enhanced Dashboards \nModule 7: Leveraging AI Models In Power BI\n– Applying Sentiment Analysis and Text Mining in Power BI\n– Creating Custom AI Models for Industry-Specific Use Cases \nModule 8: Enhancing Report Design With AI\n– Using AI to Automate Report Narratives and Explanations\n– Optimizing Reports for Performance and Accessibility\n– Applying AI-Enhanced Data Storytelling Techniques \nModule 9: Publishing\, Sharing\, and Collaborating With AI Insights\n– Publishing Reports to Power BI Service\n– Collaborative Features: Sharing AI-Powered Dashboards\n– Ensuring Security and Compliance in Reporting \nThe Microsoft Power BI with AI Tools programme gives participants practical exposure to reporting\, dashboard development and AI-supported analysis that can be applied to real workplace data and business reporting needs. \nFor more information about our training programmes\, visit Excel Academy Malaysia. 
URL:https://www.excelacademy.my/event/microsoft-power-bi-with-ai-tools-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Mastering Interactive Dashboard Reporting with Power BI,Microsoft Excel
ATTACH;FMTTYPE=image/jpeg:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/WhatsApp-Image-2026-11-11-at-14.45.02.jpeg
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261208T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261209T170000
DTSTAMP:20261113T064826Z
CREATED:20260904T011908Z
LAST-MODIFIED:20261113T064826Z
UID:14906-1796720400-1796835600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Mastering Malaysian Payroll & Statutory Compliance with AI
DESCRIPTION:Download The Course Brochure Link \nMastering Malaysian Payroll is a practical two-day programme designed to help HR\, payroll and finance professionals manage payroll calculations\, statutory obligations and monthly payroll processes with greater accuracy and confidence. Payroll accuracy involves more than ensuring salaries are paid on time. Errors in wage classification\, statutory contributions\, overtime calculations or tax deductions can repeat month after month and may lead to back payments\, penalties\, compliance issues and loss of employee trust. \nThis Mastering Malaysian Payroll programme also helps participants with the knowledge and hands-on skills needed to manage Malaysian payroll accurately and confidently\, from monthly salary calculations and statutory contributions to payroll tax administration\, employee movements\, payroll controls and compliance. Participants will learn how to classify different pay elements\, calculate incomplete-month salary and overtime\, administer statutory obligations including EPF\, SOCSO\, EIS\, SKBBK and HRD levy requirements\, and manage PCB/MTD and other payroll-related deductions. \nThe Mastering Malaysian Payroll programme combines guided briefings\, hands-on calculations and realistic Malaysian payroll cases\, with an emphasis on understanding the calculation first before relying on systems or automated tools. Participants will also use HRLah.my\, a Malaysian HR and payroll research companion\, to verify payroll requirements against their governing provisions. By the end of the programme\, participants will be better equipped to identify payroll errors\, strengthen internal controls and manage monthly payroll processes with greater accuracy\, consistency and compliance. \nWhat Will You Learn in This Mastering Malaysian Payroll & Statutory Compliance with AI Programme?\nThis Mastering Malaysian Payroll  programme will help participants develop practical skills in: \n\nMap the complete monthly payroll cycle from cut-off and data input through calculation\, approval\, payment and statutory submission.\nClassify salary\, allowances\, incentives\, bonuses\, reimbursements and other pay elements correctly for payroll purposes.\nCalculate monthly salary\, incomplete-month pay\, unpaid leave\, arrears\, adjustments and payroll corrections accurately.\nCalculate ordinary rate of pay and hourly rate of pay for overtime\, rest-day and public-holiday payments.\nDetermine employee coverage and administer EPF\, SOCSO\, EIS\, SKBBK and HRD levy requirements.\nManage PCB/MTD administration\, including relevant employee declarations\, tax directives and payroll deductions.\nProcess new joiners\, leavers\, final payments\, outstanding claims and payroll corrections appropriately.\nApply payroll validation\, reconciliation\, approval and segregation-of-duties controls.\nMaintain accurate payroll records and protect confidential employee information under appropriate data-protection practices.\nUse AI-supported tools such as HRLah.my to verify payroll requirements against relevant governing provisions.\n\nCourse Outline\nThe Mastering Malaysian Payroll course outline progresses from payroll fundamentals and salary calculations to statutory contributions\, payroll tax administration\, employee movements and monthly payroll controls. \nModule 1: Payroll Framework\n\nUnderstand the payroll process from gross pay to net pay.\nMap payroll cut-off\, calculation\, approval\, payment and submission activities.\nClarify responsibilities across HR\, payroll\, finance and authorised approvers.\nUnderstand the Malaysian statutory landscape affecting payroll.\n\nModule 2: Pay Elements\, Wage Definitions and Lawful Deductions\n\nClassify salaries\, allowances\, incentives\, commissions and reimbursements.\nUnderstand how wage definitions differ across statutory requirements.\nApply lawful deductions\, authorisation requirements and deduction limits.\nManage salary advances\, loans\, overpayments and recovery arrangements.\n\nModule 3: Salary\, Incomplete-Month and Leave-Related Calculations\n\nCalculate monthly salary and incomplete-month payments.\nProcess unpaid leave\, no-pay days and salary adjustments.\nManage arrears\, back pay and retrospective salary changes.\nDocument exceptional calculations and maintain appropriate approval trails.\n\nModule 4: Ordinary Rate of Pay\, Overtime\, Rest Days and Holidays\n\nDetermine eligibility for working-time and overtime protections.\nCalculate ordinary rate of pay and hourly rate of pay.\nCalculate overtime\, rest-day and public-holiday payments.\nIdentify common attendance\, approval and calculation errors.\n\nModule 5: EPF\, SOCSO\, EIS\, SKBBK and HRD Levy Administration\n\nDetermine statutory coverage based on employee circumstances.\nApply current EPF\, SOCSO and EIS contribution requirements.\nUnderstand SKBBK and HRD levy administration.\nManage contribution deadlines\, corrections and coverage exceptions.\n\nModule 6: PCB/MTD and Payroll Tax Administration\n\nUnderstand employer responsibilities for PCB/MTD administration.\nManage recurring and additional remuneration in payroll.\nUnderstand TP1\, TP2 and CP38 requirements within payroll processing.\nIdentify payroll items requiring additional tax attention and review.\n\nModule 7: Joiners\, Leavers\, Final Pay and Corrections\n\nSet up new employees and validate payroll information.\nManage resignations\, terminations and final-pay calculations.\nProcess outstanding payments\, recoveries and payroll corrections.\nApply appropriate payroll checklists and documentation for employee movements.\n\nModule 8: Payroll Controls\, Records\, Privacy and Monthly Close\n\nEstablish pre-payroll\, calculation and post-payroll control points.\nApply maker-checker reviews\, approvals and segregation of duties.\nPerform payroll\, headcount\, bank-file and statutory reconciliations.\nMaintain payroll records\, protect employee data and complete the monthly close.\n\nBy completing this Mastering Malaysian Payroll programme\, participants will be better equipped to process payroll accurately\, manage statutory requirements and maintain stronger payroll controls in the workplace. The practical knowledge gained through Mastering Malaysian Payroll can also help participants identify potential payroll errors earlier\, improve monthly reconciliation processes and support more consistent payroll administration across the organisation. \nFor more information about our training programmes\, visit Excel Academy Malaysia. 
URL:https://www.excelacademy.my/event/mastering-malaysian-payroll/
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/09/WhatsApp-Image-2026-11-13-at-14.14.40.jpeg
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261214T080000
DTEND;TZID=Asia/Kuala_Lumpur:20261215T170000
DTSTAMP:20260928T091500Z
CREATED:20260408T071035Z
LAST-MODIFIED:20260928T091500Z
UID:14662-1797235200-1797354000@www.excelacademy.my
SUMMARY:HRD Corp Claimable- Microsoft Excel Intermediate and Advanced Level: Data Management with AI Tools
DESCRIPTION:Download The Course Brochure Link \nMicrosoft Excel Intermediate and Advanced Level is a practical training programme designed to help professionals strengthen their Excel skills while exploring AI-powered tools for data management\, analysis and reporting. Participants will learn how to manage complex datasets\, apply advanced functions\, create dynamic visualisations and improve everyday spreadsheet workflows. \nThrough hands-on exercises\, the Microsoft Excel Intermediate and Advanced Level programme introduces advanced Excel techniques alongside AI-assisted features that can help automate repetitive tasks\, identify patterns\, improve data accuracy and support more effective decision-making. Participants will also explore PivotTables\, PivotCharts\, scenario analysis\, macros and other tools for handling more demanding workplace data requirements. \nWhat will you learn in this Microsoft Excel Intermediate and Advanced Level With AI Tools?\nThis Microsoft Excel Intermediate and Advanced Level training will help participants develop practical skills in: \n\nEfficiently manage and organize large datasets using complex sorting\, filtering\, and database\nfunctions.\nAutomate error-checking and validation tasks using AI-enhanced features.\nCreate visually compelling reports and dashboards using AI-assisted design\nrecommendations.\nLeverage AI tools to identify patterns and trends in large datasets.\nStreamline repetitive tasks by combining Excel macros with AI-powered workflows.\nEnhance decision-making with predictive modeling and AI-driven scenario analysis.\nBuild dynamic PivotTables and PivotCharts enriched with AI insights for data storytelling.\n\nWho Should Attend?\nThis Microsoft Excel Intermediate and Advanced Level programme is suitable for professionals who already have a basic understanding of Excel and want to strengthen their skills in data management\, analysis\, reporting and automation. \nIt is particularly suitable for: \n\nExecutives and managers who work with reports and business data\nFinance and accounting professionals\nHR and administrative professionals\nOperations and project teams\nBusiness and data analysts\nProfessionals who regularly manage large or complex Excel datasets\nExcel users who want to improve their use of advanced functions\, PivotTables and PivotCharts\nProfessionals interested in using AI-assisted tools to improve spreadsheet productivity\n\nParticipants should be comfortable with basic Excel functions before attending\, as the programme focuses on intermediate and advanced techniques. \nCourse Outline\nThe Microsoft Excel Intermediate and Advanced Level course outline progresses from advanced data management and functions to visualisation\, PivotTables\, scenario analysis\, workbook security and task automation. \nModule 1: Advanced Data Management\n– Sorting and Filtering by Multiple Criteria\n– Custom Sorting and Advanced Filter Options\n– Data Cleaning with AI Assistance (e.g.\, ChatGPT or Power Query with AI integration) \nModule 2: Database Functions for Data Accuracy\n– Applying Subtotals\, Custom Sorts\, and Multi-Level Validation\n– Customizing Error Messages and Data Validation Rules\n– Extracting Online Data using AI Formulas \nModule 3: Using and Customizing Templates\n– Modifying Workbook Templates\n– Accessing Online Templates\n– Creating Custom Templates with AI-Driven Suggestions\n– Using AI Translate for Multi Language Data \nModule 4: Advanced Charting and Visualization\n– Combined Chart Types and Secondary Axes\n– Formatting and Customizing Chart Elements\n– AI-Assisted Chart Recommendations (e.g.\, in Excel 365 Insights)\n– Applying Sparklines for In-Cell Visualization \nModule 5: Advanced Filtering Techniques\n– Filtering Data by Complex Criteria\n– Using Database Functions (DSUM\, DAVERAGE)\n– Extracting Unique Values and Removing Duplicates Using AI \nModule 6: Securing Data With Worksheet Protection\n– Protecting Worksheets and Workbooks with Passwords\n– Allowing Selective Editing\n– Managing Permissions for Workbook Sharing \nModule 7: Auditing Tools and Range Names\n– Assigning and Managing Range Names\n– Using Auditing Arrows and Formula Auditing\n– Locating and Correcting Errors with Trace Features \nModule 8: Importing and Exporting Data\n– Importing External Data\n– Exporting Data for Use in Other Applications\n– AI-Based Data Cleaning and Formatting \nModule 9: Using Advanced Functions For Analysis\n– Logical Functions (IF\, AND\, OR)\n– Lookup Functions (VLOOKUP\, HLOOKUP\, INDEX\, MATCH)\n– Statistical Functions (COUNTIF\, RANK) \nModule 10: PivotTables and PivotCharts\n– Constructing and Formatting PivotTables\n– Grouping Data\, Adding Filters\, and Using Slicers\n– AI-Powered Data Insights for PivotTables \nModule 11: Scenario Analysis and Data Tables\n– Setting Up Scenarios for ‘What-If’ Analysis\n– Creating and Managing Data Tables\n– Generating Scenario Summaries with Predictive AI Tools \nModule 12: Collaborative Workbook Tracking\n– Tracking Changes and Reviewing History\n– Comparing and Merging Workbooks\n– AI-Powered Version Management \nModule 13: Conditional Formatting and Custom Formats\n– Applying Data Bars\, Color Scales\, and Icon Sets\n– Creating Custom Number Formats\n– AI-Based Recommendations for Formatting \nModule 14: Automating Tasks With Macros\n– Recording and Running Macros\n– Editing Macros for Flexibility\n– Assigning Macros to Buttons and Quick Access Toolbar \nThroughout the Microsoft Excel Intermediate and Advanced Level programme\, participants will strengthen their ability to combine advanced Excel functions\, analytical techniques and AI-assisted features in practical workplace scenarios. \nBy completing this Microsoft Excel Intermediate and Advanced Level programme\, participants will be better equipped to manage complex spreadsheet tasks\, analyse business data\, automate repetitive processes and create more effective reports using both advanced Excel features and AI-assisted tools. \nFor more information about our training programmes\, visit Excel Academy Malaysia. 
URL:https://www.excelacademy.my/event/excel-intermediate-and-advanced-level/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel,Public training/course
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/04/DEC26_MicrosoftExcelIntermediateAdvancedLevel.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR