Skip to content
Skillreps
← All skills
Data

Organise anything in Google Sheets

Enter and format data, write formulas, sort and filter, and turn numbers into charts and pivot tables, free in your browser.

By the end you’ll have made: A monthly budget with formulas and a chart

Time to learn

≈ 4 h 16 min

That’s about 17 coffee breaks.

50 min watching · 2 h 55 min practising · 31 min on quizzes and games

3 modules · 8 lessons

Start lesson one

Modules

  1. Week 1Get started

    ≈ 1 h 26 min · 6 coffee breaks
    1. What Google Sheets is and where to find it6:26
    2. Enter and format data7:16
    3. Conditional formatting, freezing and Explore6:12
    4. Get started gamesTower · Speed round · Match-up

  2. Week 2Formulas

    ≈ 1 h 9 min · 5 coffee breaks
    1. Arithmetic, functions and SUM5:59
    2. Relative and absolute references, named ranges3:39
    3. Formulas gamesTower · Speed round · Match-up

  3. Week 3Find, sort and summarise

    ≈ 1 h 41 min · 7 coffee breaks
    1. VLOOKUP, multiple sheets, sort and filter7:07
    2. Charts and pivot tables6:10
    3. Forms, sharing and version history6:22
    4. Find, sort and summarise gamesTower · Speed round · Match-up