Daily challengeStill lockedFinish your first module.

Module 1: First sheet

Every evening, Fern of The Golden Chip cashes up on the back of a beer mat. Her nephew gave her a spreadsheet, but she has no idea where to start. That's your job.

  1. 1
    Cells and ranges
  2. Your first formula
  3. Maths like at school
  4. Adding up with SUM
  5. Filling down
  6. Working with percentages
  7. Cashing upFinal test

Module 2: Functions and references

Ruth, the chair of Green Fingers, keeps ten allotment plots, their harvest and their rent in a single spreadsheet. The new rents need working out, and the annual general meeting wants figures. Ruth is counting on you.

  1. The average
  2. The biggest and the smallest
  3. Counting what's there
  4. Rounding
  5. Locking it with a dollar
  6. Locking just half
  7. The annual general meetingFinal test

Module 3: Logic

Dave, the manager of The Splash, wants to launch a summer pass: children and seniors get a discount, and only swimmers with two badges may go in the deep end. The spreadsheet has to make those decisions by itself.

  1. Comparing
  2. Choosing with IF
  3. AND, OR and NOT
  4. More than two choices
  5. Empty cells and IS functions
  6. Catching error values
  7. The summer passFinal test

Module 4: Counting and adding with conditions

At Second Chance, volunteers staff the till and note down every sale. Coordinator Yasmina wants to know what sells, who sells it and for how much. The answer is in the sheet, if you know how to ask.

  1. Counting what matches
  2. Criteria with operators
  3. Wildcards
  4. Adding up what matches
  5. Several conditions
  6. An average with a condition
  7. The weekly takingsFinal test

Module 5: Lookups

At Flying Velo, every ride has a code, a zone and a number of kilometres. Dispatcher Kyle still looks up the price, the customer and the surcharge with a finger on a printed table. Time to let the sheet do that work.

  1. Looking up in a column
  2. Price bands
  3. Looking up in a row
  4. Looking up in any direction
  5. Which position?
  6. The value at a position
  7. The dream team
  8. The dispatch sheetFinal test

Module 6: Text and dates

Natalie at Rings & Roses is planning the wedding of Ellie and Thomas. The guests typed their own names, with spaces and capitals wherever they liked. And the big day gets a little closer every day. Time to tame text and dates.

  1. Left and right
  2. Cutting from the middle
  3. Before and after a character
  4. Sticking text together
  5. Cleaning up
  6. Dates are numbers
  7. Calculating with dates
  8. The home straightFinal test

Module 7: Analysing data

Isla the brewer keeps every order in one long list: which beer, which customer, keg or bottle, how many litres. Twenty orders, and more every quarter. The bank wants to see figures, the pubs want to know what sells best. Time to make that list talk.

  1. Sorting
  2. Filtering
  3. Format as Table
  4. Conditional formatting
  5. Pivot tables
  6. Columns, filters and percentages
  7. Charts
  8. The annual meetingFinal test

Module 8: Dynamic arrays

A big screen at the entrance of Whirlwind theme park shows the queue times. Will, the park manager, types the lists out again every morning, and by lunchtime they're already wrong. Time for formulas that make their own lists.

  1. Spill
  2. Filtering with a formula
  3. Sorting with a formula
  4. Combining
  5. Names in a formula
  6. The big screenFinal test

Badges

  • First formulaYour first Excel lesson finished.not earned yet
  • FlawlessA lesson without a single mistake.not earned yet
  • Goal reachedReached your daily goal.not earned yet
  • On a rollPractised 3 days in a row.not earned yet
  • A full weekPractised 7 days in a row.not earned yet
  • Flawless moduleEvery lesson of a module without mistakes.not earned yet
  • ChallengerWon your first daily challenge.not earned yet
  • UnstoppableWon the daily challenge 7 days in a row.not earned yet
  • Final test passedPassed the final test of a module.not earned yet
  • Every final testPassed every final test.not earned yet