Free ebook
Free ebook: Excel Formulas Cheat Sheet
A printable cheat sheet covering the formulas you actually need — syntax, gotchas, and real examples. Read it online or grab the PDF.
Get the ebookCourse path
Turn formulas into a learning path
Our Excel Formulas & Functions course path strings public YouTube lessons into a structured route — preview, learn, repeat.
View course pathFormula builder
Pick what you're trying to do, fill in your cells, and get the exact formula — updated live as you type.
What it does
Choose the job you are trying to do — look a value up, sum with conditions, count matching rows, split text — then fill in which cells hold your data. The builder assembles the formula with the arguments in the right order and in the right places.
The problem it solves
Most Excel difficulty is not knowing that a function exists. It is remembering which argument comes first. A few of the ones that catch everybody:
SUMIF(range, criteria, sum_range)puts the range to test first, whileSUMIFS(sum_range, criteria_range1, criteria1, ...)puts the range to add first. Swapping them returns a number, not an error, which is what makes it dangerous.VLOOKUP's fourth argument defaults to approximate match when omitted, returning a plausible wrong value on unsorted data.INDEX(range, row, column)counts from the start of the range you gave it, not from column A.
Check these before you trust the output
A generated formula is a draft. Two things to verify every time:
- The ranges cover all your data. This is the most common error and the least visible — a sum that stops short reports a smaller number with complete confidence.
- Absolute references are locked where they need to be.Without
$signs, copying the formula down shifts the lookup range with it. Thereference converter helps if you are unsure which form you want.
Where to go deeper
Each function has a reference page with its full argument list, worked examples, and related functions —VLOOKUP,XLOOKUP,SUMIFS, andthe rest of the reference. For the lookup decision specifically,XLOOKUP vs INDEX/MATCHcovers which one suits your Excel version.
Privacy
Nothing leaves your browser. Cell references you type are not uploaded or stored anywhere.



