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:20260617T111913
CREATED:20260115T030127Z
LAST-MODIFIED:20260521T020506Z
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/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/JUN26_MicrosoftExcelIntermediateAdvanced.png
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:20260617T111913
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
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260714T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260715T170000
DTSTAMP:20260617T111913
CREATED:20260105T081130Z
LAST-MODIFIED:20260410T025029Z
UID:14269-1784019600-1784134800@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-4/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Data Analytics & Visualization In Excel,Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/JUL26_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:20260716T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260716T170000
DTSTAMP:20260617T111913
CREATED:20260115T031015Z
LAST-MODIFIED:20260410T030147Z
UID:14282-1784192400-1784221200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level: Essentials with AI Tools
DESCRIPTION:Download The Course Brochure Link \nThis course introduces beginners to the fundamental skills required to use Microsoft Excel effectively.\nParticipants will learn how to manage data\, perform basic calculations\, and create simple\nvisualizations. The course also integrates Excel’s AI-powered tools\, enabling participants to enhance\nproductivity\, generate insights\, and automate repetitive tasks with minimal effort. By the end of this\ncourse\, 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 Tools?\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\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 \n 
URL:https://www.excelacademy.my/event/hrd-corp-claimable-chatgpt-and-ai-tools-content-creation-and-marketing-14/
LOCATION:Excel Academy\, Excel Academy\, VSQ@PJCC Block 6 Level 5\, Jalan Utara\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/01/JUL26_MicrosoftExcelBasic.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260812T000000
DTEND;TZID=Asia/Kuala_Lumpur:20260813T000000
DTSTAMP:20260617T111913
CREATED:20260525T032036Z
LAST-MODIFIED:20260525T043159Z
UID:14751-1786492800-1786579200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel With AI Tools for HR: Data Management and Reporting
DESCRIPTION:Download The Course Brochure Link \nThis practical two-day programme is designed for HR professionals looking to strengthen their proficiency in Microsoft Excel and AI-powered tools for managing employee data\, generating accurate reports and delivering meaningful workforce insights. Participants will learn to clean\, organise and analyse HR data efficiently\, create professional reports and interactive dashboards\, and apply automation techniques to significantly reduce manual effort. Using HR-relevant scenarios and real-world sample datasets throughout\, the programme ensures skills are immediately applicable to participants’ daily responsibilities — from routine headcount tracking to executive-level workforce analytics. \nWhat Will You Learn in Microsoft Excel with AI Tools for HR: Data Management and Reporting? \n\nStructure and manage HR datasets using Excel tables\, named ranges and data validation for organised\, error-free record-keeping.\nClean and standardise employee data using text functions and AI-assisted tools to ensure accuracy and consistency across HR records.\nApply logical\, lookup and date functions for key HR calculations including tenure\, leave balances and probation tracking.\nGenerate professional HR reports covering headcount\, turnover\, recruitment pipeline and compensation summaries for management review.\nAnalyse workforce data using PivotTables\, conditional formatting and statistical functions to surface actionable workforce trends.\nBuild interactive dashboards with slicers\, timelines and PivotCharts tailored for leadership reporting and strategic decision-making.\nLeverage AI features in Excel to automate repetitive reporting tasks and enhance the depth of data insights.\nApply data security and confidentiality best practices when handling sensitive employee information in compliance with organisational standards.\n\nCourse Outline \nModule 1: Excel Foundations for HR — Navigating Excel with HR workflows in focus — Setting up secure\, structured workbooks for employee data — Best practices for handling confidential HR information \nModule 2: Importing and Preparing HR Data — Importing data from external sources into Excel — Cleaning and standardising employee records using text functions (CONCAT\, TEXTSPLIT\, PROPER\, SUBSTITUTE) — Using AI tools to detect errors and suggest corrections \nModule 3: Essential HR Calculations and Data Organisation — Calculating tenure\, leave entitlements and probation dates using date functions — Applying logical functions (IF\, IFS) and lookup functions (XLOOKUP\, INDEX-MATCH) for employee data retrieval — Structuring data with tables and named ranges for efficient reporting and formula readability \nModule 4: Building Professional HR Reports — Creating standard reports: Headcount\, turnover\, recruitment pipeline and training participation — Formatting reports for clarity and executive presentation — Automating report updates with dynamic ranges and refreshable data connections \nModule 5: Workforce Analytics with PivotTables — Summarising employee data to analyse attrition\, diversity and compensation trends — Grouping and filtering data by department\, tenure or performance level — Using conditional formatting and sparklines to highlight key metrics and thresholds \nModule 6: Interactive Dashboards and Automation — Designing executive-ready dashboards using PivotCharts\, slicers and timelines — Incorporating KPIs and visual elements to communicate HR metrics effectively — Introduction to macros and AI-assisted automation for repetitive reporting tasks — Best practices for sharing and protecting HR dashboards
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-with-ai-tools-for-hr-data-management-and-reporting/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Human Resource,Microsoft Excel,Public training/course
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/05/AUG26_MicrosoftExcelDataAnalytics-1.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260818T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260819T170000
DTSTAMP:20260617T111913
CREATED:20260115T031705Z
LAST-MODIFIED:20260410T035052Z
UID:14304-1787043600-1787158800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate and Advanced Level With AI Tools
DESCRIPTION:Download The Course Brochure Link \n\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-introduction-to-ai-tools-prompt-smarter-for-higher-productivity-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/2026/01/AUG26_MicrosoftExcelIntermediateAdvanced-ezgif.com-png-to-webp-converter-1024x1024-1.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260819T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260820T170000
DTSTAMP:20260617T111913
CREATED:20260115T031950Z
LAST-MODIFIED:20260410T035429Z
UID:14313-1787130000-1787245200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel with AI Tools: Data Analytics and Visualization Tools
DESCRIPTION:Download 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-basic-level-with-ai-tools-5/
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/AUG26_MicrosoftExcelDataAnalytics.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260917T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260917T170000
DTSTAMP:20260617T111913
CREATED:20260115T032025Z
LAST-MODIFIED:20260410T040635Z
UID:14316-1789635600-1789664400@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level With AI Tools
DESCRIPTION:  \nDownload The Course Brochure Link \nThis course introduces beginners to the fundamental skills required to use Microsoft Excel effectively.\nParticipants will learn how to manage data\, perform basic calculations\, and create simple\nvisualizations. The course also integrates Excel’s AI-powered tools\, enabling participants to enhance\nproductivity\, generate insights\, and automate repetitive tasks with minimal effort. By the end of this\ncourse\, 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 Tools?\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\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
URL:https://www.excelacademy.my/event/hrd-corp-claimable-introduction-to-ai-tools-prompt-smarter-for-higher-productivity-8/
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/SEP26_MicrosoftExcelBasic.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261013T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261014T170000
DTSTAMP:20260617T111913
CREATED:20260115T033044Z
LAST-MODIFIED:20260410T075145Z
UID:14347-1791882000-1791997200@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-social-media-marketing-18/
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-1024x1024-1.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261110T090000
DTEND;TZID=Asia/Kuala_Lumpur:20261111T170000
DTSTAMP:20260617T111913
CREATED:20260115T033756Z
LAST-MODIFIED:20260410T080523Z
UID:14366-1794301200-1794416400@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate and Advanced Level: Data Management 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-short-form-video-mastery-mobile-marketing-success-4/
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.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:20260617T111913
CREATED:20260115T034029Z
LAST-MODIFIED:20260410T082142Z
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 \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-introduction-to-ai-tools-prompt-smarter-for-higher-productivity-11/
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:20260617T111913
CREATED:20260115T034107Z
LAST-MODIFIED:20260410T084621Z
UID:14378-1795078800-1795107600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level With AI Tools
DESCRIPTION:Download The Course Brochure Link \nThis course introduces beginners to the fundamental skills required to use Microsoft Excel effectively.\nParticipants will learn how to manage data\, perform basic calculations\, and create simple\nvisualizations. The course also integrates Excel’s AI-powered tools\, enabling participants to enhance\nproductivity\, generate insights\, and automate repetitive tasks with minimal effort. By the end of this\ncourse\, 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 Tools?\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\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
URL:https://www.excelacademy.my/event/hrd-corp-claimable-chatgpt-and-ai-tools-content-creation-and-marketing-16/
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:20260617T111913
CREATED:20260115T045734Z
LAST-MODIFIED:20260526T035233Z
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 \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-introduction-to-ai-tools-prompt-smarter-for-higher-productivity-12/
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:20261215T080000
DTEND;TZID=Asia/Kuala_Lumpur:20261216T170000
DTSTAMP:20260617T111913
CREATED:20260408T071035Z
LAST-MODIFIED:20260409T081512Z
UID:14662-1797321600-1797440400@www.excelacademy.my
SUMMARY:HRD Corp Claimable- Microsoft Excel Intermediate and Advanced Level: Data Management 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-microsoft-excel-intermediate-and-advanced-level-data-management-with-ai-tools/
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_MicrosoftExcelIntermediateAdvanced.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR