← The library
Excel concept
Calculation and performance
Volatile functions, whole-column array math, and too many lookups slow recalculation.
CommonDifficulty 1586 · Advanced
The shape of it
- In practice
Avoid OFFSET and INDIRECT, limit ranges, use tables, and switch to manual calculation while building.
Related
Learn the moves here — or let Wauvel run them on your numbers.
$99/mo, everything included. Free for 14 days, no card.
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.