Excel PracticeAll 37 Excel lessons
Each lesson takes one skill and gives you enough repetition to keep it. Lessons open in order, and every exercise is marked the moment you submit.
- 01 Know your coordinatesCell references →
- 02 Let cells do the workArithmetic →
- 03 Keep a rate in placeAbsolute references →
- 04 Clean up the handoffText functions →
- 05 Make the total countSUM →
- 06 Find a useful baselineAVERAGE →
- 07 Check what is presentCOUNT →
- 08 Make a clear decisionIF →
- 09 Find the signalSUMIF →
- 10 Count a specific groupCOUNTIF →
- 11 Find an answer instantlyXLOOKUP →
- 12 Read an existing lookupVLOOKUP →
- 13 Find the extremesMIN and MAX →
- 14 Round with intentROUND →
- 15 Count past a thresholdCOUNTIF comparison →
- 16 Label a resultIF with text →
- 17 Two conditions at onceSUMIFS →
- 18 Count with two filtersCOUNTIFS →
- 19 Average only some rowsAVERAGEIFS →
- 20 The middle numberMEDIAN →
- 21 Second best, third bestLARGE and SMALL →
- 22 Combined conditionsAND, OR, NOT →
- 23 Fail gracefullyIFERROR →
- 24 Cut text apartLEFT, RIGHT, MID →
- 25 Join text togetherCONCAT →
- 26 Find text in textFIND →
- 27 Fetch by positionINDEX →
- 28 Find the positionMATCH →
- 29 INDEX and MATCH togetherINDEX with MATCH →
- 30 Many conditions, one formulaIFS →
- 31 Map one value to anotherSWITCH →
- 32 Measure the gapABS →
- 33 Find the remainderMOD →
- 34 Squares and rootsPOWER and SQRT →
- 35 Multiply a rangePRODUCT →
- 36 Fix capitalisationPROPER →
- 37 Replace textSUBSTITUTE →