Browse categories
Explore
Fiverr Pro
English
$
USD
I will build an automated excel summary sheet with live formulas
Data Cleaning and Excel Automation Specialist
I turn messy, unusable spreadsheets into clean data you can actually work with.
Exports that won't import. Duplicate rows. Phone numbers in six formats. Prices stored as text so nothing adds up. Date...
About this Gig
TIRED OF REBUILDING THE SAME REPORT EVERY MONTH?
- Retyping totals into a summary sheet
- Numbers that go stale the moment data changes
- Copy-pasting into a pivot table again and again
- A report only you know how to update
- Formulas that break when a row is added
I build sheets that update themselves.
WHAT YOU GET
- A summary tab calculating your totals with live formulas
- Breakdowns by category, region, month or whatever you track
- SUMIFS, INDEX/MATCH and IFERROR - no fragile hardcoded numbers
- Charts that redraw when the data changes
- A short written guide so anyone can maintain it
BUILT TO SURVIVE YOU
Every figure traces back to a formula, not a typed value. Paste next month's
data in and the whole report recalculates. Nothing to redo.
I ALSO DO
- Cleaning and deduplicating messy Excel or CSV files
- PDF and scanned documents into structured spreadsheets
BEFORE YOU ORDER
Send me your data and tell me what you need to see. I'll tell you honestly
what is possible and which package fits.
Files kept confidential and deleted after delivery on request.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Excel
•
DAX
Expertise:
Formulas
•
Functions
•
Dashboard
•
Cleaning
My Portfolio
FAQ
Will it work in Google Sheets as well as Excel?
Yes. Tell me which you use before I start and I'll build it natively for that platform, so nothing breaks in translation.
What happens when I add new data next month?
Paste it into the data sheet and every total, breakdown and chart recalculates by itself. That is the whole point - you never rebuild it.
My data is messy. Can you fix that too?
Yes, and I usually have to. I clean and standardise it first so the formulas work reliably, and I tell you exactly what I changed.
Can you match our existing report layout?
Send me a screenshot or the current file and I'll rebuild it in the same shape, with live formulas underneath instead of typed numbers.
Will I be able to maintain it after you hand it over?
Yes. Premium includes a short written guide, and I keep formulas standard - SUMIFS, INDEX/MATCH - so any Excel user can follow them.
Are my figures kept confidential?
Yes. I don't share, resell or reuse client data, and I permanently delete your files after delivery on request.
