Google Sheets Roadmap
All 215 lessons in the Google Sheets course, in a recommended order, in four stages. Go at your own pace, or jump ahead whenever you like. New lessons are added as they're written.
Start with a free lesson
Beginner
50 lessons · about 7 h 15 min · 1 free
Your first formulas, totals and counts, IF, names and dates, and sorting a list.
Show lessonsHide lessons
Getting started 15Formatting 8Formula basics 8Math and statistics 3Logic 1Text 3Dates and times 4Sorting and filtering 2Keyboard shortcuts 3Sharing, printing and protecting 3
Getting started
15 lessons · about 2 h 10 minFind your way around the screenIn the full course. 8 minSelect cells, ranges, rows and columns fastIn the full course. 9 minEnter and edit dataIn the full course. 8 minAutofill: numbers, dates and patternsIn the full course. 9 minUndo, redo and fixing mistakesIn the full course. 8 minInsert, delete and move rows and columnsIn the full course. 10 minResize columns and rows to fitIn the full course. 8 minFreeze the top row and first columnIn the full course. 8 minWork with multiple sheets (tabs)In the full course. 10 minCopy, cut, paste and Paste SpecialIn the full course. 11 minFind and replaceIn the full course. 9 minHide and unhide rows, columns and sheetsIn the full course. 8 minGroup rows and columnsIn the full course. 8 minZoom, gridlines and view optionsIn the full course. 7 minSave, download and file formatsIn the full course. 8 min
Formatting
8 lessons · about 1 h 15 minNumber formats: currency, percent, decimalsIn the full course. 10 minShow dates the way you wantIn the full course. 10 minFonts, colors and bordersIn the full course. 10 minAlign, wrap and rotate textIn the full course. 9 minMerge cells (and when not to)In the full course. 9 minCopy formatting with the format painterIn the full course. 8 minClear formatting fastIn the full course. 9 minAlternating row colorsIn the full course. 10 min
Formula basics
8 lessons · about 1 h 5 minYour first formulaIn the full course. 7 minOrder of operationsIn the full course. 9 minWhy your formula broke when you copied itFree · 7 minQuick totals with AutoSumIn the full course. 7 minCopy formulas down and acrossIn the full course. 10 minReference another sheetIn the full course. 8 minPercent change and percent of totalIn the full course. 10 minShow formulas instead of resultsIn the full course. 8 min
Math and statistics
3 lessons · 25 minLogic
1 lesson · 11 minText
3 lessons · 24 minDates and times
4 lessons · 36 minSorting and filtering
2 lessons · 17 minKeyboard shortcuts
3 lessons · 27 minSharing, printing and protecting
3 lessons · 24 minConfident
111 lessons · about 18 h 45 min · 4 free
Totals with conditions, lookups, pivot tables, charts, cleaning data, dropdowns and the everyday business math.
Show lessonsHide lessons
Formatting 2Formula basics 2Math and statistics 8Logic 6Text 9Dates and times 6Lookups 7Sorting and filtering 3Data cleaning 9Pivot tables 10Charts 9Conditional formatting 7Dropdowns and validation 5Tables and named ranges 2Errors and debugging 3Keyboard shortcuts 3Sharing, printing and protecting 2Business math 6Real-world projects 12
Formatting
2 lessons · 23 minFormula basics
2 lessons · 20 minMath and statistics
8 lessons · about 1 h 25 minSUMIF and COUNTIFIn the full course. 12 minSUMIFS and COUNTIFS with several conditionsIn the full course. 11 minAVERAGEIF and AVERAGEIFSIn the full course. 11 minMAXIFS and MINIFSIn the full course. 10 minRunning totalsIn the full course. 9 minRANK and top N listsIn the full course. 13 minMEDIAN and MODEIn the full course. 9 minRandom numbers: RAND and RANDBETWEENIn the full course. 11 min
Logic
6 lessons · about 1 hText
9 lessons · about 1 h 25 minJoin lists with TEXTJOINIn the full course. 9 minSplit full names into first and lastIn the full course. 10 minLEFT, RIGHT and MIDIn the full course. 9 minFIND and SEARCHIn the full course. 10 minSUBSTITUTE and REPLACEIn the full course. 11 minCount characters with LENIn the full course. 10 minPut numbers and dates inside text with TEXTIn the full course. 10 minExtract the domain from an email addressIn the full course. 9 minSplit text with SPLITIn the full course. 8 min
Dates and times
6 lessons · about 1 hAdd months with EDATE and EOMONTHIn the full course. 10 minWorking days with NETWORKDAYS and WORKDAYIn the full course. 12 minAge from date of birthIn the full course. 10 minWeekday names and week numbersIn the full course. 11 minHours workedIn the full course. 9 minShifts that run past midnightIn the full course. 9 min
Lookups
7 lessons · about 1 h 10 minLook up a price with VLOOKUP and XLOOKUPFree · 11 minWhy VLOOKUP returns #N/AIn the full course. 12 minHLOOKUP for sideways dataIn the full course. 8 minINDEX and MATCHIn the full course. 10 minXLOOKUP, the modern lookupIn the full course. 10 minXLOOKUP with a default when nothing is foundIn the full course. 10 minLook up across sheetsIn the full course. 8 min
Sorting and filtering
3 lessons · 27 minData cleaning
9 lessons · about 1 h 35 minRemove duplicatesFree · 9 minSplit one column into severalIn the full course. 8 minFix numbers stored as textIn the full course. 9 minFix dates stored as textIn the full course. 12 minRemove hidden characters and extra spacesIn the full course. 10 minFill blank cells with the value aboveIn the full course. 10 minStandardize inconsistent entries ("NY" vs "New York")In the full course. 11 minClean an imported CSVIn the full course. 12 minProject: clean a messy customer listIn the full course. 14 min
Pivot tables
10 lessons · about 1 h 35 minYour first pivot tableFree · 10 minRows, columns, values and filters explainedIn the full course. 9 minChange sum to count, average or percentIn the full course. 9 minGroup dates by month, quarter and yearIn the full course. 9 minGroup numbers into rangesIn the full course. 9 minSort and filter inside a pivotIn the full course. 11 minShow values as % of totalIn the full course. 10 minRefresh a pivot after the data changesIn the full course. 8 minFix common pivot problemsIn the full course. 10 minProject: sales by region and monthIn the full course. 12 min
Charts
9 lessons · about 1 h 20 minPick the right chartIn the full course. 10 minColumn and bar chartsIn the full course. 9 minLine charts for trendsIn the full course. 8 minPie and donut charts (and when not to)In the full course. 9 minTitles, labels and legendsIn the full course. 9 minColors and stylesIn the full course. 9 minCharts that update automaticallyIn the full course. 10 minCombo chart: columns plus a lineIn the full course. 9 minSPARKLINE functionIn the full course. 8 min
Conditional formatting
7 lessons · about 1 h 5 minHighlight cells above a valueIn the full course. 8 minColor scales and data barsIn the full course. 9 minHighlight the whole rowIn the full course. 9 minHighlight duplicatesIn the full course. 9 minHighlight overdue and due-this-week datesIn the full course. 11 minTraffic-light status columnIn the full course. 10 minManage and remove rulesIn the full course. 9 min
Dropdowns and validation
5 lessons · 47 minTables and named ranges
2 lessons · 15 minErrors and debugging
3 lessons · 29 minKeyboard shortcuts
3 lessons · 29 minSharing, printing and protecting
2 lessons · 17 minBusiness math
6 lessons · about 1 hReal-world projects
12 lessons · about 2 h 35 minBuild a monthly budgetIn the full course. 14 minInvoice templateIn the full course. 14 minTimesheet with overtimeIn the full course. 12 minInventory tracker with low-stock alertsIn the full course. 14 minExpense reportIn the full course. 13 minProject tracker with status and due datesIn the full course. 14 minGradebookIn the full course. 13 minSavings goal plannerIn the full course. 10 minWeekly shift rosterIn the full course. 13 minEvent budget and guest listIn the full course. 13 minPrice comparison sheetIn the full course. 13 minAttendance trackerIn the full course. 12 min
Advanced
46 lessons · about 8 h 5 min
Lookups by tier and with two conditions, XMATCH, FILTER and UNIQUE, percentiles and weighted averages. QUERY is being written.
Show lessonsHide lessons
Math and statistics 3Text 1Dates and times 1Lookups 5Dynamic arrays 10Sorting and filtering 1Data cleaning 1Pivot tables 3Charts 5Conditional formatting 1Dropdowns and validation 2Tables and named ranges 2Errors and debugging 1Sharing, printing and protecting 1Business math 2Real-world projects 7
Math and statistics
3 lessons · 29 minText
1 lesson · 10 minDates and times
1 lesson · 10 minLookups
5 lessons · 50 minDynamic arrays
10 lessons · about 1 h 40 minWhat "spilling" meansIn the full course. 9 minFILTER rows by a conditionIn the full course. 11 minFILTER with several conditionsIn the full course. 11 minUNIQUE valuesIn the full course. 10 minSORT and SORTBYIn the full course. 11 minSEQUENCEIn the full course. 9 minCount unique valuesIn the full course. 9 minCombine FILTER, SORT and UNIQUEIn the full course. 11 minCHOOSECOLS and VSTACKIn the full course. 10 minARRAYFORMULAIn the full course. 9 min
Sorting and filtering
1 lesson · 8 minData cleaning
1 lesson · 12 minPivot tables
3 lessons · 29 minCharts
5 lessons · 48 minConditional formatting
1 lesson · 12 minDropdowns and validation
2 lessons · 21 minTables and named ranges
2 lessons · 16 minErrors and debugging
1 lesson · 10 minSharing, printing and protecting
1 lesson · 9 minBusiness math
2 lessons · 22 minReal-world projects
7 lessons · about 1 h 40 minSales dashboardIn the full course. 15 minLoan repayment calculatorIn the full course. 15 minShopify orders analysisIn the full course. 14 minEmployee directory with lookupsIn the full course. 14 minCommission calculatorIn the full course. 12 minBreak-even analysisIn the full course. 14 minKPI scorecardIn the full course. 14 min
Analyst
8 lessons · about 1 h 45 min
LET and LAMBDA, timed tests, ten tasks employers test and a mock analyst take-home task.
Show lessonsHide lessons
Dynamic arrays
2 lessons · 20 minInterview prep
6 lessons · about 1 h 25 minGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.