Templates

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.

TemplateSpreadsheet skills

AVERAGEIFS conditional mean worked example

Learn conditional averaging by computing unit price per order and using AVERAGEIFS to average order amounts for one selected category.

2 tabs · 187 formulas

TemplateSpreadsheet skills

Budget variance formula worked example

Learn amount and percentage variance formulas for an expense budget, with explicit treatment of a zero budget.

2 tabs · 186 formulas

TemplateSpreadsheet skills

Date and deadline formula example

Learn calendar-date subtraction and completion-aware overdue formulas using a fixed review date.

2 tabs · 186 formulas

TemplateSpreadsheet skills

INDEX MATCH price lookup example

Learn exact-match lookup by retrieving a price from a small product table using a selected SKU.

2 tabs · 127 formulas

TemplateSpreadsheet skills

Min-max normalization formula example

Learn how to clamp raw observations between lower and upper bounds and normalize them onto a zero-to-one hundred percent scale.

2 tabs · 247 formulas

TemplateSpreadsheet skills

SUMIFS sales summary worked example

Learn conditional summation by calculating order amounts and a sales total for one selected region.

2 tabs · 127 formulas

TemplateSpreadsheet skills

Text cleanup formula worked example

Learn TRIM, UPPER, LOWER, and LEN by preparing names and reference codes while preserving the original text.

2 tabs · 306 formulas

TemplateSpreadsheet skills

VLOOKUP exact-match worked example

Learn exact VLOOKUP by retrieving a department allowance from a keyed table with missing and duplicate-key checks.

2 tabs · 127 formulas

TemplateSpreadsheet skills

Weighted average formula example

Learn weighted averages by calculating each observation’s value times its weight and dividing the total by total weight.

2 tabs · 127 formulas