Learn google sheets
Short lessons written around the screening tests employers use. Read one, then take the test.
Lookups, FILTER and UNIQUE in Google SheetsHow VLOOKUP, XLOOKUP, FILTER and UNIQUE work, and the small mistakes that make them return the wrong result.Lesson 1
Sharing, IMPORTRANGE and keeping a shared sheet safeSharing roles, protected ranges, filter views, data validation, IMPORTRANGE and version history for shared work.Lesson 2
The QUERY function: SQL-style questions on a sheetHow to select, filter, sort and group with QUERY, and the column-letter and quoting mistakes that cause errors.Lesson 3
ARRAYFORMULA, SPLIT and cleaning text in Google SheetsHow to fill a whole column with one formula, split and trim messy text, and fix numbers stored as text before they break totals.Lesson 4
Advertisement