Write Excel formulas that are easy to understand and don't consume lots of memory.

Update once, see everything. Excel dashboard, paste new transactions into tables, refresh pivots & optional Power Query ...