Formulas
Read the pattern, then prove it on a locked Mini sheet.
-
XLOOKUP
Syntax, VLOOKUP comparison, errors, and exact-match practice.
-
VLOOKUP
Syntax, approximate vs exact match, 4 critical gotchas, and practice.
-
IF statement
Nested IF letter grades, IFS alternative, and practice links.
-
IFERROR
Catch #N/A and #DIV/0!, IFNA vs ISNA, with graded practice.
-
SUMIF
Conditional sums, wildcards, the SUMIFS order trap, and practice.
-
COUNTIF
Single-condition counts, COUNTIFS contrast, counting text cells, and practice.
-
LEN
Count characters with LEN, including spaces and dashes, plus graded practice.
-
MID
Extract a middle segment with the Excel MID function, plus graded practice.
-
WEEKDAY
TEXT and WEEKDAY for day-of-week labels, TODAY for today’s date, DATEDIF for age — with graded practice.
-
ROUND
ROUND for standard rounding, ROUNDUP to round away from zero, ROUNDDOWN toward zero — with graded practice.
-
Arithmetic
Multiply with * or PRODUCT, divide with /, plus AVERAGE, MEDIAN, STDEV, and ABS — with graded practice.