Google Sheets learning centre

Google Sheets Practical Tutorials

Choose a practical Google Sheets task below. Check the guide’s version, prerequisites and verification notes before following the steps.

For individual formulas, browse the Google Sheets function directory.

10 practical tutorials

Collaboration and notifications

Why IMPORTRANGE does not trigger conditional notificationsDiagnose Google Sheets email alerts that miss imported changes, check supported editions and trigger history, and choose a safer source-side workflow.Beginner · Google Sheets

Combining and checking data

Combine Google Sheets tabs with QUERY and keep one headerBuild a monthly-tab report, preserve the first record, exclude rows without the required RecordID, and reconcile every tab before and after growth.Intermediate · Google Sheets

Data management

Filter a shared Google Sheet without changing coworkers’ viewsCreate a named filter view, check visible order IDs, reopen or share the view, and avoid moving shared records with an ordinary sort.Beginner · Google Sheets Keep SKU codes as text in Google Sheets tablesChoose Text for a table’s SKU column, check exact identifiers before and after conversion, and distinguish tables, named ranges and named functions.Intermediate · Google Sheets

Date and time reports

Query Google Sheets timestamps between inclusive datesUse datetime literals and an exclusive next-day upper bound to keep late-night records, with reproducible timestamp fixtures and locale checks.Intermediate · Google Sheets

Formula troubleshooting

Fix FILTER mismatched range sizes after adding rows in Google SheetsReproduce a one-sided range extension, measure every FILTER input, repair the boundaries, and catch shifted-row errors that still return plausible results.Intermediate · Google Sheets

Importing and sharing data

Why IMPORTRANGE asks for access again in a shared Google SheetSeparate the active Google account, source-file access, destination connection and Workspace restrictions, then verify a small import before repairing the report.Intermediate · Google Sheets

Importing and validating data

Preserve CSV product IDs with a text transport copy in Google SheetsKeep an untouched CSV, import an ID-prefixed working copy, extract text with MID, and compare every identifier before using or exporting the results.Intermediate · Google Sheets

Reusable formulas

Import Google Sheets named functions without accidental overwritesMove reusable formulas between Google Sheets files, inspect dependencies and name collisions, and verify results before replacing a working definition.Intermediate · Google Sheets

Sheet and cell protection

Protect formula cells and leave Google Sheets inputs editableBuild a shared inventory sheet with editable quantities, restricted formulas, collaborator checks, and clear limits on what protection secures.Beginner · Google Sheets