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:20260126T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260127T170000
DTSTAMP:20260417T054421
CREATED:20251208T011515Z
LAST-MODIFIED:20251231T012335Z
UID:573-1769418000-1769533200@mlearning.meteor.com.my
SUMMARY:Microsoft Excel (Intermediate)
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 basics 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.    Intermediate recap of essentials and programme objectives \nii.   Nested IF and intermediate 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.    Intermediate brief to Power Query: importing and transforming data \niv.    Intermediate intro to Power Pivot: relationships and calculated columns \nv.    Intermediate briefing of DAX for intermediate calculations\n\n\nDay 2 – Morning\nAdvanced PivotTables & What-If Analysis\n  i.    Intermediate 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.    Intermediate introduction to DAX syntax and core functions \nii.   Using time intelligence for date-based analysis \niii.    Intermediate 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\n FEE 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-intermediate/
END:VEVENT
END:VCALENDAR