Printable Cheat Sheets
Bookmark them, print them or save them as PDF. Each sheet focuses on practical patterns rather than long definitions.
SQL Core Cheat Sheet
SELECT, WHERE, JOIN, GROUP BY, HAVING, CASE, ORDER BY and LIMIT patterns for daily analysis.
Open →SQLSQL Window Functions Cheat Sheet
ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD and running totals with practical patterns.
Open →SQLSQL JOIN Cheat Sheet
INNER, LEFT, anti-join and missing-match patterns with relationship warnings.
Open →ExcelExcel Lookup Cheat Sheet
XLOOKUP, INDEX/MATCH, COUNTIF existence checks and last-match patterns.
Open →ExcelExcel Analysis Formula Cheat Sheet
SUMIFS, COUNTIFS, FILTER, UNIQUE, SUMPRODUCT and percentage-change patterns.
Open →ExcelExcel Data Cleaning Cheat Sheet
TRIM, CLEAN, VALUE, TEXTSPLIT, duplicate checks and safe CSV import reminders.
Open →HTMLSemantic HTML Cheat Sheet
Page landmarks, headings, links, buttons, forms, tables and disclosure components.
Open →HTMLHTML Accessibility Cheat Sheet
Labels, keyboard focus, alt text, ARIA basics and common interaction rules.
Open →