Learn · Track 3 · Expert
Expert
Modeling and case work: the long, multi-step tasks some interviews hand you.
- 24
LET and LAMBDA
LET, LAMBDA, MAP, REDUCE, SCAN, BYROW
- 25
Array Thinking
SUMPRODUCT, array constants, legacy Ctrl+Shift+Enter arrays, boolean math
- 26
Modeling Patterns
Assumptions blocks, scenario switches, waterfalls and running totals, dashboards from pivots
- 27
Interview Case Drills
20 to 60 minute multi-step cases (clean, analyze, summarize) with partial-credit scoring
- 28
Combined Skills
Mixed-topic challenges at increasing speed, with randomized variants