Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

Excel concept

Boolean math and SUMPRODUCT

Comparisons return TRUE/FALSE; multiplying or double-negating turns them into 1/0 so they can be summed.

CommonDifficulty 1450 · Advanced

In practice: Use SUMPRODUCT((cond1)*(cond2)*values) when SUMIFS cannot express the condition, like comparing two columns.

Learn the moves here — or let Wauvel run them on your numbers.

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.