I will automate your excel reporting with power query
I build and fix the spreadsheets businesses actually run on
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

