Microsoft Excel 365 – Level Three is an advanced course for experienced Excel users who want to leverage the full power of Microsoft Excel 365. The course covers Excel 365’s modern dynamic array functions, data transformation with Power Query, data modelling with Power Pivot and DAX, dashboard building, and automating repetitive tasks with macros and basic VBA, preparing participants to work at an expert level in Excel.
What You Will Learn
- Use Excel 365 dynamic array functions including FILTER, SORT, UNIQUE, XLOOKUP, and SEQUENCE
- Transform and clean data from multiple sources using the Power Query editor
- Build multi-table data models using Power Pivot with DAX measures and relationships
- Create advanced dashboards using slicers, PivotCharts, and dynamic array-powered reports
- Record and edit macros and write basic VBA code to automate Excel workflows
Who Should Attend
Experienced Excel users who work with large datasets and complex reporting requirements and want to master Excel 365’s most advanced capabilities.
Prerequisites
Solid intermediate Excel experience covering formulas, PivotTables, and basic data analysis features.
