Excel like a finance pro.

The modern lookup — find a value and return another, in any direction, with a clean not-found fallback.

The everyday lookup — find a value in the first column and return one to its right.

The classic two-step lookup — works left or right and across two dimensions.

The two-way lookup — cross a row label and a column label to pull one cell.

The horizontal lookup — find a value in the top row and return one below it.

Return different results by condition — IFS avoids nested IFs.

Turn errors into a clean fallback so a model doesn't break.

Match one value against a list of cases — cleaner than a stack of nested IFs.

Sum amounts that match several conditions — the workhorse of P&L roll-ups.

Count rows that meet multiple conditions.

Average the values that match several conditions — the mean sibling of SUMIFS.

The smallest or largest value that meets your conditions.

Multiply arrays element-by-element, then sum — weighted averages and conditional math.

Aggregate only the visible (filtered) rows, ignoring other subtotals.

Round a number to a set number of digits — control the pennies before they compound.

The last day of a month N months out — clean period-end dates.

The same day, N months out — clean anniversary, renewal, and due dates.

Format a number or date as text — for labels and headers.

Return the rows that meet a condition as a live, spilling result.

Spill a distinct list — perfect for dropdowns and clean lists.

Spill a range into sorted order — live, with no manual re-sort.

NPV and IRR for cash flows on real, irregular dates.

The level payment on a loan, per period.