I will clean, consolidate and automate your excel data with power query
Controller, Excel Financial Models, Budgets and Cost Analysis
About this Gig
Tired of copying and pasting the same reports every week? I'm a Controller with about 8 years in industry in Brazil, and cleaning and consolidating messy data was part of my routine: ERP exports, bank statements and reports from different systems.
What I do:
- Clean messy files: merged headers, subtotals, blank rows, dates and numbers stored as text
- Combine many files or sheets into one table, one row per record
- Build Power Query steps you can refresh with one click when new data arrives
- Summary reports with pivot tables or charts
- Checks that prove the clean totals match each source file
What you get:
- The editable Excel file, with the Power Query steps visible
- A check tab: source total vs. clean total, the difference must be zero
- Short written notes on how to refresh
Please message me before ordering and send a sample of your files (you can remove sensitive data). I'll confirm the scope and the right package.
I work in writing, in English (with AI support) or Portuguese (native).
Technology:
Excel
•
Google Sheets
Expertise:
Data manipulation
•
Data validation
•
ETL
•
Transformation
FAQ
Do I need Power Query installed?
Power Query is built into Excel for Windows (Excel 2016 and later, including Microsoft 365). Tell me your Excel version and operating system before ordering and I'll confirm the refresh works on your setup.
Can you work in Google Sheets?
Yes, for cleaning and consolidation with formulas. The one-click Power Query refresh is an Excel feature, so it is only available in Excel.
What if my source files change their layout?
Power Query steps depend on column names. If a source changes its layout, the steps may need an update. My notes explain what to check.
Is my data kept confidential?
Yes. Your files are used only for your project and are never shared or shown in my portfolio.

