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
Test several conditions without nesting
Combine text from several cells
Remove stray spaces and hidden characters
Work out time between two dates
Calculate a loan or lease payment
Value future cash flows today
Pull out only the rows you need
List each value once
Name values inside a formula