Practisheet

Practice

New here?

Get a plan in 60 seconds, then start your first exercise.

Start free →

Projects

Lessons

Sheet basics

Cells, rows and cell addresses

0 of 3 done

Simple formulas

+ − × ÷, cell references, copying a formula down

0 of 9 done

SUM, AVERAGE, COUNT, MIN and MAX

Full plan

Totals, averages, counts, the biggest and smallest value

0 of 7 done

Percentages and fixed references

Full plan

% of total, % change, $ references, ROUND, ROUNDUP, IFERROR

0 of 7 done

IF, AND, OR, IFS

Full plan

Yes/no checks, nested IF, IFS and SWITCH

0 of 8 done

COUNTIF and SUMIF

Full plan

COUNTIF(S), SUMIF(S), AVERAGEIFS, MAXIFS, MINIFS

0 of 11 done

Lookups

Full plan

XLOOKUP, VLOOKUP, INDEX + MATCH, IFNA, not-found values

0 of 8 done

Text extraction

Full plan

LEN, LEFT, RIGHT, MID, FIND, SEARCH

0 of 7 done

Joining text

Full plan

&, CONCAT, TEXTJOIN, UPPER, LOWER, PROPER, SUBSTITUTE

0 of 6 done

Data cleaning

Full plan

TRIM, CLEAN, VALUE, TEXT, IS functions, text dates

0 of 9 done

Dates

Full plan

DATE, YEAR, MONTH, WEEKDAY, EOMONTH, date maths

0 of 7 done

Workdays and date gaps

Full plan

EDATE, DAYS, DATEDIF, NETWORKDAYS, WORKDAY

0 of 6 done

Statistics and ranking

Full plan

MEDIAN, LARGE, SMALL, RANK, PERCENTILE, QUARTILE, STDEV

0 of 8 done

Summary tables

Full plan

Pivot-style tables with SUMIFS and COUNTIFS grids

0 of 10 done

Lookups II

Full plan

Bands, two-way INDEX/MATCH, combined keys, CHOOSE

0 of 7 done

SUMPRODUCT and conditions

Full plan

Weighted averages and multi-condition maths

0 of 6 done

Broken sheets

Full plan

Fix #N/A, #VALUE!, #DIV/0!, #REF! and rule columns

0 of 7 done

Finance and what-if

Full plan

PMT, FV, PV, NPER, NPV, IRR, scenarios

0 of 8 done

Dynamic arrays

Full plan

FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, TAKE

0 of 10 done

Summary tables II

Full plan

Summaries that grow with UNIQUE and E2# references

0 of 6 done

LET

Full plan

Name the steps of a long formula

0 of 4 done