Basics

Cells, rows and columns0/5
Your first formulas0/5
Add things up with SUM0/4
Copy a formula down0/4
Average, lowest, highest0/5
Count cells0/4
Round numbers0/4
Percentages0/4
Fixed references with $0/4

Conditions

Add with a condition: SUMIF0/5
Count with a condition: COUNTIF
Average with a condition
Several conditions, comparisons, wildcards

Logic

Make decisions with IF0/5
Combine tests: AND, OR, NOT
More than two answers: IFS
Pick from a list: SWITCH and CHOOSE
Fix broken formulas
Catch errors with IFERROR

Lookups

Find values with VLOOKUP0/5
The modern way: XLOOKUP
INDEX and MATCH

Text

Join text0/4
Cut text apart
Clean up messy text

Dates

Work with dates0/5
Date maths
Workdays and deadlines

Dynamic arrays

Lists that build themselves: UNIQUE and SORT0/5
Pick rows with FILTER

Pro moves

Multiply and add: SUMPRODUCT0/3
Top and bottom: LARGE, SMALL, MEDIAN

Projects

Project: a monthly budget0/5
Project: a sales report
Project: clean up a customer list

Legal notice Privacy Terms Refunds

Lessons Daily Test

The modern way: XLOOKUP

XLOOKUP(what, where to look, what to return) works in any direction and can say what to show when nothing matches.

5 exercises in this lesson are part of ExcelHero Pro.

See Pro Back to the free lessons

© ExcelHeroExcel functions explained The Excel test Pro Legal notice Privacy Terms RefundsNot affiliated with Microsoft. Excel is a trademark of Microsoft Corporation.