Microsoft Excel (Intermediate)
PROGRAMME OUTLINES
| Item | Details |
| Duration | 2 days (9.00 am – 5.00 pm) |
| Delivery Mode | Face-to-face / Online / Hybrid (to be confirmed) |
| Suitable For | Executives, supervisors and managers (All level) |
PROGRAMME OVERVIEW
This 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.
PROGRAMME OBJECTIVES
By the end of this programme, participants will be able to:
- Apply advanced Excel formulas and functions (including nested logic and lookup functions) to solve complex calculation needs.
- Use data tools such as sorting, filtering, data validation and tables to manage and analyse large datasets efficiently.
- Build and customise PivotTables and PivotCharts for interactive data analysis and reporting.
- Use Power Query and Power Pivot basics to import, transform and model data from multiple sources.
- Create clear, visually engaging charts and simple dashboards to communicate key insights effectively and support decision-making.
PROGRAMME OUTLINE AT A GLANCE
| Day / Session | Theme | Key Focus & Activities |
| Day 1 – Morning | Advanced Formulas & Data Tools | i. Intermediate recap of essentials and programme objectives
ii. Nested IF and intermediate logical functions (IF, AND, OR) iii. Lookup functions: VLOOKUP, HLOOKUP, INDEX & MATCH iv. Array formulas (concept and use) v. Sorting and filtering data effectively vi. Data validation and drop-down lists |
| Day 1 – Afternoon | Visualisation, Power Query & Power Pivot | i. Creating dynamic charts and graphs
ii. Conditional formatting, data bars and sparklines iii. Intermediate brief to Power Query: importing and transforming data iv. Intermediate intro to Power Pivot: relationships and calculated columns v. Intermediate briefing of DAX for intermediate calculations |
| Day 2 – Morning | Advanced PivotTables & What-If Analysis | i. Intermediate PivotTables: grouping/ungrouping, calculated fields and items
ii. Using Slicers and Timelines for interactive filtering What-If Analysis: Scenario Manager, Goal Seek and Solver iii. Data tables and sensitivity analysis |
| Day 2 – Afternoon | DAX, Time Intelligence & Power BI Service | i. Intermediate introduction to DAX syntax and core functions
ii. Using time intelligence for date-based analysis iii. Intermediate DAX (FILTER, ALL, iterators) for real business scenarios iv. Publishing to Power BI Service and creating dashboards v. Sharing, collaboration and report performance tips; vi. Final Q&A |
FEE STRUCTURE (INDICATIVE)
| Normal Fee (per pax) | RM 1,899.00 |
| Early Bird | RM 1,699.00 |
| Alumni | RM 1,699.00 |
| Group (min 3 pax) | RM 1,499.00 |
