Excel Functions Master Reference – 521 Functions with Live Examples

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.

By Ajay Anand, 7-time Microsoft Excel MVP (2019–2026) · Last updated: 19 November 2026

521Excel functions
537sheets
14categories
1,465live formulas

₹499Get the workbook →

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.

CategoryFunctionsExamples of functions included
Lookup & Reference21VLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET
Logical11IF, IFS, IFERROR, AND, SWITCH
Text49TEXTSPLIT, TEXTJOIN, LEFT, SUBSTITUTE, REGEXEXTRACT
Date & Time25DATEDIF, EOMONTH, NETWORKDAYS, WORKDAY
Math57SUMIFS, SUMPRODUCT, ROUND, AGGREGATE
Trigonometry23SIN, COS, RADIANS, DEGREES
Statistical111COUNTIFS, AVERAGEIFS, STDEV.S, FORECAST.ETS
Compatibility38STDEV, RANK, PERCENTILE (with their modern replacements)
Financial55PMT, FV, NPV, XIRR, IPMT
Information20ISNUMBER, ISBLANK, CELL, TYPE
Database12DSUM, DAVERAGE, DGET
Engineering54CONVERT, DEC2BIN, HEX2DEC, BITAND
Dynamic Array29FILTER, SORT, UNIQUE, LET, LAMBDA, GROUPBY
Web & Cube16WEBSERVICE, IMAGE, PY, CUBEVALUE
Total521

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 versionFunctions that work
Excel 2007351
Excel 2010412
Excel 2013 / 2016462 / 467
Excel 2019473
Excel 2021482
Excel 2024507
Microsoft 365521

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.

  1. Overview: purpose, syntax, category and the Excel version required.
  2. Arguments: every argument, whether it is required or optional, and what to enter.
  3. How it works: a short explanation in plain English.
  4. Sample data: a realistic dataset (course sales, student marks, products, cash flows).
  5. Examples: 2–5 live formulas, each with the formula text and what it does.
  6. 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.

Buy now for ₹499 →

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.

About the author: Ajay Anand is a 7-time Microsoft Excel MVP (2019–2026) and the founder of XL n CAD. He teaches Excel to around 500,000 YouTube subscribers in English and Malayalam. Need a quick answer without opening Excel? Try the free tools at quickeasycalculators.com.

Last updated · Written by Ajay Anand, Microsoft Excel MVP