Training
Skill tree
The functions that win Excel esports, by complexity. Take a tier’s test-out to master every function in it at once — no grinding node by node.
⚠ Placeholder: the tier tests are quick multiple-choice for now. Real hands-on Excel-based tests (solve in your sheet, auto-graded) are coming.
L1 · Foundations0/6
Cell refs, arithmetic, the core aggregates and a first IF.
○Cell & range refs
○SUM / AVERAGE
○COUNT / COUNTA
○MIN / MAX
○ROUND family
○IF
L2 · Lookups & Logic0/6
The bread and butter: lookups, conditional aggregation, boolean logic.
○VLOOKUP / HLOOKUP
○XLOOKUP
○INDEX / MATCH
○IFS / nested IF
○SUMIFS / COUNTIFS
○AND / OR / NOT
L3 · Text & Dates0/6
Parsing strings and wrangling dates — where many cases hide their tricks.
○LEFT / RIGHT / MID
○FIND / SEARCH
○TEXTJOIN / CONCAT
○SUBSTITUTE / REPLACE
○TEXT / VALUE
○DATE / EOMONTH / WEEKDAY
L4 · Arrays & Power0/7
Dynamic arrays, SUMPRODUCT, LET/LAMBDA, Power Query, VBA — the top end.
○FILTER / SORT / UNIQUE
○SEQUENCE / ARRAY math
○SUMPRODUCT
○LET / LAMBDA
○OFFSET / INDIRECT
○Power Query
○VBA
Time Attack
Practice solo and race the ghost — the best recorded run, level by level.