Learning path

Intermediate

Summarize real data without manual work.

Module 1

SUMIFS and COUNTIFS

Lesson, practice file and quiz coming soon.

Module 2

XLOOKUP and VLOOKUP

Lesson, practice file and quiz coming soon.

Module 3

PivotTables

Lesson, practice file and quiz coming soon.

Module 4

Tables and named ranges

Lesson, practice file and quiz coming soon.

Module 5

Data validation

Lesson, practice file and quiz coming soon.