Every Excel function on this site, grouped the way you think about them. Pick a family to see each function with a plain-English explanation, a worked example and a practice file.
Statistical functions147 functionsAverages, spread, ranks, forecasting and probability distributions — everything for summarising and testing data.Math & trig functions80 functionsSums, rounding, powers, logs and trigonometry — the arithmetic that most other formulas are built on.Text functions52 functionsSplit, join, clean, search and reshape text — names, codes, addresses and imported data.Financial functions56 functionsLoans, EMIs, SIP returns, NPV, IRR, depreciation and bond maths, with Indian examples.Lookup & reference functions28 functionsXLOOKUP, INDEX/MATCH and friends — find values, pull data across sheets and build dynamic ranges.Logical functions20 functionsIF, IFS, AND, OR, SWITCH and LET — decisions and conditions inside formulas.Date & time functions25 functionsWorkdays, due dates, ages, financial years and time calculations.Dynamic array functions20 functionsFILTER, SORT, UNIQUE, SEQUENCE and the new spill functions that return whole tables.Information functions21 functionsCheck what is in a cell — blanks, errors, numbers, text — and make formulas robust.Engineering functions30 functionsNumber-base conversion, bit operations and engineering units.Complex number functions26 functionsWork with complex numbers: arithmetic, powers, roots and trigonometry.Database & cube functions16 functionsD-functions for criteria-based summaries and CUBE functions for Power Pivot models.