exceltestpracticeStart free
Practice testsLearnFunctionsShortcutsPricingStart free

Learn · Track 2 · Advanced

Analyst

For people who already use VLOOKUP and want INDEX/MATCH, error handling, dynamic arrays and speed.

8 modules46 lessons planned6 of 8 modules published

34 lessons in 6 of 8 modules, 46 planned. The first two lessons of every module are free: 12 of 34 published lessons. Which path is right for me?

  1. 16

    Lookup Mastery

    Two-way INDEX/MATCH, approximate match bands, MATCH with wildcards, INDIRECT basics

    6 lessons
  2. 17

    PivotTables

    Build, rows, columns and values, summarize by, group dates, percent of total, slicers, refresh

    Coming later
  3. 18

    Errors and Auditing

    IFERROR, IFNA, ISBLANK, ISNUMBER, ISERROR, every error value and its cause, tracing precedents and dependents

    5 lessons
  4. 19

    Dynamic Arrays

    Spill, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, # ranges

    7 lessons
  5. 20

    Statistical

    MEDIAN, MODE, STDEV, RANK, PERCENTILE, LARGE, SMALL, COUNTBLANK, SUMPRODUCT as a counter

    6 lessons
  6. 21

    Financial

    PMT, PV, FV, NPER, RATE, NPV, IRR

    5 lessons
  7. 22

    What-If

    Goal Seek, one- and two-variable data tables

    Coming later
  8. 23

    Speed

    Keyboard-only Excel: Alt key tips, Ctrl+Shift+arrows, F2, F4, F5, F9, Ctrl+T, Ctrl+L, Paste Special

    5 lessons

Modules marked "planned" or "coming later" are not published yet; some need simulator features that are still being built.

Start AnalystNext track: Expert