BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.18.2//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:20261111T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261112T170000
DTSTAMP:20261009T083445Z
CREATED:20260115T033756Z
LAST-MODIFIED:20261009T083445Z
UID:14366-1794387600-1794502800@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-3/
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/01/NOV26_MicrosoftExcelIntermediateAdvanced-1.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261117T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261118T170000
DTSTAMP:20260914T043240Z
CREATED:20260115T034029Z
LAST-MODIFIED:20260914T043240Z
UID:14375-1794906000-1795021200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel with AI Tools: Data Analytics and Visualization Tools
DESCRIPTION:Download The Course Brochure Link \nMicrosoft Excel with AI Tools is a practical training programme designed to help professionals strengthen their skills in data analytics\, data management and visualisation. Participants will explore how Microsoft Excel can be used to clean\, organise\, analyse and present business data while also learning how AI-assisted tools can support selected analytical and repetitive tasks. \nThe programme covers essential data-analysis techniques including importing information from different sources\, data cleaning\, logical and lookup functions\, structured tables\, data visualisation\, PivotTables\, PivotCharts and interactive dashboards. Participants will also explore how AI can support data preparation\, identify patterns\, assist with calculations and improve reporting efficiency. \nThrough hands-on exercises\, this Microsoft Excel with AI Tools programme helps participants transform raw spreadsheet data into clearer and more meaningful business information. The emphasis is on combining practical Excel techniques with AI-assisted workflows that can support faster analysis while maintaining appropriate human review and interpretation. \nBy the end of the Microsoft Excel with AI Tools programme\, participants will have greater confidence in working with larger datasets\, creating visual reports and using Excel more effectively to support data-driven workplace decisions. \nWhat will you learn in this Microsoft Excel: Data Analytics and Visualization With AI Tools?\nThis Microsoft Excel with AI Tools training will help participants develop practical skills in: \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\nWhy Attend This Microsoft Excel with AI Tools Training?\nThis Microsoft Excel with AI Tools programme is designed for professionals who want to move beyond basic spreadsheet use and develop stronger skills in analysing\, organising and presenting workplace data. \nParticipants will learn how to structure information more effectively\, apply Excel functions to solve practical data problems and create clearer visual reports. The programme also introduces AI-assisted techniques that can help support data cleaning\, calculations\, trend identification and repetitive spreadsheet activities. \nRather than using Excel and AI as separate tools\, participants will explore how they can be combined within a practical data-analysis workflow. This approach can help reduce manual effort\, improve reporting efficiency and make business information easier to interpret and communicate. \nWho Should Attend?\nThis Microsoft Excel with AI Tools training is suitable for executives\, analysts\, finance professionals\, administrators\, HR teams\, operations staff and other employees who regularly work with spreadsheets\, reports or business data. \nIt is particularly suitable for participants who already have some familiarity with Microsoft Excel and want to improve their data-analysis\, visualisation and dashboard-building skills while gaining exposure to AI-assisted productivity techniques. \nNo programming or advanced AI knowledge is required. \nCourse Outline\nThe Microsoft Excel with AI Tools course outline progresses from data importing and preparation to advanced functions\, visualisation and interactive dashboard development. \nModule 1: Getting Data Into Microsoft Excel– Import data from multiple platforms into Excel for further analysis– Explore methods for efficient data importing and connecting to external data sources– Integrate AI tools to enhance data retrieval and preprocessing \nModule 2: Data Cleaning and Manipulation– Utilize functions for combining and splitting text to enhance data readability– Clean data\, remove unwanted characters\, and ensure accuracy for better analysis– Leverage AI tools for data cleaning\, such as automatic error detection and correction \nModule 3: Working With Numbers and Dates– Convert data types from text to numbers\, dates to text\, and both numbers and text to dates– Master functions for generating dates\, calculating days between dates\, and more– Use AI tools to automate complex calculations and date manipulations \nModule 4: Defined Names for Better Data Management– Learn how to use cell referencing and naming for improved data organization– Create named ranges and automate processes for enhanced efficiency– Implement AI tools to optimize data organization and structure \nModule 5: Automating Data Manipulation With Tables– Utilize SMART TABLES for creating\, formatting\, and managing data tables– Format\, sort\, and filter data efficiently for improved organization– Apply AI tools to automate data sorting\, analysis\, and reporting \nModule 6: Logical And Lookup Functions– Evaluate data using nested IF functions for advanced logical operations– Perform logical operations with IF\, categorize data using VLOOKUP and XLOOKUP– Master advanced functions such as INDEX and MATCH for precise data matching– Integrate AI for predictive analysis and automated decision-making within Excel \nModule 7: Data Visualization– Visualize data effectively using conditional formatting\, sparklines\, and number formats– Utilize standard charts (line\, pie\, scatter) and specialized charts (hierarchy\, waterfall\, funnel\, etc.) for insightful data representation– Leverage AI tools to generate visualizations and identify trends automatically \nModule 8: Creating Interactive Dashboards– Summarize data dynamically using PivotTables for quick insights– Customize\, group\, sort\, and filter pivot data for interactive dashboards– Create engaging dashboards with pivot charts\, slicers\, and timelines– Integrate AI tools to enhance dashboard interactivity and data presentation \nBy completing this Microsoft Excel with AI Tools programme\, participants will be better prepared to clean and analyse business data\, create clearer visual reports and build interactive dashboards that support more informed workplace decision-making. \nFor more information about our training programmes\, visit Excel Academy Malaysia. 
URL:https://www.excelacademy.my/event/microsoft-excel-with-ai-tools/
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/NOV26_MicrosoftExcelDataAnalytics.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261119T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261119T170000
DTSTAMP:20260915T010427Z
CREATED:20260115T034107Z
LAST-MODIFIED:20260915T010427Z
UID:14378-1795078800-1795107600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level With AI Tools
DESCRIPTION:Download The Course Brochure Link \nMicrosoft Excel Basic Level with AI introduces beginners to the fundamental skills required to use Microsoft Excel effectively. Participants will learn how to manage data\, perform basic calculations\, and create simple visualizations. The course also integrates Excel’s AI-powered tools\, enabling participants to enhance productivity\, generate insights\, and automate repetitive tasks with minimal effort. By the end of this course\, learners will be equipped to handle everyday data tasks with confidence and efficiency. \nWhat Will You Learn in This Microsoft Excel Basic Level with AI?\nThis Microsoft Excel Basic Level with AI training will help participants build practical skills in: \n\nNavigate and customize the Excel interface effectively.\nOrganize and manage data systematically.\nUse formulas and functions to perform basic calculations.\nVisualize data through simple yet impactful charts.\nLeverage AI tools for automation\, insights\, and layout optimization.\nPrepare Excel files for professional printing and sharing.\n\nWhy Attend This Microsoft Excel Basic Level with AI Training?\nMicrosoft Excel Basic Level with AI is designed to help participants become more confident when working with spreadsheets while discovering how AI can support everyday Excel-related tasks. \nThe training provides a practical learning environment where participants can strengthen their understanding of Excel and explore more efficient ways to approach common workplace activities. By combining basic Excel knowledge with AI-assisted techniques\, participants can develop better working habits and improve their overall productivity. \nThis Microsoft Excel Basic Level with AI course is suitable for beginners\, administrative staff\, executives and professionals who regularly work with spreadsheets but want to improve their confidence and efficiency. Participants will also gain a clearer understanding of how AI can complement their existing Excel skills rather than replace them. \nNo advanced Excel or technical AI knowledge is required\, making the program suitable for learners who are still building their spreadsheet skills. \nWho Should Attend?\nMicrosoft Excel Basic Level with AI is suitable for beginners and professionals who want to develop a strong foundation in Excel while learning how AI-assisted features can support everyday spreadsheet tasks. \nThis programme is particularly useful for administrative staff\, executives\, HR professionals\, finance support teams\, sales personnel\, operations staff and employees who regularly work with data\, reports or spreadsheets. \nParticipants do not need previous advanced Excel experience. The Microsoft Excel Basic Level with AI course begins with fundamental skills and gradually introduces practical techniques that can be applied immediately in the workplace. \nCourse Outline\nModule 1: Getting Comfortable With the Excel Workspace\n– Navigate the Excel interface\, including the Ribbon\, Quick Access Toolbar\, and Workbook layout\n– Customize the workspace to improve accessibility and productivity\n– Learn keyboard shortcuts and practical tips for efficient navigation\n– Use the AI-powered Tell Me tool to locate features and execute tasks with natural language\ncommands \nModule 2: Workbook and Worksheet Basics\n– Create\, save\, and organize Excel workbooks in various formats\n– Manage worksheets\, including adding\, renaming\, copying\, and deleting them\n– Explore file formats and their use cases\, such as .xlsx and .csv\n– Utilize the Ideas Tool for AI-driven suggestions to improve workbook organization and structure \nModule 3: Data Entry Essentials\n– Enter text\, numbers\, and dates accurately and efficiently\n– Use AutoFill and AutoComplete to streamline repetitive data tasks\n– Apply the Flash Fill tool to recognize patterns and automate tasks like reformatting data or\nextracting details \nModule 4: Simple Data Formatting\n– Format cells to improve readability\, including applying number formats\, text styles\, and colors\n– Use borders\, shading\, and alignment options to highlight and organize data\n– Get formatting recommendations from the Ideas Tool for enhanced visual clarity \nModule 5: Worksheet Layout and Organization\n– Adjust row heights and column widths to maintain a clean layout\n– Hide and unhide rows or columns to manage data visibility\n– Freeze panes to lock specific rows or columns in view while scrolling\n– Improve layout clarity with AI-driven insights from the Ideas Tool \nModule 6: Basic Formulas and Functions\n– Write simple formulas for addition\, subtraction\, multiplication\, and division\n– Use essential functions such as SUM\, AVERAGE\, MIN\, and MAX to analyze data\n– Leverage the Formula Suggestions tool to receive automated recommendations for applying\nfunctions based on data patterns \nModule 7: Creating Basic Charts for Data Visualization\n– Select and create charts\, including column\, line\, and pie charts\, to represent data visually\n– Customize chart elements such as titles\, legends\, and data labels for clear communication\n– Use the Recommended Charts tool to identify the most suitable chart type for your dataset \nModule 8:  Preparing for Printing and Sharing\n– Configure print settings\, such as setting print areas\, adjusting page layouts\, and adding\nheaders/footers\n– Save files in various formats for easy sharing and collaboration\n– Use the Page Layout Suggestions tool to optimize layouts for professional and error free\nprinting \nFor more information about our training programmes\, visit Excel Academy Malaysia.
URL:https://www.excelacademy.my/event/microsoft-excel-basic-level-with-ai-2/
LOCATION:Excel Academy\, Excel Academy\, VSQ@PJCC Block 6 Level 5\, Jalan Utara\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel,Public training/course
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/NOV26_MicrosoftExcelBasic.png
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:20260928T091623Z
CREATED:20260115T045734Z
LAST-MODIFIED:20260928T091623Z
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/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/DEC26_PowerBI.png
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