A free, structured Excel course built from the function library. Work through the levels in order — each function page has syntax, examples, common errors and a power combo. New functions are added regularly.
🟢 Beginner (30 functions)
Start here: the functions every Excel user needs for totals, counts, text and dates.
Date & Time
- DATE — Build a Date From Year, Month and Day
- TODAY — Current Date That Updates Every Day
- WEEKDAY — Day of the Week as a Number
Logical
- AND — TRUE Only When All Conditions Are Met
- IF — Make Decisions in a Formula
- IFERROR — Replace Errors With Something Friendly
- OR — TRUE When Any Condition Is Met
Math
- ABS — Absolute Value (Remove the Minus Sign)
- INT — Whole Number Part (Rounds Down)
- RANDBETWEEN — Random Whole Numbers for Test Data
- ROUND — Round to Any Number of Digits
- ROUNDDOWN — Always Round Towards Zero
- ROUNDUP — Always Round Away From Zero
- SUM — Add Numbers, Ranges and Whole Columns
Statistical
- AVERAGE — Arithmetic Mean of Numbers
- COUNT — Count Cells That Contain Numbers
- COUNTA — Count Non-Empty Cells
- COUNTBLANK — Count Empty Cells
- MAX — Largest Value in a Range
- MEDIAN — The Middle Value
- MIN — Smallest Value in a Range
Text
- CONCAT — Join Text From Cells and Ranges
- LEFT — Take Characters From the Start of Text
- LEN — Count Characters in Text
- MID — Extract Text From the Middle
- PROPER — Capitalise Each Word
- RIGHT — Take Characters From the End of Text
- SUBSTITUTE — Replace Specific Text
- TEXT — Format Numbers and Dates as Text
- TRIM — Remove Extra Spaces
🟡 Intermediate (37 functions)
Lookups, conditional logic, dynamic arrays and data cleaning — the skills that save hours every week.
Date & Time
- DATEDIF — Age and Tenure in Years, Months, Days
- EDATE — Add or Subtract Months From a Date
- EOMONTH — Last Day of a Month
- NETWORKDAYS — Working Days Between Two Dates
- WORKDAY — A Date N Working Days Away
- YEARFRAC — Fraction of a Year Between Dates
Financial
- PMT — Loan EMI in One Formula
Logical
- IFNA — Handle “Not Found” Only
- IFS — Several Conditions Without Nested IFs
- SWITCH — Match One Value Against a List
Lookup
- CHOOSE — Pick From a List by Number
- HLOOKUP — Look Up Across the Top Row of a Table
- INDEX — Return the Value at a Row and Column Position
- MATCH — Find the Position of a Value
- TRANSPOSE — Flip Rows and Columns
- VLOOKUP — Look Up a Value in the First Column of a Table
- XLOOKUP — The Modern Lookup That Replaces VLOOKUP
- XMATCH — MATCH With Better Defaults
Math
- MOD — Remainder After Division
- MROUND — Round to the Nearest Multiple
- SUBTOTAL — Totals That Respect Filters
- SUMIF — Sum Values That Meet One Condition
- SUMIFS — Sum With Multiple Conditions
- SUMPRODUCT — Multiply Arrays and Add the Results
Statistical
- AVERAGEIFS — Average With Multiple Conditions
- COUNTIF — Count Cells That Meet a Condition
- COUNTIFS — Count With Multiple Conditions
- LARGE — The k-th Largest Value (Top 3, Top 10)
- MAXIFS — Largest Value Meeting Conditions
- MINIFS — Smallest Value Meeting Conditions
- RANK.EQ — Rank a Number in a List
- SMALL — The k-th Smallest Value
Text
- FIND — Position of Text (Case-Sensitive)
- REPLACE — Replace Characters by Position
- SEARCH — Position of Text (Any Case, Wildcards)
- TEXTJOIN — Join Text With a Separator, Skipping Blanks
- VALUE — Convert Text to a Number
🔴 Expert (14 functions)
Advanced array logic, LAMBDA, financial and statistical analysis, and formula combinations experts use.
Dynamic Array
- FILTER — Return Every Row That Matches
- SEQUENCE — Generate a List of Numbers or Dates
- SORT — Sort Data With a Formula
- SORTBY — Sort by Another Column
- TAKE — First or Last N Rows of a Range
- UNIQUE — Distinct List Without Remove Duplicates
Financial
Logical
Lookup
Math
- AGGREGATE — SUBTOTAL That Can Ignore Errors
Text
- TEXTSPLIT — Split Text Into Cells
Keep going
Put functions together in formula combos, automate with the free VBA course, and practise in the Formula Lab.