Formulas
18 practical Excel lessons, three exercises each. Start anywhere. Nothing is locked, and you keep what you finish.
Add up a column of numbers
Find the middle of a set of numbers
Count numbers, or count anything at all
Do one thing when true, another when false
Count only the rows that meet a condition
Add up only the rows that meet a condition
Count rows that meet several conditions at once
Add up rows that meet several conditions at once
The older lookup you will still meet in real files
Find a row by one value, bring back another
Find the smallest and largest numbers in a range
Control how many decimal places a result keeps
Test whether every condition or any condition is true
Replace formula errors with a useful result
Extract a useful part from a text code
Clean stray spaces and measure text length
Join text and cell values into one result
Find a position, then return the value at that position