Mastering Excel 365 – Advanced (2025)

Topics covered include:

Creating, saving, and using a custom worksheet template
Exploring dynamic array functions
Using the LOOKUP, text, date, and database functions
Using advanced filtering and sorting techniques
Applying and modifying data validation for numbers, text, and date cells
Using the Subtotal function and the Subtotals feature
Using Data Consolidation to summarize data from multiple ranges
Creating, modifying, and filtering a PivotTable
Creating macros and add form controls
Creating custom charts and chart templates
Inserting, formatting, and modifying graphics screenshots, symbols, and 3D models
Running the Accessibility Checker and addressing needed changes
Protecting sheets, workbooks, and ranges