Math and statistics

Totals, counts, averages and rounding, then conditional totals with SUMIF, SUMIFS, AVERAGEIFS and MAXIFS.

14 lessons · about 2 h 20 min · Beginner to Advanced

Get the full course The same skill in Google Sheets

Lessons

In the order the Roadmap teaches them.

In the full course. Beginner · 8 min

SUM, AVERAGE, MIN and MAX

Find a column's total, average, smallest and largest value with SUM, AVERAGE, MIN and MAX, and know why an empty cell and a 0 give different averages.

See the lesson

In the full course. Beginner · 7 min

COUNT, COUNTA and COUNTBLANK

Count numbers with COUNT, filled-in cells with COUNTA and empty cells with COUNTBLANK, and pick the right one for the question.

See the lesson

In the full course. Beginner · 10 min

ROUND, ROUNDUP and ROUNDDOWN

Round the stored value, not just the display, so totals match what people see, and round up, down or to the nearest hundred or thousand.

See the lesson

In the full course. Confident · 12 min

SUMIF and COUNTIF

Total and count only the rows that match a condition, and copy the formula down without breaking its ranges.

See the lesson

In the full course. Confident · 11 min

SUMIFS and COUNTIFS with several conditions

Total and count the rows that pass several conditions at once, including a date range, with SUMIFS and COUNTIFS.

See the lesson

In the full course. Confident · 11 min

AVERAGEIF and AVERAGEIFS

Average only the rows that match one condition with AVERAGEIF, or several conditions with AVERAGEIFS, and know why empty cells don't count.

See the lesson

In the full course. Confident · 10 min

MAXIFS and MINIFS

Find the largest or smallest value among the rows that match your conditions, including the latest date, with MAXIFS and MINIFS.

See the lesson

In the full course. Confident · 9 min

Running totals

Show a running total that grows row by row with one SUM formula whose range starts at a locked first row.

See the lesson

In the full course. Confident · 13 min

RANK and top N lists

Rank every row with RANK, understand how ties are ranked, and build a top 5 or bottom 3 list with LARGE, SMALL and a lookup.

See the lesson

In the full course. Confident · 9 min

MEDIAN and MODE

Find the typical value with MEDIAN when a few big numbers distort the average, and the most common value with MODE.

See the lesson

In the full course. Confident · 11 min

Random numbers: RAND and RANDBETWEEN

Pick a random winner or sample with RAND and RANDBETWEEN, keep the result from changing, and make practice data.

See the lesson

In the full course. Advanced · 10 min

Weighted averages with SUMPRODUCT

Work out a weighted average with SUMPRODUCT and SUM, and see when a plain AVERAGE gives the wrong answer.

See the lesson

In the full course. Advanced · 10 min

Percentiles and quartiles

Find where a value stands in a list with PERCENTILE.INC and QUARTILE.INC, and read the median as the 50th percentile.

See the lesson

In the full course. Advanced · 9 min

Totals that ignore hidden rows (SUBTOTAL)

Add up, count and average only the rows a filter leaves showing, with SUBTOTAL and the codes 109, 103 and 101.

See the lesson

Paths with these lessons

A path is a short list of lessons from the course, picked for one goal.

Excel for finance and accounting

For bookkeeping, accounts or finance support work, or accounting study.

11 lessons · about 1 h 55 min · 1 free · Beginner to Advanced

See the path

Excel test prep

For an Excel test or skills check for an office, admin or analyst job.

15 lessons · about 2 h 30 min · 4 free · Beginner to Confident

See the path

Reports that don't break

For a weekly or monthly report other people rely on.

11 lessons · about 1 h 45 min · 2 free · Beginner to Confident

See the path

Excel basics in a weekend

For starting from zero, or only typing numbers into cells today.

14 lessons · about 2 h · 4 free · Beginner to Confident

See the path

Excel for small business

For quotes, stock and money kept in a spreadsheet.

12 lessons · about 2 h 15 min · 3 free · Confident

See the path

Get the full course

Every lesson in the Excel course, with new lessons added as they're written.

All 217 Excel lessons open today, and every new one as it's written.
The Roadmap, Skills and all eight paths.
A cheat sheet for every lesson you finish.
At checkout, add the Google Sheets course for US$49.

US$149

Tax included · Lifetime access

Get the full course

30-day money-back guarantee if you've opened fewer than 10 paid lessons.

No account needed to pay. Payments are handled by Link, Stripe's checkout. Your card statement shows LINK.COM.