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:20261215T080000
DTEND;TZID=Asia/Kuala_Lumpur:20261216T170000
DTSTAMP:20260617T203438
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
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20261217T080000
DTEND;TZID=Asia/Kuala_Lumpur:20261217T170000
DTSTAMP:20260617T203438
CREATED:20260409T020821Z
LAST-MODIFIED:20260409T081036Z
UID:14670-1797494400-1797526800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Introduction to AI Tools: Prompt Smarter for Higher Productivity
DESCRIPTION:Download The Course Brochure Link \nThis one-day interactive program equips participants with the practical skills to harness the power of\nArtificial Intelligence (AI) in their everyday work and personal lives. With a focus on utilizing the most\ncommon AI platforms such as the free version of ChatGPT and other accessible AI tools\, the session is tailored for beginners and casual users who want to move beyond curiosity into confident with hands-\non application. Through live demonstrations\, guided practice and collaborative activities\, participants will gain firsthand experience on how AI can simplify repetitive tasks\, spark creativity and enhance\noverall productivity. By the end of the session\, participants will gain practical skills and confidence to\nintegrate AI into their professional and personal routines — turning AI into a trusted productivity partner. \nWhat will you learn in this Introduction To AI Tools : Prompt Smarter for Higher Productivity?\n\nExplain and apply key AI applications in daily life and professional settings\, while effectively\nleveraging leading platforms such as ChatGPT to improve work efficiency and productivity.\nDifferentiate between blind prompting and prompt engineering and understand the impact of\neach type of prompting.\nConstruct and refine well-structured prompts using proven techniques to generate accurate\,\nrelevant and high-quality responses from AI tools.\nRecognize AI hallucinations and to validate information for reliable decision-making.\n\nCourse Outline\nModule 1: Introduction\n– AI in the modern workplace\n– Why AI matters for productivity \nModule 2: What Is Artificial Intelligence (AI)?\n– Definition of AI\n– Key Features for workplace use\n– AI Chatbot Comparisons (ChatGPT\, Gemini\, Copilot\, etc.) \nModule 3: Getting Started With AI Tools\n– Why we use AI at work\n– Introduction to AI Tool(s) & Features\n– Using AI Effectively\n– Two Types of Prompting \nModule 4: Practice (Workplace Applications):\n– Drafting & replying to emails\n– Content creation for reports\, memos\, proposals\n– Rephrasing for professional tone\n– Summarizing documents & meeting notes\n– Creating visuals for presentations & marketing\n– Uploading & working with documents/photos\n– Using voice command features\n– Basic data analysis for spreadsheets \nModule 5: Prompts for Maximum Efficiency\n– Zero-Shot vs Few-Shot Prompting\n– Role-Based Prompts\n– Structured Prompts (email\, report\, agenda templates)\n– Chain-of-Thought Prompts\n– Refining Search \nModule 6: AI Hallucinations\n– What they are\n– Examples in office settings (false references\, fabricated data)\n– Fact-checking & verification \nModule 7: Ethical AI & Responsible Implementation\n– Understanding AI Ethics\n– Why is responsible AI Important?\n– Key Principles of AI Ethics\n– Ethical dilemmas in AI\n– AI responsible implementation of work \nModule 8: Recap\, Key Takeaways\, & Conclusion\n– Review of key tools & skills\n– How to integrate AI into workflows\n– Next steps for productivity growth
URL:https://www.excelacademy.my/event/hrd-corp-claimable-introduction-to-ai-tools-prompt-smarter-for-higher-productivity-13/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:ChatGPT,Public training/course
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2026/04/DEC2026_IntroductionToAITools.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR