I will automate excel data cleaning and reports using power query
Excel and Power Query Expert
About this Gig
Please message me before placing an order if your project is complex or involves multiple files.
Tired of manually cleaning and preparing the same Excel data again and again?
I will use Microsoft Excel Power Query to clean, transform, combine and automate your data workflows.
What I can help with:
Clean and transform raw Excel data
Remove duplicates and unwanted records
Standardize dates, text and numbers
Merge multiple Excel/CSV files
Append multiple datasets
Split and combine columns
Reshape and organize data
Create refreshable Power Query workflows
Automate recurring data preparation
Prepare clean data for reporting
My goal is to reduce repetitive manual work and give you a clean, organized and refreshable Excel workflow.
I work with Excel and CSV files and can customize the solution according to your requirements.
For large datasets, multiple files or complex automation, please contact me first for a custom offer.
Technology:
Excel
My Portfolio
FAQ
Can you combine multiple Excel files?
Yes, I can merge or append multiple Excel/CSV files using Power Query.
Can you remove duplicates?
Yes, duplicate records can be identified and removed as part of the cleaning process.
Can you create a refreshable workflow?
Yes. I can create Power Query workflows that can be refreshed when new data is added.
Can you automate recurring reports?
Yes, depending on the structure of your data and report.
What do you need from me?
Your Excel/CSV files, requirements and an example of the desired output if available.
Do you work with large datasets?
Yes. Contact me first with the approximate row count and number of files.

