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

Dynamic arrays and spilling

A formula that returns several values writes them into neighboring cells automatically; A1# refers to the whole spill.

Very commonDifficulty 1300 · Proficient

In practice: Keep the spill area clear to avoid #SPILL!. FILTER, UNIQUE, SORT, and SEQUENCE all spill.

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.