Excel Formulas & Functions

Lookups, conditional logic, and the functions that replace manual work. Written for people who already use Excel daily and want the formula that actually fits the job.

What this covers

Lookups and conditional logic, plus the supporting functions: XLOOKUP, INDEX and MATCH, VLOOKUP and why to retire it, IFS and nested IF, SUMIFS and COUNTIFS, named ranges, goal seek, and dynamic dropdown lists.

Published guides

Excel formulas, and how to pick the right one for the jobThere are over 500 functions in Excel and you need about fifteen. This is the map — organised by what you are trying to do rather than alphabetically, which is how function lists usually fail you.
The Excel IFS function, and when a lookup table beats itIFS exists because nested IF statements become unreadable at about the third level. It fixes the readability problem — and introduces one trap worth knowing before you use it.
XLOOKUP vs INDEX MATCH — which one to use, and whenXLOOKUP is easier to write. INDEX MATCH works in every version of Excel. Neither is the right answer in every situation, and the deciding factor is usually not the one people argue about.

Prefer an instructor? These topics come out of our Office 365 courses. For a team, corporate training is scoped to your own files and systems.