What you’ll find here
Practical finance work, shown in the open. Mostly three things:
- Articles. Mostly short, reproducible techniques for Excel, financial modelling, Finance Automation, SQL and Power BI, with a longer deep-dive when a topic earns it.
- The Workshop. Workflows and decision tools I am building, documented as they evolve, bumps and all.
- Decision Tools. Interactive tools you can open and poke, not screenshots of them.
No theory for its own sake. If it is here, it is because it solved a real problem.
Posts
-
Don't Replace Your Finance Model. Give It Wings.
The wings are a workflow. Here's what happened when I wrapped a workflow around a finance model I already trusted, the three-way split that keeps it safe, and where it's up to now. -
Finance Doesn't Need Better AI Prompts. It Needs Finance Workflows.
Finance needs numbers it can reproduce and evidence, not answers taken on trust. Here's why deliberately designed AI workflows matter for finance. -
The macro workbook that opens every time Excel does
PERSONAL.XLSB makes your macros available in every workbook, every session. Here is how to create it, find it and ensure you never lose it. -
Two seconds to a clickable map of your entire workbook
A macro that generates a contents page with tab numbers, hyperlinked names and visibility status. One run, instant navigation, works on any workbook. -
How long does your model actually take to recalculate?
Two macros that time your Excel recalculation and a QC baseline approach that tells you when your model has started to slow down. -
Excel finally did this and Finance didn't notice
The status bar has always shown you Sum, Count and Average. What most people don't know is that you can now copy those values directly. No formula required. -
Excel's 56 ColorIndex
A VBA macro that generates Excel's complete 56-colour index reference in seconds with hex codes and RGB values you can copy paste. -
The #SPILL! error you didn't see
A single formula on your QC tab that catches blocked spill ranges before they cause silent errors downstream. -
Dynamic ranges in financial models
How to build formula ranges that automatically expand with your dataset, without whole-column references, tables or the resource overhead that comes with them. -
Office Shortcuts For Financial Commentary
3 Minute Read
subscribe via RSS