Everyday Excel formulas
Six recipes with numbers you can check.
English
Deutsch
Cheat sheets
Printable reference tables for Excel and Google Sheets — shortcuts and functions, free, with no email gate.
Download the English and German pocket references below as PDF, Markdown or ZIP. Open the full reference tables for browser-generated Excel and CSV downloads, or print their tables without the navigation. No signup is required.
Printable PDF cheat sheets
Six one-page A4 references in English and German, with worked formulas, expected results and a diagnostic checklist. Download files directly; no signup.
Each ZIP contains 6 PDFs, 6 Markdown files with copyable formulas, CSV/TSV practice data, an answer key and import instructions. English and German editions use their own Excel function names and separators.
Look up the right value
XLOOKUP, VLOOKUP and INDEX + MATCH.
English
Deutsch
Sum and count with criteria
Use matching ranges and explicit boundaries.
English
Deutsch
Clean imported text
Paste any recipe into an empty cell.
English
Deutsch
Dates and deadlines
Fixed dates, reproducible results. No TODAY dependency.
English
Deutsch
Find the cause of an error
A diagnostic checklist, not a blanket IFERROR wrapper.
English
Deutsch
Practice input:CSV (comma-separated)TSV (paste at A1)
Keep the sample values unchanged. Date results need date formatting; the error checklist is a manual diagnostic aid. XLOOKUP requires Microsoft 365 or Excel 2021 or newer.
Full reference tables
Printable Excel Shortcuts Reference (Windows & Mac)
93 shortcuts for Windows and Mac side by side, grouped by what you are actually doing — navigation, selection, editing, formatting, formulas, data.
View and downloadExcel Functions Cheat Sheet
Every one of the 203 functions in our reference, with its syntax and what it actually does, in one alphabetical table.
View and downloadExcel Error Codes Cheat Sheet
Every Excel error value, what actually causes it, and the fix — including the two that are not errors at all.
View and downloadExcel Number Format Codes Cheat Sheet
Custom format codes with what each one actually displays — numbers, conditional colours, dates and elapsed time.
View and downloadExcel Paste Special Cheat Sheet
Every Paste Special option, what it actually pastes, and the Windows and Mac route to it.
View and downloadExcel Pivot Table Cheat Sheet
Pivot table tasks and exactly where each one lives, plus the behaviours that surprise people.
View and downloadQuestions
Do I have to give an email address?
No. Download the PDF, Markdown and ZIP files directly. The full reference tables are also available without signup.
Which formats can I download?
The six pocket references are available as PDF and Markdown, individually or in a ZIP with practice data and an answer key. The full reference tables retain their browser-generated Excel (.xlsx), CSV and print options.
Are the Mac shortcuts included?
Yes, in the same table as the Windows ones rather than on a separate page — because the people who need a shortcut reference most are usually moving between the two.