Our Work
Please see here some real client projects mixed with things I’ve tinkered on for myself. If you’re here, chances are you’re interested in how messy data can be turned into something clearer, faster, and more useful.
Whatever your problem, I’ve probably worked on something similar before. If you’d like to see different examples or even set up a consultation seminar, just get in touch — I’m always happy to talk through ideas and show what’s possible.
Building a P&L Dashboard with Power Query + VBA
Profit & Loss dashboard built with Power Query + VBA to turn raw credit and sales data into clear monthly and quarterly reporting. Delivered KPIs, rep vs retailer insights, and automated refresh for accurate, time-saving performance tracking.
AI-Powered Risk Assessment in Excel: VBA + Claude API Integration
“A live demo of Excel connected to Claude AI for instant risk assessments. Powered by VBA and API integration, this proof-of-concept shows how AI can enhance everyday spreadsheets with real-time insights and automation.”
Excel P&L Calculator + Waterfall Chart
A practical Excel demo showing how to build a Profit & Loss calculator and visualise performance with a waterfall chart. Learn how raw numbers can be structured with formulas and turned into clear, insightful visuals for better decision-making.
Raw Data to P&L Dashboard in Excel
A demo showing how to turn raw credit and sales data into a clear Profit & Loss dashboard in Excel using Power Query and VBA. See how automation and data cleaning combine to deliver fast, accurate performance reporting.