Keentune
Adaptive skill practice — find your level, get sharper.

Excel & Spreadsheets practice

Formulas, functions, and references that actually work
Get genuinely good with spreadsheets — the formulas, functions, and rules that separate a confident user from someone who fights their data. Master the core functions (SUM, AVERAGE, COUNT/COUNTA/COUNTIF, IF, MIN/MAX, ROUND) and know when to reach for VLOOKUP versus INDEX/MATCH; understand relative, absolute ($A$1), and mixed references and exactly how a formula changes when you copy it; and decode every error message (#DIV/0!, #VALUE!, #REF!, #NAME?, #N/A) so you can fix it fast — plus the everyday data moves (sort, filter, PivotTable basics). Grounded in the Microsoft 365 Excel function docs, and the formulas work the same in Google Sheets. Every formula question has a computed, always-correct answer, and each wrong option is a classic spreadsheet mistake. Educational only — portable spreadsheet skills, not tied to one app version.
• Meets you at your level — never too easy, never too hard.
• Adapts every question to how you’re doing.
• Tracks your level over time. Skill practice, not a test.
New here? Read the Excel & Spreadsheets guide
A free 17-minute primer — the mental model, the mistakes beginners make, and what to practise first.
Curriculum
206 concepts across 25 chapters, from foundations through advanced practice — each one a concept the adaptive question bank can teach and test.
A. The workbook and grid model
7
B. Formula fundamentals
8
C. Cell references — relative, absolute, mixed
8
D. Names, constants and readable formulas
6
E. Errors and formula debugging
10
F. Math and aggregation functions
11
G. Logical functions and decision formulas
7
H. Conditional aggregation
8
I. Lookup and reference
12
J. Text functions
9
K. Dates and times
10
L. Number formats and display
8
M. Dynamic arrays and spilling
8
N. Array formulas and matrix work
8
O. Tables and structured references
8
P. Sorting and filtering
8
Q. Data validation
6
R. Conditional formatting
7
S. PivotTables
9
T. Charts and visualisation
8
U. Getting data in and cleaning it
8
V. Power Query (get and transform)
8
W. Financial and statistical modelling
9
X. Workbook hygiene, protection and collaboration
8
Y. Navigation, printing and automation
7
View the full curriculum →
Keentune is not affiliated with or endorsed by the organizations whose documentation informs these maps.
Explore all skills on Keentune
Also on your phone
All exam, test, and product names and trademarks are the property of their respective owners and are used here for identification and reference only. Keentune is independent study practice — not affiliated with, authorized, or endorsed by any of these organizations.
© 2026 SportaApp LLC