Data Training from Zomalex

Home | Power BI | Excel | Python | SQL | Visualising Data | Generative AI

Excel Intermediate Course

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

• XLOOKUP – a simpler and more flexible alternative to VLOOKUP.
• Excel tables in detail.
• Summarising data with pivot tables.
• Introduction to spill functions – what they are and why they are very useful.
• Summarising data with formulas and functions such as SUMIFS