Planned sections (outcome-led):
- Financial Modelling & Analysis
- Power BI - dashboards, KPIs, drill-downs, narrative call-outs
- Data & Automation - SQL/Power Query pipelines, Python helpers, Excel workflows
- Clear Communication - IBCS-inspired charts, insight-first storytelling
Posts
-
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