Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data
Who should attend
People who have attended the Excel foundation course and want to improve their Excel skills.
Course Length
1 day
Learning Objectives
You will learn how to summarise data using two methods: pivot tables and SUMIFS formulas, and how to look up data flexibly with the XLOOKUP function and the INDEX / MATCH pattern. You will learn about Excel tables.
Pre-requisites
Completion of the Excel foundation course.
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.
- A brief introduction to spill functions, such as UNIQUE, and their uses.