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:20261012T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261013T170000
DTSTAMP:20260928T090112Z
CREATED:20260115T033044Z
LAST-MODIFIED:20260928T090112Z
UID:14347-1791795600-1791910800@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 intermediate and advanced Microsoft Excel skills while learning how AI can support data management\, analysis and reporting. \nParticipants will work with large datasets using advanced sorting\, filtering\, database functions\, formulas\, PivotTables\, PivotCharts\, scenario analysis\, conditional formatting and macros. The programme also introduces AI-assisted techniques that can support data cleaning\, pattern identification\, reporting and repetitive spreadsheet activities. \nBy combining advanced Excel techniques with AI-assisted workflows\, this Microsoft Excel Intermediate and Advanced Level training helps participants manage information more efficiently\, improve reporting accuracy and turn spreadsheet data into clearer business insights. \nWhat Will You Learn in This Microsoft Excel Intermediate and Advanced Level Data Management With AI Tools?\nThis Microsoft Excel Intermediate and Advanced Level training will help you 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\nWhy Attend This Microsoft Excel Intermediate and Advanced Level Data Management With AI Tools?\nThis Microsoft Excel Intermediate and Advanced Level with AI Tools programme is designed for professionals who already understand basic Excel functions and want to improve the way they manage\, analyse and report larger or more complex datasets. \nParticipants will learn practical techniques for organising information\, applying advanced formulas\, analysing scenarios and presenting results using PivotTables\, PivotCharts and other visualisation tools. These skills can help reduce manual work\, improve data accuracy and make business information easier to understand. \nAI-assisted techniques are introduced alongside Excel functionality to demonstrate how AI can complement existing spreadsheet workflows. This Microsoft Excel Intermediate and Advanced Level with AI Tools programme helps participants explore ways AI can assist with data cleaning\, formula development\, identifying patterns\, reviewing information and supporting repetitive tasks while maintaining appropriate human review. \nWho Should Attend?\nThis Microsoft Excel Intermediate and Advanced Level training is suitable for executives\, analysts\, administrators\, finance professionals\, HR teams\, operations staff and other employees who regularly use Microsoft Excel for reporting\, analysis or data management. \nIt is particularly suitable for participants who are already comfortable with basic Excel and want to progress towards more advanced data-management\, analysis and automation techniques. \nNo programming or advanced AI knowledge is required. \nCourse Outline\nThe Microsoft Excel Intermediate and Advanced Level course outline progresses from advanced data management and formulas to PivotTables\, scenario analysis\, visualisation 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 \nBy completing the Microsoft Excel Intermediate and Advanced Level programme\, participants can build greater confidence in handling complex data\, improving reporting accuracy and applying advanced Excel techniques in the workplace. \nFor more information about our training programmes\, visit Excel Academy Malaysia.
URL:https://www.excelacademy.my/event/excel-intermediate-and-advanced-level-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/OCT26_MicrosoftExcelIntermediateAdvanced-Data-Management-with-AI-Tools.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR