SQL Concepts with Spreadsheets: Joins, Group By & Filters
Learn what SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOINs, DISTINCT, CASE WHEN and date functions do by building every query result yourself with spreadsheet formulas, on live auto-graded labs.
The first 2 lessons are free — no account needed.
About this course
SQL for Excel users: learn what each part of a query does by building its result yourself with formulas you already know, on one coffee roaster's orders. You filter rows like WHERE with flags and COUNTIFS, rank and take the top 3 like ORDER BY … LIMIT, build GROUP BY tables with COUNTIFS, SUMIFS and AVERAGEIFS and filter them like HAVING, run an INNER JOIN and a LEFT JOIN with XLOOKUP and see which rows each one drops or fills with NULL, count DISTINCT values and duplicates, and bucket orders with IFS like CASE WHEN before grouping by month. No database to install, and the first two labs are free.
Lessons
- SELECT & WHERE: Filter Rows with Flags and COUNTIFSFree
- ORDER BY & LIMIT: Rank, Top 3 with LARGE and INDEX/MATCHFree
- GROUP BY with COUNT, SUM & AVG: COUNTIFS, SUMIFS, AVERAGEIFS Tables Pro
- HAVING: Filter Groups on Their Aggregates Pro
- INNER JOIN: XLOOKUP and the #N/A Rows a Join Drops Pro
- LEFT JOIN & NULLs: IFNA, 'Unknown' and Unmatched Rows Pro
- DISTINCT & Duplicates: First-Occurrence COUNTIF Pro
- CASE WHEN & Date Functions: IFS Buckets and YEAR/MONTH Grouping Pro