Microsoft 365 (Excel & VBA) case studies
The Office stack done properly, with Excel & VBA as the deep specialism, plus Office Scripts, Access and SharePoint.
Sixty monthly tabs, rebuilt as one solar performance report
A UK solar company's site reports came out of a workbook that had grown by accretion since 2022. Rebuilt on a single daily-data table with Power Query and a Power Pivot data model, branded, exportable to PDF in one click, then extended with safety, security, spares and maintenance tracking.
Read the case studyA pricing job that was nearly a full-time role, down to an hour or two
A US food distributor rebuilt customer pricing sheets by hand from two suppliers' cost files, in whichever layout each customer expected. An Excel engine with Power Query imports and a one-click VBA refresh now does it in an hour or two.
Read the case studyA 3–4 day compile job, down to 15 minutes
A US team spent three to four days compiling a recurring process by hand. A VBA automation now does it in about fifteen minutes.
Read the case studyThe Mac macro job 8 out of 10 experts turned down
Automating one process across 69 workbooks, on a Mac, where most VBA specialists would not go. The client asked around: most said it could not be done.
Read the case study