Spreadsheets for real work
Nine chapters, 6 h 10 min: from the first cell to a monthly report built from raw data.
What you will be able to do
Clean an export, look values up in another table, total it by month with a pivot table and turn it into a chart that answers the question. The last chapter is a report you build yourself.
Spreadsheets for real work at a glance
Video
6 h 10 min
Chapters
9
Exercises
18, marked by an instructor
Level
Beginner
Fee
Yours to keep (Example prices)
$59
Chapter by chapter
9 chapters, 6 h 10 min of video. Each segment of the bar is one chapter, drawn to its length.
0:00:00
Getting around
0:22:00
Daily formulas
1:10:00
Messy data
1:51:00
Lookups
2:43:00
Pivot tables
3:29:00
Charts
4:07:00
Dates and times
4:38:00
Small automations
5:22:00
Final project
0:00:00
Getting around
Cells, ranges, sheets and the six shortcuts that save the most time
22 min
1 exercise
0:22:00
Daily formulas
SUM, IF, COUNTIF and relative and absolute references
48 min
3 exercises
1:10:00
Messy data
Splitting, trimming and fixing imported lists
41 min
2 exercises
1:51:00
Lookups
Finding a value in another table without copying by hand
52 min
3 exercises
2:43:00
Pivot tables
Totals by month, by person and by region in a few clicks
46 min
2 exercises
3:29:00
Charts
The right chart for the question, labelled so it reads alone
38 min
2 exercises
4:07:00
Dates and times
Working days, deadlines and hours worked
31 min
2 exercises
4:38:00
Small automations
Validation, conditional formatting and a reusable template
44 min
2 exercises
5:22:00
Final project
A monthly report built from raw data, checked by an instructor
48 min
1 exercise
Watch the first lesson of any course, free
Tell us which course and we email a login for its first chapter. No card, no trial that turns into a subscription.