Browse categories
Explore
Fiverr Pro
English
$
USD
I will clean, transform and automate excel data using power query
About this Gig
Do you spend too much time manually cleaning, combining or preparing Excel files for your reports?
I will clean, transform and automate your Excel data using Power Query, helping you reduce repetitive work and create a more reliable reporting process.
I can help with:
- Excel and CSV data cleaning
- Removing duplicates and inconsistencies
- Data formatting and validation
- Combining multiple files
- Power Query transformations
- Refreshable data preparation workflows
- KPI calculations and summary reports
- Excel reporting automation
For simple projects, I can prepare your data for accurate reporting and analysis.
For recurring or more complex processes, I can build a Power Query workflow that can be refreshed whenever new data arrives.
I have 9+ years of analytical experience working with data, reporting and process improvement, and I focus on creating solutions that are accurate, practical and easy to maintain.
Please contact me before ordering if you have a large dataset, multiple data sources or a complex reporting requirement.
Technology:
Excel
•
Python
FAQ
Can you work with large Excel or CSV files?
Yes. I can work with larger datasets, although the appropriate package depends on the number of rows, files and complexity of the transformations. Please contact me before ordering if you have a large or complex dataset.
Can you automate a recurring Excel reporting process?
Yes. I can use Power Query to create repeatable, refreshable workflows that reduce manual data preparation and reporting work.
Can you combine multiple Excel or CSV files?
Yes. I can combine and transform multiple files using Power Query, provided the files have a suitable structure.
Can you create dashboards or summary reports?
Yes. Dashboard and KPI reporting can be included in the Premium package or added as an extra. Please contact me if you need a more advanced Power BI dashboard.
Can you fix formulas or Excel errors?
Yes, I can help with straightforward Excel formulas and data-related errors as part of a data preparation or reporting project. For complex VBA, macros or standalone Excel application development, please contact me before ordering.
Can you work with confidential business data?
Yes. Please only provide the data necessary to complete the project and remove or anonymise sensitive personal information where possible. I treat client files and information as confidential.
