I will automate your excel reports with power query
About this Gig
I will automate one repetitive Excel reporting process using Excel and Power Query.
This Gig is suitable when you repeatedly copy files, clean columns, combine tables, repair queries, or rebuild the same report every week or month
I can help with:
- repeatable data cleaning
- combining recurring files or worksheets
- reusable Power Query transformations
- refreshable output tables
- practical report preparation
- error handling and handover notes
- one focused Excel or Power Query fix
The package limits define the maximum number of source files, source tables, and transformation steps. You receive a tested workbook and documentation appropriate to the selected package.
Please provide anonymized sample files, the desired output, your Excel version, and the current manual process. Do not upload personal data, health data, payment information, passwords, or confidential production records.
Power BI, extensive VBA, and large data-platform projects require a separate scope.
Business type:
Solopreneurs
•
SMBs
Industry:
Business services & consulting
•
E-Commerce
•
Software
Service type:
Integrations
•
Workflow optimization
•
Process mapping
FAQ
Do you work specifically with Power Query?
Yes. This Gig focuses on repeatable data-cleaning, combining, and reporting workflows using Excel Power Query.
Can you combine recurring monthly files?
Yes, when the files have a reasonably consistent structure and fit the selected package limits. Provide representative anonymized samples.
Do you build VBA macros?
Large VBA applications are not included. Basic may cover one small existing Excel issue, but the Gig is positioned around Excel and Power Query.
Which Excel version do I need?
Please state whether you use Microsoft 365 or a perpetual desktop version and whether the workbook runs on Windows or macOS. Feature availability can differ.
