BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.16.5.1//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:20250212T090000
DTEND;TZID=Asia/Kuala_Lumpur:20250212T170000
DTSTAMP:20250203T072034Z
CREATED:20250127T022543Z
LAST-MODIFIED:20250203T072034Z
UID:13505-1739350800-1739379600@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 Exceleffectively. Participants will learn how to manage data\, perform basic calculations\, andcreate simple visualizations. The course also integrates Excel’s AI-powered tools\, enablingparticipants to enhance productivity\, generate insights\, and automate repetitive tasks withminimal effort. By the end of this course\, learners will be equipped to handle everyday datatasks with confidence and efficiency. \nWhat will you learn in this Microsoft Excel Basic Level?\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\n\nModule 1: Getting Comfortable with The Excel Workspace \n\nNavigate the Excel interface\, including the Ribbon\, Quick Access Toolbar\, and Workbook layout.\nCustomize the workspace to improve accessibility and productivity.\nLearn keyboard shortcuts and practical tips for efficient navigation.\nUse the AI-powered Tell Me tool to locate features and execute tasks with natural language commands.\n\nModule 2: Workbook and Worksheet Basics \n\nCreate\, save\, and organize Excel workbooks in various formats.\nManage worksheets\, including adding\, renaming\, copying\, and  deleting them.\nExplore file formats and their use cases\, such as .xlsx and .csv.\nUtilize the Ideas Tool for AI-driven suggestions to improve workbook organization and structure.\n\nModule 3: Data Entry Essentials \n\nEnter text\, numbers\, and dates accurately and efficiently.\nUse AutoFill and AutoComplete to streamline repetitive data tasks.\nApply the Flash Fill tool to recognize patterns and automate tasks like reformatting data or extracting details.\n\nModule 4: Simple Data Formatting \n\nFormat cells to improve readability\, including applying number formats\, text styles\, and colors.\nUse borders\, shading\, and alignment options to highlight and organize data.\nGet formatting recommendations from the Ideas Tool for enhanced visual clarity.\n\nModule 5: Worksheet Layout and Organizationr \n\nAdjust row heights and column widths to maintain a clean layout.\nHide and unhide rows or columns to manage data visibility.\nFreeze panes to lock specific rows or columns in view while scrolling.\nImprove layout clarity with AI-driven insights from the Ideas Tool.\n\nModule 6: Basic Formulas and Functions \n\nWrite simple formulas for addition\, subtraction\, multiplication\, and division.\nUse essential functions such as SUM\, AVERAGE\, MIN\, and MAX to analyze data.\nLeverage the Formula Suggestions tool to receive automated recommendations forapplying functions based on data patterns.\n\nModule 7: Creating Basic Charts For Data Visualization \n\nSelect and create charts\, including column\, line\, and pie charts\, to represent data visually.\nCustomize chart elements such as titles\, legends\, and data labels for clear communication.\nUse the Recommended Charts tool to identify the most suitable chart type for your dataset.\n\nModule 8: Preparing For Printing and Sharing \n\nConfigure print settings\, such as setting print areas\, adjusting page layouts\, and adding headers/footers.\nSave files in various formats for easy sharing and collaboration.\nUse the Page Layout Suggestions tool to optimize layouts for professional and errorfree printing.
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-basic-level-essentials-with-ai-tools/
LOCATION:Excel Academy\, Excel Academy\, VSQ@PJCC Block 6 Level 5\, Jalan Utara\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2025/01/Feb2025_MicrosoftExcelBasic.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20250225T090000
DTEND;TZID=Asia/Kuala_Lumpur:20250226T170000
DTSTAMP:20250128T031136Z
CREATED:20250128T030242Z
LAST-MODIFIED:20250128T031136Z
UID:13529-1740474000-1740589200@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 willexplore 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\, anddatabase 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/
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/01/Feb2025_MicrosoftExcelIntermediateAdvanced.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR