Learn Excel through tasks

Choose a goal. Start with a game, or practise in the worksheet.

What would you like to do?

/

1–12 of 90 tasks

IF · SUMPRODUCT7 min · Growing

Find and flag duplicate values

TRIM · &5 min · Starter

Join text fields without extra spaces

SUMIFS8 min · Growing

Sum amounts that meet several conditions

COUNTIFS7 min · Growing

Count records that meet several conditions

FILTER · UNIQUE9 min · Growing

Count distinct values and show the list

IF6 min · Starter

Calculate percentage change from a positive base

XLOOKUP7 min · Growing

Look up a price by an exact ID

Cell references · +8 min · Growing

Fill formulas across and down with fixed references

TRIM · CLEAN8 min · Growing

Clean spaces and line breaks in imported text

IF · IFERROR7 min · Starter

Convert imported text into numbers

AVERAGEIFS · IFERROR8 min · Growing

Average the records that qualify

SUMPRODUCT · SUM10 min · Growing

Weight a workload by its case counts