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
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.
More in this category
Microsoft Excel
1 day
Microsoft Excel
1 day