Ledger DrillBeta
Log inJoin for free

Spreadsheets for the office

The formulas an office job really uses, in Excel or Google Sheets: sums, percentages, IF, lookups, dates and pivot tables.

Easy6 of 6 modules open30 rooms
Module 1

Cells and formulas

Where a spreadsheet starts: how cells are named, how a formula is written, and why a total comes out right or wrong.

  1. 1Cells, rows, columns and ranges6 min, easy
  2. 2How to write a formula7 min, easy
  3. 3How to add up a column with SUM8 min, easy
  4. 4Relative and absolute references9 min, easy
  5. 5Order of operations and brackets9 min, easy
Recap this moduleSix questions, starting with the ones you got wrong.
Module 2

Everyday functions

The functions an office uses every day: averages, counts, totals by name, rounding and percentages.

  1. AVERAGE, MIN and MAX7 min, easyPremium
  2. COUNT, COUNTA and COUNTIF8 min, easyPremium
  3. How to use SUMIF8 min, easyPremium
  4. ROUND, ROUNDUP and ROUNDDOWN8 min, easyPremium
  5. How to work out a percentage in a spreadsheet9 min, easyPremium
Module 3

Making decisions

Make a sheet decide for itself: show one thing or another with IF, join tests with AND and OR, and flag the invoices that are overdue.

  1. How IF works8 min, easyPremium
  2. IF with AND and OR9 min, easyPremium
  3. Nested IF for three or more outcomes9 min, mediumPremium
  4. IFERROR: what to show when a formula fails9 min, mediumPremium
  5. Flagging overdue invoices10 min, mediumPremium
Module 4

Looking things up

Fetch a price, a name or a credit limit from a list with VLOOKUP, XLOOKUP, and INDEX with MATCH. Then fix the lookups that fail.

  1. How VLOOKUP works8 min, easyPremium
  2. VLOOKUP: exact match or nearest match?8 min, easyPremium
  3. How XLOOKUP works9 min, easyPremium
  4. How INDEX and MATCH work together9 min, mediumPremium
  5. How to fix a lookup that returns #N/A10 min, mediumPremium
Module 5

Dates and text

How a spreadsheet stores dates, how to count days and work out due dates, and how to join, split and tidy text that arrives in a mess.

  1. How a spreadsheet stores a date8 min, easyPremium
  2. How to count the days between two dates8 min, easyPremium
  3. TODAY and how to work out a due date8 min, easyPremium
  4. How to join and split text10 min, easyPremium
  5. How to clean up imported data9 min, mediumPremium
Module 6

Summarising data

Turn a long list into answers: sort it, filter it, total it by customer or by month with a pivot table, and check the result.

  1. How to sort and filter a list8 min, easyPremium
  2. What a pivot table does9 min, easyPremium
  3. How to read a pivot table9 min, easyPremium
  4. How to get totals by month9 min, mediumPremium
  5. How to check a spreadsheet for mistakes10 min, mediumPremium