BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.16.4//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Academy Malaysia - HRD Corp Approved Training Provider
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:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20250923T090000
DTEND;TZID=Asia/Kuala_Lumpur:20250924T170000
DTSTAMP:20260619T082443
CREATED:20250425T013153Z
LAST-MODIFIED:20250825T074538Z
UID:13851-1758618000-1758733200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel With AI Tools: Data Analytics and Visualization
DESCRIPTION:Download the Course Brochure Link \nThis course is designed to enhance participants’ skills in using Microsoft Excel and AI tools for advanced data analytics and visualization. Participants will explore the powerful data manipulation\, analysis\, and visualization features of Excel\, while also integrating AI tools to streamline tasks and uncover deeper insights. The course will provide hands-on experience in cleaning\, analyzing\, and presenting data in meaningful ways\, equipping participants with the tools necessary for smarter\, data-driven decision-making. \nWhat will you learn in this Microsoft Excel with AI Tools: Data Analytics and Visualization\n– Import and manage data from various sources into Excel for seamless analysis.\n– Clean and manipulate data effectively using Excel’s built-in functions and AI-enhanced features.\n– Apply advanced Excel functions for logical analysis\, data matching\, and categorization.\n– Utilize AI-powered features\, such as predictive modeling and automated insights\, within Excel.\n– Visualize data effectively using Excel’s tools\, including charts\, conditional formatting\, and sparklines.\n– Create dynamic\, interactive dashboards using PivotTables\, PivotCharts\, and slicers for enhanced data exploration and storytelling.\n– Automate repetitive tasks and streamline analysis using Excel’s macros and AI-enhanced automation tools. \nCourse Outline\nModule 1: Getting Data Into Microsoft Excel \n– Import data from multiple platforms into Excel for further analysis\n– Explore methods for efficient data importing and connecting to external data sources\n– Integrate AI tools to enhance data retrieval and preprocessing \nModule 2: Data Cleaning and Manipulation \n– Utilize functions for combining and splitting text to enhance data readability\n– Clean data\, remove unwanted characters\, and ensure accuracy for better analysis\n– Leverage AI tools for data cleaning\, such as automatic error detection and correction \nModule 3: Working with Numbers and Dates \n– Convert data types from text to numbers\, dates to text\, and both numbers and text to dates\n– Master functions for generating dates\, calculating days between dates\, and more\n– Use AI tools to automate complex calculations and date manipulations \nModule 4: Defined Names For Better Data Management \n– Learn how to use cell referencing and naming for improved data organization\n– Create named ranges and automate processes for enhanced efficiency\n– Implement AI tools to optimize data organization and structure \nModule 5: Automating Data Manipulation with Tables \n– Utilize SMART TABLES for creating\, formatting\, and managing data tables\n– Format\, sort\, and filter data efficiently for improved organization\n– Apply AI tools to automate data sorting\, analysis\, and reporting \nModule 6: Logical and Lookup Functions \n– Evaluate data using nested IF functions for advanced logical operations\nPerform logical operations with IF\, categorize data using VLOOKUP and XLOOKUP\n– Master advanced functions such as INDEX and MATCH for precise data matching\n– Integrate AI for predictive analysis and automated decision-making within Excel \nModule 7: Data Visualization \n– Visualize data effectively using conditional formatting\, sparklines\, and number formats\n– Utilize standard charts (line\, pie\, scatter) and specialized charts (hierarchy\, waterfall\, funnel\, etc.) for insightful data representation\n– Leverage AI tools to generate visualizations and identify trends automatically \nModule 8: Creating Interactive Dashboards \n– Summarize data dynamically using PivotTables for quick insights\n– Customize\, group\, sort\, and filter pivot data for interactive dashboards\n– Create engaging dashboards with pivot charts\, slicers\, and timelines\n– Integrate AI tools to enhance dashboard interactivity and data presentation
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-with-ai-tools-data-analytics-and-visualization-4/
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/04/Sep2025_MicrosoftExcelDataAnalytics.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20250923T090000
DTEND;TZID=Asia/Kuala_Lumpur:20250924T170000
DTSTAMP:20260619T082443
CREATED:20250425T013615Z
LAST-MODIFIED:20250909T015616Z
UID:13856-1758618000-1758733200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Digital Marketing Masterclass
DESCRIPTION:Download the Course Brochure Link \nThe Digital Marketing Masterclass equips participants with the skills to craft impactful campaigns\, optimize websites\, and leverage AI tools for improved online presence and conversions. This hands-on program covers key digital marketing strategies\, including social media\, email marketing\, SEO\, and content creation\, tailored for B2C and B2B industries. Through real-world case studies and practical exercises\, participants will gain actionable insights to drive measurable results in today’s dynamic digital landscape. \nWhat will you learn in this Digital Marketing Masterclass\n– Understand the core principles of digital marketing and its relevance in the modern business ecosystem.\n– Develop\, manage\, and optimize impactful campaigns across Facebook\, Instagram\, and other social media platforms.\n– Craft high-performing email marketing strategies to increase engagement and conversions.\n– Build effective landing pages and websites that enhance user experience and drive conversions.\n– Leverage content marketing to establish authority and foster community growth.\n– Apply SEO best practices to boost website rankings and organic visibility.\n– Incorporate AI tools to streamline campaign management\, content creation\, and analytics.\n– Conduct competitor and demand analysis to refine marketing strategies. \nCourse Outline\nModule 1: Principles of Digital Marketing \n– Overview of an effective digital marketing strategy with AI Overview.\n– Key pillars: content\, social\, email\, SEO\, and analytics.\n– Customer online behavioral journey and consumer trends.\n– Competitor research and demand analysis tools.\n– Incorporating AI for your marketing strategies. \nModule 2: Social Media Marketing (Facebook & Instagram) \n– Structuring campaigns for optimal performance.\n– Targeting audiences\, allocating budgets\, placement and creative enhancement to maximize ROI.\n– Monitoring and measuring your campaign\, A/B test and understand metrics to improve your existing campaign.\n– Leveraging AI to improve campaign performance \nModule 3: Email Marketing Essentials with AI \n– Crafting impactful email content for lead nurturing and retention\n– Segmentation and personalization strategies to boost open and click through-rates\n– Analyzing campaign performance for continuous improvement \nModule 4: Landing Page and Website Optimization \n– Principles and structures of high-converting landing pages\n– Differences between websites and landing pages\, and when to use each\n– How to identify website content and structural gap\, to improve customer journey and conversions \nModule 5: Content Marketing Strategies with AI \n– How to use AI for content marketing and brainstorming\n– Leveraging different AI tools for text\, video & images\n– Researching\, ideating\, and planning content calendars\n– Measuring content effectiveness and adjusting for improved reach and engagement \nModule 6: Search Engine Optimization (SEO) \n– Understanding SEO pillars: technical\, on-page\, and off-page\n– Keyword research for organic search improvement\n– Using AI to Improve SEO content\n– Conducting audits and applying free tools to enhance web performance\n– Best practices to rank on the first page of Google\n– How to measure your SEO performance with tools with AI
URL:https://www.excelacademy.my/event/hrd-corp-claimable-digital-marketing-masterclass-25/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2025/04/Sep2025_DMM.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20250926T090000
DTEND;TZID=Asia/Kuala_Lumpur:20250926T170000
DTSTAMP:20260619T082443
CREATED:20250425T012623Z
LAST-MODIFIED:20250825T074117Z
UID:13848-1758877200-1758906000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - ChatGPT and AI Tools: Content Creation and Marketing
DESCRIPTION:Download the Course Brochure Link \nThis training empowers participants to harness the potential of ChatGPT\, Gemini\, Co-Pilot and other AI tools for effective content creation and digital marketing. It provides a comprehensive understanding of leveraging AI to brainstorm ideas\, create impactful campaigns\, optimize performance\, and boost productivity. With a focus on real-world applications\, participants will explore case studies\, master AI-powered strategies\, and learn how to seamlessly integrate these tools into their marketing workflows to achieve measurable results. \nWhat will you learn in this ChatGPT and AI Tools : Content Creation and Marketing\n– Gain insights into AI trends and their impact on content marketing strategies\n– Learn to use AI Tools for brainstorming\, content ideation\, and creation\n– Enhance productivity with AI-powered tools for social media\, analytics\, and copywriting\n– Understand how to optimize campaigns with AI insights and troubleshoot for better performance\n– Explore the practical application of AI tools to improve creativity and efficiency in digital marketing campaigns. \nCourse Outline\nModule 1: Digital Trends and AI Overview \n– Explore the pillars of digital marketing and AI integration\n– Analyze Malaysia’s 2024 digital trends and market demand\n– use industry tools for research and data-driven decision-making \nModule 2: AI in Content Marketing \n– Leverage AI for content ideation\, planning\, and creation\n– Craft engaging marketing content using AI-generated insights\n– Prompt structure and format for writing and scripting \nModule 3: AI in Analytics and Website Optimization \n– Utilize Google Analytics 4 and Search Console for performance tracking\n– Optimize SEO with AI-suggested keywords\, title & description\n– How to use AI to analyze\, plan and improve your website traffic \nModule 4: AI in Social Media Marketing \n– Use AI-powered tools like Meta Advantage+ to improve campaigns\n– Learn strategies for setting up\, monitoring\, and optimizing social campaigns\n– Troubleshoot and enhance campaign performance using AI insights \nModule 5: Productivity and Creativity with AI \n– Explore AI tools for voice cloning\, avatar creation\, and proposal writing\n– Evaluate the strengths and limitation of various AI tools for marketing\n– Using AI to enhance images and design for your marketing campaign
URL:https://www.excelacademy.my/event/hrd-corp-claimable-chatgpt-and-ai-tools-content-creation-and-marketing-8/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:ChatGPT
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2025/04/Sep2025_ChatGPTAITools.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20250929T090000
DTEND;TZID=Asia/Kuala_Lumpur:20250930T170000
DTSTAMP:20260619T082443
CREATED:20250424T090243Z
LAST-MODIFIED:20250825T073510Z
UID:13845-1759136400-1759251600@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 optimize data management\, analysis\, and reporting. Participants will explore Excel’s advanced features alongside AI integrations to automate repetitive tasks\, enhance predictive modeling\, and create dynamic visualizations with minimal effort. \nWhat will you learn in this Microsoft Excel Intermediate and Advanced Level: Data Management with AI Tools\n– Efficiently manage and organize large datasets using complex sorting\, filtering\, and database functions.\n– Automate error-checking and validation tasks using AI-enhanced features.\n– Create visually compelling reports and dashboards using AI-assisted design recommendations.\n– Leverage AI tools to identify patterns and trends in large datasets.\n– Streamline repetitive tasks by combining Excel macros with AI-powered workflows.\n– Enhance decision-making with predictive modeling and AI-driven scenario analysis.\n– Build dynamic PivotTables and PivotCharts enriched with AI insights for data storytelling. \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– Understanding Search Engine Rankings and Keyword Research\n– Technical\, On-Page\, and Off-page SEO Methods\n– Using Free and AI-driven SEO Tools for Optimization and rankings \nModule 5: Advanced Data Analysis With DAX And AI \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 6: 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 7: Securing Data With Worksheet Protection \n– Protecting Worksheets and Workbooks with Passwords\n– Allowing Selective Editing\n– Managing Permissions for Workbook Sharing \nModule 8: 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 9: Importing and Exporting Data \n– Importing External Data\n– Exporting Data for Use in Other Applications\n– AI-Based Data Cleaning and Formatting \nModule 10: Using Advanced Functions For Analysis \n– Logical Functions (IF\, AND\, OR)\n– Lookup Functions (VLOOKUP\, HLOOKUP\, INDEX\, MATCH)\n– Statistical Functions (COUNTIF\, RANK) \nModule 11: Pivottables and Pivotcharts \n– Constructing and Formatting PivotTables\n– Grouping Data\, Adding Filters\, and Using Slicers\n– AI-Powered Data Insights for PivotTables \nModule 12: 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 13: Collaborative Workbook Tracking \n– Tracking Changes and Reviewing History\n– Comparing and Merging Workbooks\n– AI-powered Version Management \nModule 14: 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 15: 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-data-management-with-ai-tools-6/
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/04/Sep2025_MicrosoftExcelIntermediateAdvanced.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR