FormulaCamp
Completed
← Full curriculum
Track 5 · Confident User

Advanced Formulas

VLOOKUP, INDEX+MATCH, XLOOKUP, dynamic arrays, FILTER, UNIQUE, LET, and LAMBDA.

7 free lessons

0 of 20 completed · about 6.3 h

Start

20 lessons left until your certificate

Looking Up Data

  1. 1The VLOOKUP FunctionFreelesson15 min
  2. 2VLOOKUP: Range LookupsFreelesson15 min
  3. 3INDEX + MATCHFreelesson15 min
  4. 4Lookup by Row and ColumnFreelesson15 min
  5. 5XLOOKUPFreelesson15 min
  6. 6A Lookup Table on Another SheetFreelesson15 min
  7. 7Practice: LookupsFreepractice20 min

Dynamic Arrays

  1. 8UNIQUE and SORTlesson15 min
  2. 9FILTERlesson15 min
  3. 10SEQUENCE, TEXTSPLIT, TRANSPOSElesson15 min
  4. 11TAKE, DROP, CHOOSECOLS, VSTACKlesson20 min
  5. 12Practice: Dynamic Arrayspractice20 min

Formula Builders

  1. 13ROW, OFFSET, INDIRECTlesson15 min
  2. 14LET, TEXTBEFORE, TEXTAFTERlesson15 min
  3. 15LAMBDA, MAP, REDUCE, BYROWlesson25 min
  4. 16Practice: Advanced Formulaspractice20 min

Modern Functions

  1. 17GROUPBY and PIVOTBYlesson25 min
  2. 18REGEX Functionslesson25 min
  3. 19Formula Performancelesson25 min
  4. 20Practice: Modern Functionspractice30 min