Online Tutorial for Data Analysis and Automation
Google-Sheets-Formulas
Summarize data in Google Sheets step by step: SUMIFS and COUNTIFS with one or more conditions, SPARKLINE charts inside a cell, a pivot table in a few clicks, QUERY for a sorted summary table, plus the status bar for instant totals. Free practice file included.
Clean messy data in Google Sheets step by step: TRIM and CLEAN for spaces and hidden characters, PROPER/LOWER/UPPER for capitals, SPLIT and Split text to columns, UNIQUE and Remove duplicates, ISEMAIL for broken emails, plus ARRAYFORMULA to clean a whole column with one formula. Free practice file included.
A step-by-step XLOOKUP tutorial for Google Sheets: left lookups, killing #N/A without IFERROR, returning four columns from one formula, slab lookups with match_mode -1, latest-record lookups with search_mode -1, and a bonus two-way lookup. Free practice file included.