Spreadsheet skills spreadsheet templates

Worked examples for learning spreadsheet formulas with a file open. Each workbook keeps its fictional source records beside the formulas, so you can change an input and trace what changes. Start with conditional totals, exact lookups, text cleanup, or date arithmetic.

The examples use familiar functions, explicit units, and bounded ranges. Their Notes tabs explain the method and edge cases, including duplicate lookup keys and a zero denominator.