Find out where you stand, then practice what's missing
A free skills test, test prep for specific jobs, and a graded exercise for every function we teach. No signup.
Free Excel skills test
Six real tasks in a live grid, from SUM to FILTER. Get your level and a study plan for the gaps in about 10 minutes.
Test prep by job
| Role | What gets tested |
|---|---|
| Financial analyst | Lookups across tables, Totals by segment, Locked references in models, Growth and margins |
| Accountant | Conditional totals, Lookups with gaps, Month-end dates, Cleaning imported data |
| Administrative assistant | Totals and averages, Simple rules, Counting entries, Combining names |
| Data analyst | Multi-condition summaries, Lookups, Filtering and sorting, Splitting text |
| Operations analyst | Rules and flags, Counts by status, Rate lookups, Tiered pricing |
Practice by function
129 functions, each with live examples and a free graded exercise.
Math functionsABSCEILINGEXPFLOORINTLNLOGLOG10MODMROUNDPIPOWERPRODUCTROUNDROUNDDOWNROUNDUPSIGNSQRTSUMSUMPRODUCTSUMSQTRUNC