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.

Tips & shortcuts

Each one has its own page — what it does, the keystrokes, and a before/after you can play.

Type one example and Excel fills the rest of the column by pattern.

Total the cells above or to the left in a single keystroke.

Copy the cell above (or to the left) down a whole selection.

Stamp a static date that won't change tomorrow.

Drop the formulas and formatting — keep just the numbers.

Cycle a reference through A1 → $A$1 → A$1 → $A1 while editing.

Name a cell or range so formulas read like English.

Turn a range into a structured Table that grows and reads in plain English.

Add or remove the filter dropdowns on your header row.

Select only the blanks, formulas, or constants in one move.

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