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:20260622T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260623T170000
DTSTAMP:20260417T212342
CREATED:20260115T030127Z
LAST-MODIFIED:20260410T023636Z
UID:14477-1782118800-1782234000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate and Advanced Level With AI Tools
DESCRIPTION:Download The Course Brochure Link \nThis course equips professionals with advanced Excel techniques and introduces AI-powered tools to\noptimize data management\, analysis\, and reporting. Participants will explore Excel’s advanced features\nalongside AI integrations to automate repetitive tasks\, enhance predictive modeling\, and create\ndynamic visualizations with minimal effort. \nWhat will you learn in this Microsoft Excel Intermediate and Advanced Level With AI Tools?\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\nCourse Outline\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
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediate-and-advanced-level-with-ai-tools-7/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2025/12/JUN26_MicrosoftExcelIntermediateAdvanced-ezgif.com-png-to-webp-converter.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260629T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260630T170000
DTSTAMP:20260417T212342
CREATED:20260115T030545Z
LAST-MODIFIED:20260410T024207Z
UID:14266-1782723600-1782838800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Power BI with AI Tools: Data Analysis and Visual Reporting
DESCRIPTION:Download The Course Brochure \nThis course\, Microsoft Power BI with AI Tools: Data Analysis and Visual Reporting is designed to empower\nprofessionals with the skills to harness the full potential of Power BI and its integrated AI capabilities.\nParticipants will learn how to transform raw data into actionable insights\, using AI-driven tools to\nenhance analysis\, automate reporting\, and uncover trends and patterns. From mastering the\nfundamentals of Power BI to leveraging advanced AI models and visuals\, this course provides hands-on\nexperience in building intelligent dashboards and reports that support strategic\, data-driven\ndecisions. \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\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
URL:https://www.excelacademy.my/event/hrd-corp-claimable-digital-marketing-masterclass-35/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel,Microsoft Power Query,Power Query
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/04/Jun26_PowerBI.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR