Excel Intermediate
Description
Intermediate Excel course
Learning Objectives
You will learn how to summarise data using two methods: pivot tables and formulas, and how to look up or reconcile data.
Course Content
- Look up data with VLOOKUP, XLOOKUP (a simpler and more flexible alternative to VLOOKUP), and the INDEX/XMATCH pattern.
- Summarise data with pivot tables. Create a pivot table, arrange the layout, sort the items, filter the data with slicers, group data, and present the data in an appealing manner with conditional formatting and formats.
- Summarise data with formulas and functions such as SUMIFS and COUNTIFS, and the new GROUPBY and PIVOTBY functions.
- How to use AI tools, such as Copilot, to help us with our Excel tasks.
- Excel tables: how and when to create them and why they are so useful.