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

Criteria strings

COUNTIF-family criteria are text: ">10", "<>West", "app*". Comparisons against cells are built with &.

Very commonDifficulty 1150 · Proficient

In practice: Write the operator in quotes and join the value: ">"&A1. Wildcards * and ? match text.

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.