Master Excel from scratch. Learn key shortcuts, formulas, and functions essential for financial analysis and modeling.
Master basic math functions like SUM, AVERAGE, MIN, MAX, and ROUND functions.
Write a formula once and copy it correctly - absolute, relative and mixed references.
Master IF, AND, OR, and IFERROR functions for decision-making models.
Master VLOOKUP and HLOOKUP for finding data.
Learn the powerful combination of INDEX and MATCH.
Two-way lookups, two criteria joined into one key, and indexing a whole table at once.
Exact match by default, if_not_found instead of an IFERROR wrapper, and searching a log backwards.
SUMIFS, COUNTIFS and AVERAGEIFS - and the criteria that silently return zero.
TRIM, CLEAN, text splitting, text dates and duplicate flags - the export as it actually arrives.
Defined names, the name box, and why this engine is stricter about capitals than Excel.
CHOOSE, IF and INDEX driven by one switch cell - the assumption block Course 3 is built on.
A 3x3 terminal-value grid written by hand - one formula, two half-anchors, nine cells.
Master NPV, IRR, XNPV, and XIRR for investment analysis.
OFFSET for ranges that resize themselves, and array formulas.