I will clean and automate excel data with power query and power pivot
Microsoft Certified Excel Expert, Power Query and Dashboard Specialist
About this Gig
Still copying and cleaning the same Excel files every month? I will build a repeatable Power Query workflow so you can refresh agreed data preparation steps instead of repeating them manually.
I can remove duplicates, fix data types, split and merge columns, append similar files, merge tables, unpivot data and prepare clean outputs. Where included in your package, I can build Power Pivot relationships, measures and PivotTable reporting.
You receive an editable Excel workbook, the agreed transformation workflow and clear refresh instructions. Please send sample source files, your Excel version, the required output and how new data arrives before ordering. File layout and complexity determine the scope.
I am a Microsoft Certified Excel Expert and corporate trainer with practical business reporting experience. New sources, changed layouts and extra features are separate scope changes.
My Portfolio
FAQ
What should I send before ordering?
Send sample source files, your Excel version, the expected output and how new data arrives. Remove unnecessary personal data from samples. I will confirm the files, transformations and reporting features included before work starts.
