Short, focused explanations for converting files, fixing formatting issues, and choosing the right spreadsheet format.
Learn Google Sheets conditional formatting: color scales, data bars, custom formulas, row highlighting, and how to highlight duplicates — with copy-paste rules.
Master the Google Sheets data validation dropdown: create dropdown lists, build dropdowns from a range, make dynamic and dependent lists. Step-by-step 2026 guide.
How to change date format in Google Sheets: Format menu, custom formats, locale settings, TEXT function, and converting text to dates. Fix misread CSV dates.
Master the Google Sheets FILTER function: multi-condition filtering, FILTER+SORT+UNIQUE combos, 10 copy-paste recipes, and fixes for every common error.
Master find and replace in Google Sheets: Ctrl+H basics, match case, regex patterns, replace across all sheets, and searching within formulas.
How to freeze rows in Google Sheets: freeze the top row, freeze multiple rows and columns, unfreeze, mobile steps, and printing with frozen headers.
Master the Google Sheets IMPORTDATA function: import CSV from URL automatically, fix delimiter issues, control refresh timing, and combine it with QUERY and VLOOKUP.
This Google Sheets IMPORTRANGE tutorial shows how to pull live data across spreadsheets: setup, the allow-access prompt, QUERY combos, and fixes when it's not working.
The 25 Google Sheets keyboard shortcuts that matter for data work: fill down, paste special, navigation, formatting. Plus Mac keys and a cheat sheet.
Learn how to create a pivot table in Google Sheets step by step: rows, columns, values, calculated fields, and pro grouping tricks for CSV-like raw data.