Day 1 · Formulas and data
- Named ranges and structured references
- VLOOKUP, INDEX + MATCH and XLOOKUP
- SUMIFS, COUNTIFS, nested conditions and IFERROR
- Dynamic arrays: FILTER, UNIQUE and SORT
- Text and date functions for data cleanup
- LET and LAMBDA for clearer formulas
- Data validation, dependent lists and formula-based conditional formatting