Excel functions: find the one you need
Pick a function, or filter by the kind of work you do. Every function has a lesson page and a free practice exercise.
Add up a column or range of numbers
Find the typical value in a set of numbers
Find the highest or lowest value fast
Count how many cells contain numbers
Count rows that meet a condition
Add up only the rows that meet a condition
Count rows that meet several conditions
Add up rows that meet several conditions
Show one result or another based on a test
Choose between three or more outcomes
Combine several tests inside IF
Tidy numbers to a set number of decimals
Find a value in a table by its ID
A modern, flexible replacement for VLOOKUP
Look things up in any direction
Replace errors with something readable
Pull the first characters out of text
Unlock every lesson
Every function has a free lesson. Members get all the lessons, fresh exercises every time and the weekly leaderboard. £7 a month or £49 a year, and you can cancel at any time.