The course
All lessons
Start with five free lessons, then see the skills covered in every planned members module.
Sheets basics
Cells, ranges, shortcuts, your first formulas, and sorting.
Sheets basics
Select cells, enter a value, select a range, and write a first formula.
About 3 minutesEssential shortcuts
Practice copy, paste, undo, and bold with the keys for your computer.
About 3 minutesSUM, AVERAGE, COUNT
Add, average, and count a range of numbers.
About 4 minutesCell references
Use relative references and keep one rate fixed with an absolute reference.
About 4 minutesSort and filter
Reorder a table by score and show rows from one category.
About 4 minutesLogic and conditions
Make a sheet decide things for you.
IF · IFS · COUNTIF · SUMIF
See members details →Lookups
Find and pull data from another table.
VLOOKUP · XLOOKUP · FILTER · QUERY
See members details →Dynamic arrays
One formula that fills a whole column.
ARRAYFORMULA · UNIQUE · SORT
See members details →Pivot tables
Summarize thousands of rows in a few clicks.
Pivot table · Group by · Totals
See members details →Clean data and get hired
Text, dates, imports, then interview practice and your certificate.
TEXT · SPLIT · DATE · Interview pack
See members details →