Google Sheets tutorials

Practical Sheets guides for spreadsheet.google.com - including collaboration features Excel does differently.

How to use VLOOKUP in Google SheetsWrite VLOOKUP in Google Sheets with a worked example, lock ranges with $, and see when to use XLOOKUP instead.How to share and protect a Google SheetShare a Google Sheet with view/comment/edit access, set general access links, and protect sheets or ranges so others cannot overwrite formulas.How to use filter views in Google SheetsCreate filter views so you can sort/filter a shared Google Sheet without changing what collaborators see.