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

Clean up messy text

TRIM removes extra spaces. PROPER, UPPER and LOWER fix capitals. SUBSTITUTE swaps one piece of text for another.

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.