Excel field guides
Learn a useful pattern, understand the common mistakes, then practice on a visible sheet. Each guide connects directly to a playable Sumwarden quest.
SUM practice: add a range with confidence
Learn Excel SUM with a worked sales example, range checks, common mistakes, and interactive practice.
IF practice: turn a business rule into a formula
Practice IF, comparisons, and nested logic with realistic stock and payroll examples.
SUMIF and SUMIFS practice for useful reports
Learn criteria ranges, sum ranges, and multi-condition totals through original Excel exercises.
XLOOKUP practice: connect your spreadsheet data
Practice exact-match XLOOKUP, missing-value fallbacks, and left lookups with an original inventory dataset.
VLOOKUP and INDEX/MATCH practice
Understand exact matches, column numbers, and lookup positions before using formulas in a report.
Text cleanup practice for messy Excel imports
Practice TRIM, PROPER, LOWER, LEFT, MID, RIGHT, and SUBSTITUTE on realistic imported text.
Excel interview practice with business reasoning
Prepare for common formula tasks with a focused practice sequence and a five-question skill check.
SUMPRODUCT and weighted report metrics
Learn row-by-row multiplication, stock value, weighted conversion, and acquisition costs with hands-on practice.