Google Sheets QUERY Function for Excel Users
Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…
Read article →SQL
Query data like a pro — explained for Excel users.
SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query
SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query
A practical guide to SQL window functions: OVER and PARTITION BY, ROW_NUMBER, RANK and DENSE_RANK, running totals, moving averages, LAG/LEAD for month-on-month change, and…
Read article →SQL GROUP BY and HAVING: Pivot Tables Written in SQL
SQL GROUP BY and HAVING: Pivot Tables Written in SQL
Summarise data with SQL GROUP BY, filter groups with HAVING, and understand the difference from WHERE — explained for Excel users with pivot-table comparisons.
Read article →