BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//METEOR Learning - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:METEOR Learning
X-ORIGINAL-URL:https://mlearning.meteor.com.my
X-WR-CALDESC:Events for METEOR Learning
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:20260513T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260514T170000
DTSTAMP:20260604T032341
CREATED:20260413T082702Z
LAST-MODIFIED:20260417T034023Z
UID:3031-1778662800-1778778000@mlearning.meteor.com.my
SUMMARY:Microsoft Excel with AI
DESCRIPTION:OVERVIEW\nStudents will build upon the foundational Microsoft Office Excel 2010/2013/2016/ 2019 / Office 365 knowledge and skills already acquired and learn to create advanced workbooks and worksheets\, including advanced formulas\, tables and data analysing tools. \nLEARNING OUTCOMES\nUpon completion of this program\, participants will be able to: \n\nDemonstrate enhanced self-assurance and authority in leadership roles.\nApply advanced frameworks for strategic and agile decision-making in high-pressure situations.\nImprove their ability to influence\, motivate\, and manage diverse teams effectively.\nCultivate an agile mindset to adapt to change and drive results efficiently.\nFunction as powerful internal and external brand ambassadors\, reinforcing organizational trust and reputation.\n\nCOURSE OUTLINE\nLesson 1: Customizing the Excel Environment\n\nConfigure Excel Options\nCustomize the Ribbon and the Quick Access Toolbar\nEnable Excel Add-Ins\n\nLesson 2: Organizing and Analysing Datasets and Tables\n\nManaging Raw Data\nData Cleaning and Housekeeping\nManual Tables VERSUS Smart Tables\nCreate and Modify Tables\nSorting Data\nFiltering Data\nUse SUBTOTAL and Database Functions\nEnabling / Disabling Smart Tables\n\nLesson 3: Creating Basic to Advanced Formulas\n\nWorking with Cell References\nWorking with Absolute Referencing and Relative Referencing\nWorking with Array Formulas\nWorking with Name Range\n\na) Descriptive Names for Cell References\n\nCreating and Using a Named Range\nCreating Slightly Smarter Named Ranges\nNaming Formulas and Constants\nManaging Named Ranges\nAutomatically Creating Named Ranges\nApplying Names to Existing Formulas\n\nb) Controlling Recalculation\nc) Solving Formula Errors\n\nStep-by-Step Evaluation\nTracing Precedents and Dependents\nError Checking\n\nd) Working with Formulas and Functions\no Creating a Basic Formula\n\nExcel’s Order of Operations (BODMAS)\nCell References\nHow Excel Formats Cells That Contain Cell References\n\no Functions\n\nUsing a Function in a Formula\nUsing Cell References with a Function\nUsing Cell Ranges with a Function\nExcel Compatibility Functions\n\no   Formula Errors\no   Logical Operators\no   Formula Shortcuts\n\nPoint-and-Click Formula Creation\nPoint-and-Click Formula Editing\nThe Formulas Tab.\nUsing the Insert Function Button\n\no Copying Formulas\n\nAbsolute Cell References\nPartially Fixed References\nReferring to Other Worksheets\nReferring to Other Workbooks\n\nLesson 4: Working with Statistical and Database Functions\na) Working with Simple to Advanced Queries With:  \n\nCalculating Sum\, Sumif\, Sumifs functions\nWorking with Average\, Averageif\, Averageifs functions\nCounting with Count\, Countif\, Countifs Functions\nAnalyzing Max\, min\, Large\, Small\, Rank Values\n\nb) Working with Complex Queries With: \n\nDSUM\nDAverage\nDCount\nDMax\nDMin\n\nLesson 5: Manipulating Dates\, Times\, and Text\na) Working with Text Functions\n\nCONCATENATE(): Joining Strings of Text Together\nLEFT()\, MID()\, and RIGHT(): Copying Portions of a Text String ▪ UPPER()\, LOWER()\, and PROPER(): Changing Capitalization\n\nb) Working with Date and Time Functions\n\nTODAY() and NOW(): Inserting the Current Date and Time\nDAY()\, MONTH()\, and YEAR(): More Date Calculations\nWEEKDAY(): Determining the Day of the Week\nDATEDIF(): Calculating the Difference Between Dates\nDAYS360(): Finding Out the Number of Days Between Two Dates\nYEARFRAC(): Calculating the Percentage of a Year Between Two Dates\nWEEKNUM(): Figuring Out in Which Week a Date Falls\n\nLesson 6: Managing Workbooks\n\nArranging Multiple Workbooks\nAdding Hyperlinks\nWorking with Comments\nSaving Workbooks in Different Formats\nSaving a Workbook as a Web Page\nCreating Folders\nE-Mailing a Workbook\n\nLesson 7: Grouping and Outlining Data\n\nBasic Data Grouping\nCreating a Group\nNesting Groups Within Groups\nSummarizing Your Data\nCombining Data from Multiple Tables\nGrouping Timesavers\nAuto Outline\nAutomatic Subtotalling\n\nLesson 8:   Templates\n\nUnderstanding Templates\nCreating a New Workbook from a Template\nDownloading Templates\nCreating Templates\nUnderstanding Custom Templates\nBuilding a Custom Template\nSharing Templates with Others\n\nLesson 9: Reporting Data with pivot Table Tables\n\nPreparing Summary\nFormatting and Perfecting Pivot Tables\nWorking with Other Sources\nCreating Pivot-Charts
URL:https://mlearning.meteor.com.my/event/microsoft-excel-with-ai/
LOCATION:Menara OUM\, Block C\, Kompleks Kelana Centre Point\, Jalan SS7/19\, Kelana Jaya\, Petaling Jaya\, Selangor\, 47301\, Malaysia
CATEGORIES:IT & Office Productivity
ATTACH;FMTTYPE=image/png:https://mlearning.meteor.com.my/wp-content/uploads/2026/04/Microsoft-Excel-With-AI.png
ORGANIZER;CN="METEOR Learning":MAILTO:meteorlearning@meteor.com.my
END:VEVENT
END:VCALENDAR