Excel Advanced Formulas

This course teaches anyone who lives in spreadsheets to replace fragile, hard-coded formulas with robust ones that survive edits, scale to thousands of rows, and update themselves. You will build exact and approximate lookups with XLOOKUP, recreate them with INDEX/MATCH for older Excel, wrap logic in IF, IFS, AND, OR, and IFERROR, run weighted averages and multi-condition counts with SUMPRODUCT, and assemble live reports with FILTER, SORT, SORTBY, UNIQUE, and SEQUENCE. Each lesson works from a concrete dataset such as a sales export or price list, shows the exact formula, and explains the gotchas so your spreadsheets stop breaking.