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
Check what is in a cell: IS functions

Lookups

Find values with VLOOKUP0/5
The modern way: XLOOKUP
INDEX and MATCH
Look across: HLOOKUP
Look up in ranges: prices, tiers, sizes

Text

Join text0/4
Cut text apart
Clean up messy text
Find text: FIND, SEARCH, TEXTBEFORE, TEXTAFTER

Dates

Work with dates0/5
Date maths
Workdays and deadlines

Dynamic arrays

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

Pivot & filters

Sort and filter a list0/5
Your first pivot table
Pivot tables: average, biggest, count

Pro moves

Multiply and add: SUMPRODUCT0/3
Top and bottom: LARGE, SMALL, MEDIAN
Round to steps: CEILING, FLOOR, EVEN

Shortcuts

Fly around the sheet0/6
Select without the mouse
Edit and format with keys

Projects

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

Legal notice Privacy Terms Refunds

Lessons Daily Test

Pivot tables: average, biggest, count

Values don’t have to be a sum. Tap the field in Values to switch to Count, Average, Max or Min.

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.