
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
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









