Google Sheets & Excel basics, formulas, dashboards
Generate clean UTM links your analytics can trust. Includes naming conventions and a QA checklist. Download the UTM Builder Copy the Sheet and set your team’s naming convention once. Set Your Naming Convention Suggested taxonomy Build Links (Formulas) Assuming base URL in A2 and parameters in B2:F2: Auto‑validate required fields (Data → Data validation): require…
Compare lists, find differences, and join data safely without breaking keys. Method 1 — Lookup Match (VLOOKUP/XLOOKUP) Goal: pull a column from B into A by matching a key. Sheets: Excel (modern): Method 2 — INDEX‑MATCH (robust classic) Add error handling: Method 3 — QUERY Join (Sheets) Left join A (left) to B (right) by…
Fix messy CSVs fast with copy‑paste recipes for the most common cleanup tasks. Quick Recipes Table Task Sheets Formula / Path Remove duplicate rows (by email) =UNIQUE(A2:D) or Data → Remove duplicates Trim spaces/nonprintables =TRIM(CLEAN(A2)) Proper case names =PROPER(A2) Split full name =SPLIT(A2,” “) or =REGEXEXTRACT(A2,”^(\\S+)\\s+(.*)$”) Standardize phone =REGEXREPLACE(A2,”[^0-9]”,””) Anti‑join (remove overlaps) =FILTER(A2:A, ISNA(MATCH(A2:A, C2:C,0)))…
Build a live KPI dashboard in ~20 minutes. Copy the template, connect your data, and ship clean reports fast. What You’ll Get How the Dashboard Works (Data → Model → View) Data holds raw events or aggregate metrics.Model standardizes types, calculates KPIs, and prepares tidy tables.View contains pivots, charts, and controls for the dashboard page….
