I will fix or automate your excel spreadsheet, formulas and pivot tables
About this Gig
Send me the spreadsheet that's slowing you down and I'll fix it, fast.
I'm a data scientist and Imperial College London MSc student. I work in Excel, Google Sheets, Power Query and Python every day.
What I can do:
- Fix broken formulas and #N/A / #REF! errors
- Write XLOOKUP, SUMIFS, INDEX-MATCH, IF and date formulas
- Clean messy data: duplicates, spacing, inconsistent names and dates
- Build pivot tables, charts and summary sheets
- Automate repeat work with Power Query or macros so it takes one click next time
You get your file back with a short note explaining what changed, so you can maintain it yourself.
To start, send the file (or a copy with sensitive data removed) and tell me what it should do. Not sure which package fits? Message me first.
Platform:
Excel
•
Google Sheets
Development technology:
Power Query
•
Excel
Expertise:
Formatting
•
Fixing
•
Pivot tables
•
Formulas
•
Functions
My Portfolio
FAQ
Can you work in Google Sheets?
Yes. Share the sheet with edit access or send an export, and I'll work in whichever you prefer.
Is my data safe?
I only use your file for your order and delete my copy after delivery. A copy with sensitive data removed works fine too.
Will you explain what you changed?
Yes. Every delivery includes short notes on what each formula or step does, so you can maintain it yourself.
