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:20260506T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260507T170000
DTSTAMP:20260417T180035
CREATED:20260115T023514Z
LAST-MODIFIED:20260410T014358Z
UID:14456-1778058000-1778173200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate and Advanced Level With AI Tools
DESCRIPTION:  \nDownload The Course Brochure Link \nThis course is designed to enhance participants’ skills in using Microsoft Excel and AI tools for advanced\ndata analytics and visualization. Participants will explore the powerful data manipulation\, analysis\, and\nvisualization features of Excel\, while also integrating AI tools to streamline tasks and uncover deeper\ninsights. The course will provide hands-on experience in cleaning\, analyzing\, and presenting data in\nmeaningful ways\, equipping participants with the tools necessary for smarter\, data-driven decision-making. \nWhat will you learn in this Microsoft Excel: Data Analytics and Visualization With AI Tools?\n\nImport and manage data from various sources into Excel for seamless analysis.\nClean and manipulate data effectively using Excel’s built-in functions and AI-enhanced\nfeatures.\nApply advanced Excel functions for logical analysis\, data matching\, and categorization.\nUtilize AI-powered features\, such as predictive modeling and automated insights\, within Excel.\nVisualize data effectively using Excel’s tools\, including charts\, conditional formatting\, and\nsparklines.\nCreate dynamic\, interactive dashboards using PivotTables\, PivotCharts\, and slicers for\nenhanced data exploration and storytelling.\nAutomate repetitive tasks and streamline analysis using Excel’s macros and AI-enhanced\nautomation tools.\n\nCourse Outline\nModule 1: Getting Data Into Microsoft Excel\nImport data from multiple platforms into Excel for further analysis\nExplore methods for efficient data importing and connecting to external data sources\nIntegrate AI tools to enhance data retrieval and preprocessing \nModule 2: Data Cleaning and Manipulation\nUtilize functions for combining and splitting text to enhance data readability\nClean data\, remove unwanted characters\, and ensure accuracy for better analysis\nLeverage AI tools for data cleaning\, such as automatic error detection and correction \nModule 3: Working With Numbers and Dates\nConvert data types from text to numbers\, dates to text\, and both numbers and text to dates\nMaster functions for generating dates\, calculating days between dates\, and more\nUse AI tools to automate complex calculations and date manipulations \nModule 4: Defined Names for Better Data Management\nLearn how to use cell referencing and naming for improved data organization\nCreate named ranges and automate processes for enhanced efficiency\nImplement AI tools to optimize data organization and structure \nModule 5: Automating Data Manipulation With Tables\nUtilize SMART TABLES for creating\, formatting\, and managing data tables\nFormat\, sort\, and filter data efficiently for improved organization\nApply AI tools to automate data sorting\, analysis\, and reporting \nModule 6: Logical And Lookup Functions\nEvaluate data using nested IF functions for advanced logical operations\nPerform logical operations with IF\, categorize data using VLOOKUP and XLOOKUP\nMaster advanced functions such as INDEX and MATCH for precise data matching\nIntegrate AI for predictive analysis and automated decision-making within Excel \nModule 7: Data Visualization\nVisualize data effectively using conditional formatting\, sparklines\, and number formats\nUtilize standard charts (line\, pie\, scatter) and specialized charts (hierarchy\, waterfall\, funnel\,\netc.) for insightful data representation\nLeverage AI tools to generate visualizations and identify trends automatically \nModule 8: Creating Interactive Dashboards\nSummarize data dynamically using PivotTables for quick insights\nCustomize\, group\, sort\, and filter pivot data for interactive dashboards\nCreate engaging dashboards with pivot charts\, slicers\, and timelines\nIntegrate AI tools to enhance dashboard interactivity and data presentation
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediate-and-advanced-level-with-ai-tools-6/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Data Analytics & Visualization In Excel,Microsoft Excel,Soft Skills
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/MAY26_MicrosoftExcelIntermediateAdvanced.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR