Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Learn Excel › All lessons

All lessons

Five blocks, from your first SUM to pivot tables. Each block ends with a practice mission and a test: pass it and the next block opens.

  1. 1
    Block 1

    The basics

    1. Adding up+, SUM, SUMIF, SUMIFS8 exercises
    2. CountingCOUNT, COUNTA, COUNTIF, COUNTIFS6 exercises
    3. Averages and roundingAVERAGE, MIN, MAX, ROUND, LARGE6 exercises
    4. References and percentages$A$1, percentages, text to number5 exercises
    5. The sales reportMission5 questions · no tips5 exercises
    6. Test: the basicsTest10 questions
  2. 2
    Block 2

    Logic and calculations

    1. LogicIF, AND, OR, IFS, SWITCH5 exercises
    2. Smarter calculationsSUMPRODUCT, SUBTOTAL, MOD, STDEV5 exercises
    3. Catching errorsIFERROR, #DIV/0!, #N/A4 exercises
    4. The bonus checkMission4 questions · no tips4 exercises
    5. Test: logic and errorsTest8 questions
  3. 3
    Block 3

    Looking things up

    1. Looking upVLOOKUP, HLOOKUP, XLOOKUP7 exercises
    2. INDEX and MATCHINDEX, MATCH, INDIRECT5 exercises
    3. Dynamic arraysFILTER, UNIQUE, TRANSPOSE4 exercises
    4. The order deskMission4 questions · no tips4 exercises
    5. Test: lookups and arraysTest8 questions
  4. 4
    Block 4

    Text and dates

    1. Finding textLEFT, RIGHT, MID, LEN, FIND5 exercises
    2. Editing text&, CONCAT, UPPER, PROPER, TRIM, SUBSTITUTE5 exercises
    3. DatesDATE, TODAY, DATEDIF, EOMONTH, NETWORKDAYS6 exercises
    4. Clean the customer listMission4 questions · no tips4 exercises
    5. Test: text and datesTest8 questions
  5. 5
    Block 5

    Working with data

    1. Entering dataAutoFill, drop-down lists, Wrap Text, Merge5 exercises
    2. Sorting and filteringSort, Filter, Remove Duplicates, Text to Columns, Tables5 exercises
    3. Pivot tables and chartsPivotTable, charts3 exercises
    4. Formatting and protectingConditional formatting, Freeze Panes, Lock Cells, Paste Special5 exercises
    5. The expense reportMission5 questions · no tips5 exercises
    6. Test: working with dataTest6 questions