Every new formula of 2026, on three pages
A cheat sheet of the newest Excel and Google Sheets formulas, from REGEX and GROUPBY to =AI() and Gemini, plus the 16 practice workbooks from the videos. Every formula tested on screen.
3 pages + 16 files
What's inside
One zip file. Open the workbooks in Excel, or upload them to Google Drive and open them in Sheets.
| File | What you get | |
|---|---|---|
| 1 | Cheat sheet, page 1Excel: the new functions | REGEXTEST · REGEXEXTRACT · REGEXREPLACE · GROUPBY · PIVOTBY · PERCENTOF · TRANSLATE · the :. trim · a real search box |
| 2 | Cheat sheet, page 2Google Sheets + Gemini | =AI() · Fill column with Gemini · Fix errors · dashboard from a prompt · Sheets canvas · QUERY |
| 3 | Cheat sheet, page 3Works in both | XLOOKUP · MAP · REDUCE · LET · SUMIFS · RANK without ties · dates as text + a table of the jobs where Excel and Sheets need a different formula |
| 4 | 16 practice workbooksThe exact data from the videos | Type each formula in the same cells as on screen. Every file names its video. |
| 5 | UpdatesWhen a new video comes out | New templates go to the list first. Next up: the Excel search box. |
Questions
- Is it really free?
- Yes. You pay with your email address, and you can unsubscribe the moment the emails stop being useful.
- Excel or Google Sheets?
- Both. Every formula is labelled Excel, Sheets or Both, so you know before you type it.
- Which Excel version?
- The new functions need Microsoft 365 or Excel for the web. The page-3 formulas work in older versions too.
- What will you email me?
- The download link, then new tutorials and templates, at most once a week. No sharing, no selling of your address.