I will automate your excel reporting with power query

United Kingdom

I speak English, Hungarian, German

I build and fix the spreadsheets businesses actually run on

I build and fix the spreadsheets businesses actually run on. Five years in finance, accounts payable, then procurement analysis, means I've worked inside the messy reporting, supplier data, and recon...
About this Gig

I build Excel automation that does it in one click.

I spent five years in finance and procurement accounts payable, then procurement analysis before doing this. So I've been the person maintaining the broken workbook at month end. I know what actually goes wrong with supplier data, reconciliations and reporting, not just which formula to use.


What I do:

  • Power Query workflows that refresh instead of being rebuilt
  • Dynamic array formulas (XLOOKUP, FILTER, SORT, UNIQUE)
  • VBA macros and buttons for repetitive tasks
  • Cleaning and restructuring messy exports
  • Rebuilding inherited workbooks nobody understands any more


What you get:

A working file, the source code, and documentation written so your team can maintain it without me. I've built and delivered Excel training before, so I explain things properly rather than handing over something you're afraid to touch.


Before you order:

Message me your file or a description of the problem. I'll tell you honestly which package fits or if I'm not the right person for it.

Platform:

Excel

•

Power BI

•

Microsoft Office

Development technology:

VBA

•

Python

•

Power Query

Expertise:

Pivot tables

•

Formulas

•

Macros

•

Dashboard

•

Power Query