Formulas & Functions
5 tutorials written here on formulas & functions, plus 213 public formulas & functions videos from other channels, filed by level and subtopic.
All articlesOriginal tutorials
5Excel Tables vs named ranges: which should you use?
A practical comparison of Excel Tables and named ranges — when each one is the right tool and when to use both together.
Excel vs Google Sheets formulas: what actually translates?
A practical comparison of Excel and Google Sheets formulas — which functions match exactly, which don't exist in the other tool, and what breaks when you move a file between them.
SUMIFS vs SUMPRODUCT: when each formula is the right choice
A practical comparison of SUMIFS and SUMPRODUCT for conditional aggregation — when SUMIFS is simpler, when SUMPRODUCT is more flexible, and when neither is enough.
XLOOKUP vs INDEX/MATCH: which lookup formula should you use?
A practical comparison of XLOOKUP and INDEX/MATCH — what each can do, where they differ, and when the older formula is still the better choice.
How to use VLOOKUP in Excel (with examples)
A plain-English guide to VLOOKUP: the syntax, a worked example, the most common errors, and when to use XLOOKUP instead.
Video resources
Every formulas & functions video we have filed, published by other channels. All 213 are listed — nothing hidden behind a cap.
Sources we reference — not partners
26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
- Chandoo (opens in a new tab)
ExcelJet (opens in a new tab)- MrExcel (opens in a new tab)
- Contextures (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)- Simon Sez IT (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)- Edureka (opens in a new tab)
Course platforms
