Wordless cover: graph paper grid with highlighter and a blue arrow

Video course

Spreadsheets without the dread

Twelve short video lessons from a tidy table to lookups, pivot tables and a chart for the Monday meeting, with a practice file for each.

  • Lessons: 12
  • Length: 2 h 4 min
  • Practice files: Included
  1. Module 13 lessons

    Tidy tables

    • 01Rows, columns and one fact per cell9 min
    • 02Freeze, sort and filter10 min
    • 03Formats that don't lie8 min
  2. Module 23 lessons

    Formulas

    • 04SUM, AVERAGE and friends11 min
    • 05IF without the tangle12 min
    • 06Lookups with a seating plan14 min
  3. Module 33 lessons

    Summaries

    • 07Your first pivot table13 min
    • 08Group by month10 min
    • 09The totals your manager asks for9 min
  4. Module 43 lessons

    Charts

    • 10One chart, one message11 min
    • 11Labels people can read8 min
    • 12The Monday report in ten minutes9 min
£79