Microsoft Excel Advanced

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme moves professionals with intermediate Excel skills, particularly in finance, operations, admin, HR and sales, on to advanced formulas, analysis and dashboard reporting for large or complex datasets.

Sessions use guided demonstrations, practical exercises and real business scenarios. Participants work with array formulas, advanced data validation, PivotTables, Power Pivot data models and charts with secondary axes. Later modules cover workbook security and sharing, what-if analysis with Goal Seek and Scenario Manager, Power Query basics and how to keep large files fast and easy to audit.

Afterwards, participants can build advanced formulas, manage complex datasets and design professional dashboards for business reporting.

Module topics

  • Complex formulas and dynamic arrays
  • Advanced data management
  • PivotTables, PivotCharts and Power Pivot
  • Advanced charts and interactive dashboards
  • Workbook security and collaboration
  • What-if analysis and scenario planning
  • Power Query fundamentals
  • Optimisation and best practices

Who runs this programme

Shalina Hj Mohd Salleh

Power BI, Excel, Google Workspace and AI tools trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry