Spreadsheets That Do the Work For You
Excel and Google Sheets past the basics: absolute references, IF and SUMIF, lookups, cleaning messy data, pivot tables, and the habits that stop a sheet becoming unmaintainable.
Tools
5 lessons
Plus plan
From $4/month, unlocks this and the rest of the library
Start free preview
Create free account
Already a member? Sign in
- This course AND every other Plus course
- Playground Pro, private projects, Monaco editor
- Certificates on every course you finish
- Cancel any time. Access runs to the end of the period
- Pay in your currency, card or M-Pesa
- 1 lesson free to preview now
Course Curriculum
5 lessons · 1 free preview · ~1.3h total
2
IF, SUMIF and Counting What Matters
3
Lookups: Joining Two Sheets Together
4
Cleaning Data Somebody Else Typed
5
Pivot Tables and a Sheet Others Can Use
Student Reviews
No reviews yet. Be the first after completing!
Course Includes
- 5 structured lessons
- Live coding playground
- Hints when you're stuck
- Automatic code checking
- Completion certificate
- Included with Plus
- Mobile friendly