The Excel Functions Master Reference is a single Excel workbook that explains 521 Excel functions, each on its own sheet with a sample dataset and live, editable example formulas. It costs ₹499 (one-time), includes free updates and a 14-day money-back guarantee, and is delivered instantly as an .xlsx file.
One-time payment · Instant download · Free updates · 14-day money-back guarantee
What is the Excel Functions Master Reference?
It is a learning and reference workbook that covers 521 Excel functions, from SUM and VLOOKUP to XLOOKUP, FILTER, LAMBDA, REGEX and GROUPBY. Every function has a dedicated sheet with its syntax, arguments, a plain-English explanation and 2–5 working examples that you can change and test inside Excel.
What is inside the workbook?
The workbook has 537 sheets: a Home page with a Function Finder, a Master Sheet listing all 521 functions A–Z, 14 category sheets and one sheet per function. Every example is a live formula, so results update the moment you edit the sample data.
- Function Finder: type any function name on the Home sheet and jump straight to its sheet.
- Master Sheet: all 521 functions with category, purpose, syntax, example and Excel version, filterable in one click.
- One sheet per function: purpose, syntax, an argument table (required or optional), how it works, a sample dataset and live examples.
- Editable sample data: yellow cells hold the data – change them and every result recalculates.
- Navigation on every sheet: Home, Master, Category, Previous and Next links.
- Spilling formulas that work: FILTER, SORT, UNIQUE, SEQUENCE and the LAMBDA family spill correctly in Excel 365.
How many functions are in each category?
Statistical is the largest category with 111 functions, followed by Math (57), Financial (55) and Engineering (54). The full split across all 14 categories is below.
| Category | Functions | Examples of functions included |
|---|---|---|
| Lookup & Reference | 21 | VLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET |
| Logical | 11 | IF, IFS, IFERROR, AND, SWITCH |
| Text | 49 | TEXTSPLIT, TEXTJOIN, LEFT, SUBSTITUTE, REGEXEXTRACT |
| Date & Time | 25 | DATEDIF, EOMONTH, NETWORKDAYS, WORKDAY |
| Math | 57 | SUMIFS, SUMPRODUCT, ROUND, AGGREGATE |
| Trigonometry | 23 | SIN, COS, RADIANS, DEGREES |
| Statistical | 111 | COUNTIFS, AVERAGEIFS, STDEV.S, FORECAST.ETS |
| Compatibility | 38 | STDEV, RANK, PERCENTILE (with their modern replacements) |
| Financial | 55 | PMT, FV, NPV, XIRR, IPMT |
| Information | 20 | ISNUMBER, ISBLANK, CELL, TYPE |
| Database | 12 | DSUM, DAVERAGE, DGET |
| Engineering | 54 | CONVERT, DEC2BIN, HEX2DEC, BITAND |
| Dynamic Array | 29 | FILTER, SORT, UNIQUE, LET, LAMBDA, GROUPBY |
| Web & Cube | 16 | WEBSERVICE, IMAGE, PY, CUBEVALUE |
| Total | 521 |
Which Excel versions does it work with?
The workbook opens in Excel 2007 or later, and 351 of the 521 functions work in every version. Newer functions show #NAME? in older Excel, so every sheet states the version a function needs. Excel for Microsoft 365 supports all 521.
| Your Excel version | Functions that work |
|---|---|
| Excel 2007 | 351 |
| Excel 2010 | 412 |
| Excel 2013 / 2016 | 462 / 467 |
| Excel 2019 | 473 |
| Excel 2021 | 482 |
| Excel 2024 | 507 |
| Microsoft 365 | 521 |
What does each function sheet contain?
Each of the 521 function sheets follows the same six-part layout, so you always know where to look. You read the explanation, then change the yellow cells to see how the function reacts.
- Overview: purpose, syntax, category and the Excel version required.
- Arguments: every argument, whether it is required or optional, and what to enter.
- How it works: a short explanation in plain English.
- Sample data: a realistic dataset (course sales, student marks, products, cash flows).
- Examples: 2–5 live formulas, each with the formula text and what it does.
- Result: the calculated answer, updated instantly when you edit the data.
Who is this workbook for?
- Beginners: learn functions by changing data and watching results, not by memorising syntax.
- Working professionals: a quick, reliable reference for the function you need today.
- Students and job seekers: prepare for Excel tests and interviews with worked examples.
- Trainers: ready-made examples for classroom demonstrations.
How much does it cost?
The workbook costs ₹499 as a one-time payment, with no subscription. You get every future update free and can ask for a full refund within 14 days of purchase. Payment and delivery are handled securely by Gumroad.
Frequently asked questions
How do I receive the workbook after payment?
You get a download link on screen and by email right after payment. The file is a 1.5 MB .xlsx workbook that you keep forever.
Does it work on Mac or in Google Sheets?
It works in Excel for Windows and Excel for Mac. Google Sheets can open it, but some Excel-only functions and the dynamic array examples will not work there.
Why do some functions show #NAME?
Your Excel version is older than the function. Each sheet shows the version required, for example XLOOKUP needs Excel 2021 or Microsoft 365.
Will I get new functions when Microsoft adds them?
Yes. The workbook is updated when Microsoft adds or retires functions, and buyers get each new version free from the same download link.
Can I get a refund?
Yes. If you are not happy, request a full refund within 14 days of purchase – no questions asked.