Excel/VBA Development
Custom Excel tools, VBA automation, and Access/SQL databases for businesses that need their spreadsheets to do more. 19 years of building practical tools that solve real problems — not theoretical best-practice advice, working solutions you can use right away.
What We Build
Process Automation Tools
Data aggregation, reporting pipelines, commission and fee calculators, budget and reporting packages — any repeatable business process where Excel is already the centre of gravity. We typically cut prep time by 75% or more.
Dashboards & Reporting
Dynamic operations, finance, and sales dashboards. Interactive, presentation-ready, and connected to your actual data sources. Replace hours of manual assembly with a one-click refresh.
AI-Enhanced Excel Tools
Extending existing Excel/VBA tools with modern AI capabilities — document extraction, intelligent categorization, natural-language queries against spreadsheet data. The same Excel interface your team uses, with AI working behind it.
Visual Basic for Applications (VBA) / Macro Development / Power Automate
Custom VBA code written to best-practice standards: documented, error-handled, modular, and digitally signable. We fix and enhance existing VBA code too — if the original developer is gone, we can take over.
Database Design (Access / SQL Server)
When Excel stops being the right tool, we build Access or SQL Server backends. Often paired with an Excel or Access front-end so your team keeps using the interface they know.
Financial Modelling
Commission calculators, pricing models, scenario analysis, P&L rollups, forecasting. Built to be auditable and defensible — not a tangle of nested IF statements no one can follow.
Spreadsheet Auditing
Independent review of business-critical spreadsheets to find errors, fragile formulas, broken links, and risk. We've presented at EuSpRIG (the European Spreadsheet Risks Interest Group) on this topic.
Tool Support & Takeover
Ongoing support for Excel/VBA tools we didn't build — tools built in-house or by developers who've moved on. On a retainer basis we'll learn and maintain them as-is, or migrate them to our standards and take full ownership. Predictable cost, defined response times, no scramble when something breaks.
How We Work
Direct access to the senior consultant who understands your problem, writes the code, and stands behind it. No junior handoffs, no project managers translating between you and the developer.
We start by understanding what you actually need — which often isn't what you thought you needed when you picked up the phone. Then we build it, iterate with you, and stay available after delivery for the questions that come up once people start using the tool.
Remote collaboration is our default. We work with clients worldwide and have delivered projects across Canada, USA and to clients in Asia and Europe.
Technology
- check_circleMicrosoft Excel (2010 through Microsoft 365)
- check_circleVBA / Excel macros — best-practice, documented, digitally signable
- check_circleMicrosoft Access, SQL Server, PostgreSQL
- check_circlePower Query, Power Pivot, Power Automate, dynamic array formulas
- check_circlePython where it's the better tool (data pipelines, ML, AI integration)
Industries We've Worked In
We are industry-agnostic — our value is in Excel, database, and automation expertise, not in deep vertical knowledge. We've delivered projects for:
Got an Excel problem?
Describe what you're trying to do — even if you don't know exactly how it should work. We'll help figure out the right approach. Or see examples of what we've built for other clients.