I will clean messy data and build an automated excel dashboard with power query
Data Cleaning, Excel Dashboards and Reliable Reporting
About this Gig
Is your spreadsheet full of duplicates, broken date formats and numbers you cannot trust? I turn messy exports into clean, reliable data and clear reports.
I come from a financial data background, so accuracy matters to me. I build for the way real data actually behaves, including duplicates, inconsistent formats and blank fields, so your work holds up as your data grows. Before I start, I confirm exactly what you need and check your file for anything unusual.
What you get: clean, standardized data with duplicates removed and formats fixed, a summary or pivot analysis of the key numbers, an automated Excel or Power Query dashboard that refreshes when you add new data on the Premium package, and a short note explaining what I changed.
I work with Excel, Power Query, Google Sheets and SQL, on files from a few hundred rows to tens of thousands. Not sure which package fits?
Message me first and I will point you to the right one.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Power Query
•
Excel
•
VLOOKUP
Expertise:
Pivot tables
•
Formulas
•
Dashboard
•
Power Query
•
Cleaning
My Portfolio
FAQ
Will the dashboard break when my data changes?
No. I build with dynamic ranges and error handling, so it copes with new rows, blanks and irregular formats.
Can you work with my existing file?
Yes, please share it. Cleaning built around your real data works correctly the first time.
I am not technical, is that a problem?
Not at all. I include a plain language note, and Premium comes with a short walkthrough.
What file types do you accept?
Excel, CSV and Google Sheets.

