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:20260121T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260122T170000
DTSTAMP:20260417T061403
CREATED:20251208T011514Z
LAST-MODIFIED:20251231T012247Z
UID:572-1768986000-1769101200@mlearning.meteor.com.my
SUMMARY:Microsoft Excel (Advanced)
DESCRIPTION:PROGRAMME OUTLINES \n\n\n\nItem\nDetails\n\n\nDuration\n2 days (9.00 am – 5.00 pm)\n\n\nDelivery Mode\nFace-to-face / Online / Hybrid (to be confirmed)\n\n\nSuitable For\nExecutives\, supervisors and managers (All level)\n\n\n\nPROGRAMME OVERVIEW \nThis 2-day\, hands-on programme is designed for users who already know the intermediate knowledge of Microsoft Excel and want to move to the next level. Participants will learn how to use advanced formulas and functions\, manage and analyse data efficiently\, build powerful PivotTables\, and design clear\, professional charts and dashboards that support better reporting and decision-making. \nPROGRAMME OBJECTIVES \nBy the end of this programme\, participants will be able to: \n\nApply advanced Excel formulas and functions (including nested logic and lookup functions) to solve complex calculation needs.\nUse data tools such as sorting\, filtering\, data validation and tables to manage and analyse large datasets efficiently.\nBuild and customise PivotTables and PivotCharts for interactive data analysis and reporting.\nUse Power Query and Power Pivot basics to import\, transform and model data from multiple sources.\nCreate clear\, visually engaging charts and simple dashboards to communicate key insights effectively and support decision-making.\n\n  \n\nPROGRAMME OUTLINE AT A GLANCE \n\n\n\nDay / Session\nTheme\nKey Focus & Activities\n\n\nDay 1 – Morning\nAdvanced Formulas & Data Tools\n  i.    Recap of essentials and programme objectives \nii.   Nested IF and advanced logical functions (IF\, AND\, OR) \niii.    Lookup functions: VLOOKUP\, HLOOKUP\, INDEX & MATCH \niv.    Array formulas (concept and use) \nv.    Sorting and filtering data effectively \nvi.    Data validation and drop-down lists\n\n\nDay 1 – Afternoon\nVisualisation\, Power Query & Power Pivot\n  i.    Creating dynamic charts and graphs \nii.   Conditional formatting\, data bars and sparklines \niii.    Introduction to Power Query: importing and transforming data \niv.    Introduction to Power Pivot: relationships and calculated columns \nv.    Basics of DAX for advanced calculations\n\n\nDay 2 – Morning\nAdvanced PivotTables & What-If Analysis\n  i.    Advanced PivotTables: grouping/ungrouping\, calculated fields and items \nii.   Using Slicers and Timelines for interactive filtering What-If Analysis: Scenario Manager\, Goal Seek and Solver \niii.    Data tables and sensitivity analysis\n\n\nDay 2 – Afternoon\nDAX\, Time Intelligence & Power BI Service\n  i.    Introduction to DAX syntax and core functions \nii.   Using time intelligence for date-based analysis \niii.    Advanced DAX (FILTER\, ALL\, iterators) for real business scenarios \niv.    Publishing to Power BI Service and creating dashboards \nv.    Sharing\, collaboration and report performance tips; \nvi.    Final Q&A\n\n\n\nFEE STRUCTURE (INDICATIVE) \n\n\n\nNormal Fee (per pax)\nRM 1\,899.00\n\n\nEarly Bird\nRM 1\,699.00\n\n\nAlumni\nRM 1\,699.00\n\n\nGroup (min 3 pax)\nRM 1\,499.00
URL:https://mlearning.meteor.com.my/event/microsoft-excel-advanced/
END:VEVENT
END:VCALENDAR