
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.
Tidy tables
- Rows, columns and one fact per cell
- Freeze, sort and filter
- Formats that don't lie
Formulas
- SUM, AVERAGE and friends
- IF without the tangle
- Lookups with a seating plan
Summaries
- Your first pivot table
- Group by month
- The totals your manager asks for
Charts
- One chart, one message
- Labels people can read
- The Monday report in ten minutes
£79