Microsoft Excel 365 (Level 3)
Learn how to create Excel tables, sort and filter data with a range of criteria, summarise and analyse information with PivotTables, and use database and dynamic array functions.
- Delivery
- 6 hours
- Delivery
- Live online · English or French
- Price
- C$399
Per participant. Prices exclude HST and GST.
What you'll walk away with
- Build and maintain structured Excel tables
- Summarise data with PivotTables, PivotCharts and slicers
- Use dynamic array formulas
Course objectives
- Create and use Excel tables
- Add, edit and search for records in tables, and look up data
- Sort records in a table using a variety of methods
- Filter data in a table using a variety of methods
- Create and work with subtotalled lists
- Work with PivotTables, PivotCharts and slicers
Course outline
Unit 1: Maintaining Data
- Data list and Excel table concepts
- Working with tables
- Using lookup tables
- Using data forms
Unit 2: Sorting Lists
- Sorting concepts
- Sorting lists
- Custom sort orders
Unit 3: Filtering Lists
- Filtering concepts
- Using AutoFilter
- Using advanced filters
- Working with filtered data
Unit 4: Summarising Data
- Automatic subtotals
- Working with subtotalled lists
- Using functions to summarise data
Unit 5: Working with PivotTables
- PivotTable concepts
- Creating PivotTables
- Modifying PivotTable layouts
- PivotCharts and slicers
Unit 6: Supplemental — Dynamic Array Formulas
- Dynamic array formula concepts
- Creating unique dynamic lists
- Sorting and filtering dynamic arrays
Related courses
Intermediate · 6 hours
Getting Started with M365 Copilot
Microsoft 365 Copilot helps you generate high-quality content in a fraction of the time. Whether you need to draft an email, a report or a presentation, Copilot can assist with smart suggestions and relevant examples across the apps you already use.
Foundation · 3 hours
Mastering Copilot Chat (Free Version)
A focused programme designed to help individuals leverage the power of Copilot Chat — Microsoft's basic Copilot option — to enhance productivity and streamline daily tasks.
Foundation · 6 hours
Microsoft Excel 365 (Level 1)
New to Excel or need a refresher? This course is designed to help you master the fundamentals of Excel and learn time-saving tips that will allow you to get things done more quickly and efficiently.
Want this course for your team?
I deliver every session personally, 100% live online, in a full day or two half days — in English or French.