From your first formula to lookups and pivots

1. Warm-up

   Keyboard shortcuts

   Move, select, format and copy without the mouse. Every shortcut is checked as you press it.

   0%

   • Intro to shortcuts
   • Arrow keys
   • Cell selection
   • Larger selections
   • Row and column selection
   • Text formatting
   • Number formatting
   • Cut, copy, paste
   • Data shortcuts

   Start shortcuts Cheat sheet
2. 1
   Unit 1 · You are here

   First formulas

   Add up, average and find the biggest and smallest values.

   0%

   • SUM0/14
   • AVERAGE0/15
   • MIN soon
   • MAX soon
   • ROUND soon

   Start unit Skill summary
3. 2
   Unit 2

   Counting

   Count numbers, filled cells and cells that match a rule.

   0%

   • COUNT soon
   • COUNTA soon
   • COUNTBLANK soon
   • COUNTIF0/15
   • COUNTIFS soon

   Start unit Skill summary
4. 3
   Unit 3

   TRUE, FALSE and IF

   Make decisions in a formula and combine conditions.

   0%

   • IF0/15
   • AND soon
   • OR soon
   • XOR soon
   • NOT soon
   • IFS soon
   • SWITCH soon
   • IFERROR soon

   Start unit Skill summary
5. 4
   Unit 4

   IS functions

   Check what is in a cell before you use it.

   Coming soon

   • ISNUMBER soon
   • ISTEXT soon
   • ISBLANK soon
   • ISERROR soon

   Exercises for this unit are being written. Explore the functions above in the meantime.
6. 5
   Unit 5

   Conditional totals

   Total and average only the rows that match, wildcards included.

   Coming soon

   • SUMIF soon
   • SUMIFS soon
   • AVERAGEIF soon
   • AVERAGEIFS soon
   • MAXIFS soon
   • MINIFS soon

   Exercises for this unit are being written. Explore the functions above in the meantime.
7. Hands-on tool

   Conditional formatting

   Make the important numbers stand out: colour cells by rule, add data bars and highlight whole rows.

   0/5

   Start lesson Try it in the playground
8. 6
   Unit 6

   Lookups

   Find a value in a table: the classic way and the modern way.

   0%

   • VLOOKUP soon
   • HLOOKUP soon
   • XLOOKUP0/10

   Start unit Skill summary
9. 7
   Unit 7

   INDEX and MATCH

   The flexible lookup pair that works in every version of Excel.

   Coming soon

   • MATCH soon
   • INDEX soon
   • XMATCH soon

   Exercises for this unit are being written. Explore the functions above in the meantime.
10. 8
    Unit 8

    Working with text

    Cut, search, clean up and join text.

    Coming soon

    • LEN soon
    • LEFT soon
    • RIGHT soon
    • MID soon
    • FIND soon
    • SEARCH soon
    • UPPER soon
    • LOWER soon
    • PROPER soon
    • TRIM soon
    • SUBSTITUTE soon
    • CONCAT soon
    • TEXTJOIN soon

    Exercises for this unit are being written. Explore the functions above in the meantime.
11. 9
    Unit 9

    Statistics and rounding

    Middle values, most common values, top-N and rounding rules.

    Coming soon

    • MEDIAN soon
    • MODE.SNGL soon
    • LARGE soon
    • SMALL soon
    • RANK.EQ soon
    • FLOOR.MATH soon
    • CEILING.MATH soon
    • ODD soon
    • EVEN soon

    Exercises for this unit are being written. Explore the functions above in the meantime.
12. 10
    Unit 10

    Dates

    Build dates, measure the time between them and find month ends.

    Coming soon

    • DATE soon
    • YEAR soon
    • MONTH soon
    • DAY soon
    • DAYS soon
    • DATEDIF soon
    • NETWORKDAYS soon
    • EOMONTH soon
    • EDATE soon

    Exercises for this unit are being written. Explore the functions above in the meantime.
13. 11
    Unit 11

    Dynamic arrays

    Formulas that return whole lists: unique values, filters and sorting.

    Coming soon

    • UNIQUE soon
    • FILTER soon
    • SORT soon
    • SORTBY soon
    • SEQUENCE soon

    Exercises for this unit are being written. Explore the functions above in the meantime.
14. 12
    Unit 12

    Summary tables

    Group and pivot data with a single formula.

    Coming soon

    • GROUPBY soon
    • PIVOTBY soon
    • SUMPRODUCT soon

    Exercises for this unit are being written. Explore the functions above in the meantime.

Excel Tables, pivot tables and conditional formatting are coming to the path next.