Learn Google Sheets, one clear step at a time.
Short videos, exact steps, example data, and a spreadsheet result checked after every recording.
Errors
Locale causes formula parse errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Invalid range referenceDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Columns disappearedDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Rows disappearedDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Copy and paste not workingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Protected range not workingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Filter not workingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Chart data range wrongDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Chart not updatingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Conditional formatting not workingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Dropdown rejects valid valueDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Dropdown not showingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Checkboxes not workingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Leading zeros disappearingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Numbers stored as textDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Formula showing as textDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Formula not calculatingDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Filter has mismatched range sizesDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Xlookup returns #N/ADifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Vlookup cannot find valueDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Vlookup returns wrong valueDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Query parse errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Circular dependency errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→#ERROR formula parse errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→#NUM errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→#NAME errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→#DIV/0 errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→#VALUE errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→#N/A errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→#REF errorDifficulty 3/5 · 75s · Verified by Josephine · July 25, 2026
→Spreadsheet basics
Highlight blank cellsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Highlight weekendsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Highlight dates before todayDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create a scatter plotDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Count checked boxesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Add emoji to cellsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create a sparklineDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create a progress barDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Remove a hyperlinkDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Link to a cell rangeDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create a hyperlinkDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Use a named range in a formulaDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Convert text to datesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Convert numbers to textDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Convert text to numbersDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Extract numbers from textDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Separate first and last namesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Remove extra spacesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Delete hidden rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Remove empty columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Remove empty rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Remove line breaksDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Replace line breaksDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Find and replaceDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Use autofillDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create a date seriesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create a numbered listDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Fill rightDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Fill downDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Transpose rows and columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Copy a columnDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Copy a rowDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Swap columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Swap rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Move columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Move rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Delete columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Delete rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Insert columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Insert rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Add a currency symbolDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Show leading zerosDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Remove decimal placesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Align text verticallyDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Center textDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Unmerge cellsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Merge cellsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Make all rows the same heightDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Make all columns the same widthDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Resize rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Resize columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Group columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Group rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Unhide columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Hide a columnDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Unhide rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Hide a rowDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Unfreeze rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Freeze rows and columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Freeze the first columnDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Freeze multiple rowsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Formatting
Highlight an entire row with conditional formattingDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Use a custom formula in conditional formattingDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create conditional formattingDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Change date formatDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Create a custom number formatDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Format negative numbersDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Format phone numbersDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Format timeDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Format datesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Clear formattingDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Copy formattingDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Remove bordersDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Add bordersDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Change cell colorDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Highlight low stock with conditional formattingDifficulty 4/5 · 55s · Verified by Josephine · July 25, 2026
→Add alternating colours to a tableDifficulty 2/5 · 35s · Verified by Josephine · July 25, 2026
→Format cells as datesDifficulty 2/5 · 24s · Verified by Josephine · July 25, 2026
→Format numbers as percentagesDifficulty 1/5 · 22s · Verified by Josephine · July 25, 2026
→Wrap an entire text columnDifficulty 2/5 · 25s · Verified by Josephine · July 25, 2026
→Make a total row boldDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Freeze the top two rowsDifficulty 1/5 · 22s · Verified by Josephine · July 25, 2026
→Format a column as currencyDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Apply alternating row coloursDifficulty 2/5 · 35s · Verified by Josephine · July 25, 2026
→Wrap textDifficulty 2/5 · 25s · Verified by Josephine · July 25, 2026
→Make the header row boldDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Freeze the top rowDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Highlight duplicate valuesDifficulty 4/5 · 60s · Verified by Josephine · July 25, 2026
→Charts
Create a combo chartDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Create an area chartDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Create a column chartDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Create a bar chartDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Create a revenue line chartDifficulty 4/5 · 55s · Verified by Philis · July 15, 2026
→Create a line chartDifficulty 4/5 · 55s · Verified by Philis · July 15, 2026
→Data validation
Conditionally format checkboxesDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Check all checkboxesDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Copy a dropdownDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Edit data validationDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Add data validationDifficulty 2/5 · 60s · Verified by Philis · July 15, 2026
→Create a project status dropdownDifficulty 3/5 · 45s · Verified by Philis · July 15, 2026
→Add a checkbox columnDifficulty 2/5 · 28s · Verified by Philis · July 15, 2026
→Create a Yes or No dropdownDifficulty 2/5 · 40s · Verified by Philis · July 15, 2026
→Add checkboxesDifficulty 2/5 · 25s · Verified by Philis · July 15, 2026
→Create a dropdown listDifficulty 3/5 · 45s · Verified by Philis · July 15, 2026
→Use-case templates
Employee schedule templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Attendance tracker templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Meal planner templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Habit tracker templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Keyword research templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Marketing campaign tracker templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→SEO content plan templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Purchase order tracker templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Inventory tracker templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Lead tracker templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Sales pipeline templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Annual budget templateDifficulty 4/5 · 120s · Verified by Philis · July 15, 2026
→Function guide
MAKEARRAY functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SCAN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→REDUCE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MAP functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→BYCOL functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→BYROW functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→RATE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→PV functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→FV functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→PMT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→XIRR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→NPV functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→FREQUENCY functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→PERCENTRANK functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SPARKLINE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→NOW functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TODAY functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→LOOKUP functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→RANDBETWEEN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→AGGREGATE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→RAND functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→IRR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→LINEST functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TREND functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→VAR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→STDEV functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→OFFSET functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→XMATCH functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MATCH functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→INDEX functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→XLOOKUP functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→HLOOKUP functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→VLOOKUP functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MINIFS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MAXIFS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→AVERAGEIFS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→AVERAGEIF functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→COUNTIFS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→COUNTIF functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SUMIFS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SUMIF functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→LAMBDA functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→LET functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SWITCH functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→IFNA functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→IFERROR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→XOR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→NOT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→OR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→AND functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→IFS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→IF functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SEQUENCE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SUBTOTAL functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SUMPRODUCT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→PRODUCT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MOD functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ABS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TRUNC functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→INT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ROUNDDOWN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ROUNDUP functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ROUND functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MODE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MEDIAN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MIN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MAX functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→COUNTBLANK functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→COUNTA functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→COUNT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→AVERAGE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SUM functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CHOOSE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→NPER functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→FORECAST functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→INTERCEPT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SLOPE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CORREL functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→STDEV.P functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→QUARTILE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→PERCENTILE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→RANK.AVG functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→RANK.EQ functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→RANK functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SHEETS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SHEET functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→COLUMNS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→COLUMN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ROWS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ROW functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CELL functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TYPE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISODD functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISEVEN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISNA functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISERR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISERROR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISDATE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISTEXT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISNUMBER functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISBLANK functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→HYPERLINK functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ISOWEEKNUM functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→WEEKNUM functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→WEEKDAY functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→NETWORKDAYS.INTL functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→NETWORKDAYS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→WORKDAY.INTL functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→WORKDAY functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→EOMONTH functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→EDATE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→DAYS360 functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→DAYS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→DATEDIF functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SECOND functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MINUTE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→HOUR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TIMEVALUE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TIME functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→YEAR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MONTH functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→DAY functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→DATEVALUE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→DATE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→REPT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→REGEXREPLACE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→REGEXEXTRACT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→REGEXMATCH functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CODE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CHAR functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TEXT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→VALUE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→EXACT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SEARCH functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→FIND functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→REPLACE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SUBSTITUTE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→JOIN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TEXTJOIN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CONCATENATE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CONCAT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→PROPER functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→LOWER functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→UPPER functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CLEAN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TRIM functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→LEN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→MID functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→RIGHT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→LEFT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SPLIT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TRANSPOSE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→FLATTEN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→HSTACK functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→VSTACK functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CHOOSEROWS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→CHOOSECOLS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→WRAPCOLS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→WRAPROWS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TOROW functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→TOCOL functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ARRAYFORMULA functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→QUERY functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→UNIQUE functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SORTN functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→SORT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→FILTER functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→ADDRESS functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→INDIRECT functionDifficulty 3/5 · 60s · Verified by Josephine · July 25, 2026
→Sort and filter
Filter by multiple valuesDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Filter by dateDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Filter by conditionDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Sort by dateDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Sort by colorDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Sort by multiple columnsDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Sort alphabeticallyDifficulty 2/5 · 60s · Verified by Josephine · July 25, 2026
→Import and export
Formulas
Find the minimum valueDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Count completed tasks with COUNTIFDifficulty 2/5 · 24s · Verified by Josephine · July 25, 2026
→Look up a product name with VLOOKUPDifficulty 3/5 · 30s · Verified by Josephine · July 25, 2026
→Count non-empty cells with COUNTADifficulty 2/5 · 22s · Verified by Josephine · July 25, 2026
→Extract unique valuesDifficulty 3/5 · 28s · Verified by Josephine · July 25, 2026
→Look up a value with INDEX and MATCHDifficulty 4/5 · 35s · Verified by Josephine · July 25, 2026
→Add a SUMIF formulaDifficulty 3/5 · 28s · Verified by Josephine · July 25, 2026
→Handle a formula error with IFERRORDifficulty 2/5 · 25s · Verified by Josephine · July 25, 2026
→Combine first and last namesDifficulty 2/5 · 25s · Verified by Josephine · July 25, 2026
→Round a numberDifficulty 2/5 · 22s · Verified by Josephine · July 25, 2026
→Find the maximum valueDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Calculate an averageDifficulty 1/5 · 22s · Verified by Josephine · July 25, 2026
→Calculate total revenue with SUMDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Add a VLOOKUP formulaDifficulty 3/5 · 28s · Verified by Josephine · July 25, 2026
→Add a COUNTIF formulaDifficulty 2/5 · 22s · Verified by Josephine · July 25, 2026
→Add an IF formulaDifficulty 2/5 · 35s · Verified by Josephine · July 25, 2026
→Add a SUM formulaDifficulty 1/5 · 20s · Verified by Josephine · July 25, 2026
→Data cleaning
Remove extra spaces from namesDifficulty 2/5 · 35s · Verified by Josephine · July 25, 2026
→Split comma-separated text into columnsDifficulty 3/5 · 40s · Verified by Josephine · July 25, 2026
→Remove duplicate customersDifficulty 3/5 · 40s · Verified by Josephine · July 25, 2026
→Split text into columnsDifficulty 3/5 · 40s · Verified by Josephine · July 25, 2026
→Trim whitespaceDifficulty 2/5 · 35s · Verified by Josephine · July 25, 2026
→Remove duplicate rowsDifficulty 3/5 · 40s · Verified by Josephine · July 25, 2026
→Protection
Sort & filter
Add a filter to a project tableDifficulty 2/5 · 28s · Verified by Josephine · July 25, 2026
→Sort prices highest to lowestDifficulty 2/5 · 40s · Verified by Josephine · July 25, 2026
→Add a filterDifficulty 2/5 · 25s · Verified by Josephine · July 25, 2026
→Sort highest to lowestDifficulty 3/5 · 40s · Verified by Josephine · July 25, 2026
→