Microsoft Excel (Advanced)
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 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.
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. Recap of essentials and programme objectives
ii. Nested IF and advanced 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. Introduction to Power Query: importing and transforming data iv. Introduction to Power Pivot: relationships and calculated columns v. Basics of DAX for advanced calculations |
| Day 2 – Morning | Advanced PivotTables & What-If Analysis | i. Advanced 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. Introduction to DAX syntax and core functions
ii. Using time intelligence for date-based analysis iii. Advanced 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 |
