Excel, made clear.

Pick a task. See it work. Try it yourself.

Try a lesson Free to explore · No sign-up

A small task. A skill to keep.

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

Start small.

Three connected lessons to get comfortable.

Keep a reference fixed Add the right rows Count matching records