Data Cleaning
-
Essential SQL SELECT, WHERE, and GROUP BY for Spreadsheet Analysts
Transition from Excel and Google Sheets to SQL. Learn how SELECT, WHERE, GROUP BY, and HAVING map directly to familiar spreadsheet workflows.
-
REGEXEXTRACT and REGEXREPLACE: Clean Messy Workplace Data Fast
Clean chaotic workplace text in Google Sheets using REGEXEXTRACT, REGEXREPLACE, and REGEXMATCH. Real-world patterns for emails, invoice numbers, and phone formatting.