Spreadsheet Formula Cheat Sheet Pack

Spreadsheet Formula Cheat Sheet Pack — Printable cheat sheets for the formulas you actually use — plus a working demo workbook where every single one of them is live in a cell against sample data.

Most formula references show you syntax and leave you to find out the hard way whether it works. This one ships both halves. The printable cheat sheets cover the formulas people genuinely use — the essentials, logic, lookup, text, dates, conditional totals and percentages — each with the formula as you type it, the answer it gives on the sample data, and one line explaining what it is doing. Alongside them sit the pages that stop the swearing: every error message explained by cause and fix, absolute versus relative references shown with a worked example, a which-formula-do-I-need chooser, a page on where Excel and Google Sheets differ, and a one-page quick card for pinning up. The other half is a demo workbook in which all 109 formulas are live in cells, computing against a small invented sales table, a price list and a sheet of deliberately messy text and dates. Click any cell and read the real formula in the formula bar; change the data and watch which answers move. Every formula in the workbook uses functions that work in both Excel and Google Sheets, including older versions of Excel, so it opens and computes anywhere — the newer alternatives are covered on the printed sheets with a note saying which versions have them.

What's inside

• PRINTABLE A4 CHEAT SHEETS (PDF): the essentials, logic, lookup, text, dates, conditional maths and percentages — each formula shown as you type it, with the answer it produces on the sample data and a plain-English line on what it does
• WORKING DEMO WORKBOOK (XLSX): all 109 formulas live in cells across 7 demonstration sheets, computing against a twelve-row sales table, a five-row price list and a sheet of deliberately messy text and dates
• ERROR MESSAGES EXPLAINED: #REF!, #VALUE!, #N/A, #DIV/0!, #NAME?, #NUM!, #NULL! and the row of hashes — what causes each one and how to fix it
• ABSOLUTE VS RELATIVE REFERENCES: what the dollar signs do, shown with a worked before-and-after that explains why a copied formula stops working
• VLOOKUP AND ITS GOTCHAS: why the lookup column has to come first, why the last argument must be FALSE, and what INDEX with MATCH does that VLOOKUP cannot
• WHICH FORMULA DO I NEED: a chooser that goes from what you are trying to do to the function that does it
• EXCEL AND GOOGLE SHEETS: a page on where they differ, which functions are new, and what to use instead if your file has to open on an older version
• PRINTABLE ONE-PAGE QUICK CARD: the most-used formulas on a single sheet for pinning up next to the screen
• A HABITS CHECKLIST that prevents most spreadsheet bugs before they happen
• Functions covered live in the workbook: AND, AVERAGE, AVERAGEIF, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, DATE, DATEDIF, DAY, EDATE, EOMONTH, FIND, IF, IFERROR, INDEX, ISBLANK, LEFT, LEN, LOWER, MATCH, MAX, MEDIAN, MID, MIN, MONTH, NETWORKDAYS, NOT, OR, PROPER, RIGHT, ROUND, ROUNDUP, SUBSTITUTE, SUM, SUMIF, SUMIFS, SUMPRODUCT, TEXT, TODAY, TRIM, UPPER, VLOOKUP, WEEKDAY, YEAR

How it works

The PDF guide walks you through step by step, with ready-to-use wording you can adapt. The XLSX tracker comes pre-filled with example data — fill the gold cells and every total and status updates automatically.

Specifications

• Format: PDF guide + XLSX (live formulas) + read-me
• Works in: Word, Google Docs, LibreOffice, Excel, Google Sheets
• License: full rights — use, edit, rebrand & resell
• Updates: free for life

Full rights

Sold with full rights: use it personally or with clients, edit anything, and even rebrand and resell it — keep 100% of the income, no attribution required. Customise before reselling (marketplaces reject identical duplicates).

Please note

Productivity and digital-organisation templates for personal and business use. Example entries are illustrations to adapt to your own setup. Never record passwords, PINs, one-time codes or full card numbers in these files — keep secrets in a dedicated password manager. Any security checklist here is general good practice, not a security audit or professional IT advice. Digital download — delivered instantly, so all sales are final; future updates are free.