I will do excel data cleaning, excel dashboard and power query automation
AI Automation for Industrial and Engineering Documents
About this Gig
Messy exports, duplicate rows, mixed date formats, #N/A errors? I clean your Excel or Google Sheets data, turn it into a clear dashboard, and automate it so next month's file updates with one Refresh.
What I do:
- Data cleaning: remove duplicates, fix dates, numbers, text and formats
- Formulas that scale: XLOOKUP, LET, FILTER, dynamic arrays
- Power Query: combine files and clean new data automatically
- Excel or Power BI dashboards: KPIs, charts, slicers, targets
- Pivot tables and summary reports ready for management
Why clients choose me:
- Every change is listed, so you know exactly what was fixed
- Reusable query or formulas, not a one-time manual fix
- Engineer background: production, quality and maintenance KPIs (OEE, on-time delivery, downtime)
- Fast delivery and confidential handling of your files
How I work:
- Send a sample file (sensitive data can be removed). I confirm scope first.
- I clean, build and test.
- You get the file plus the query, formulas or dashboard.
FAQ
What should I send before ordering?
A sample of your file (sensitive columns can be removed) and a short note on the result you need. I reply with exact scope and price, usually within a few hours.
Can you automate this for future files?
Yes. With the Automated Report package I build Power Query steps, so when you paste or drop next month's export into the folder, one Refresh cleans it the same way.
Is my data kept confidential?
Yes. Your files are used only for your order, never shared, and deleted after delivery if you ask. You can also send anonymized data.

