I will automate your excel and google sheets with dashboards
Data Analysis, Python Scraping and SPSS Statistics
About this Gig
Stop spending your evenings copying and pasting between spreadsheets.
Send me your messy file. I'll send back something that works clean data, working formulas, and a dashboard that updates itself.
WHAT I CAN DO
Clean and standardize thousands of rows (dedupe, merge, split, fix broken formats)
Write formulas you can actually understand (VLOOKUP/XLOOKUP/SUMIFS/INDEX-MATCH)
Consolidate multiple sheets into one that auto-updates
Build dashboards with charts that refresh from your data
Automate repetitive steps with macros or Apps Script
Google Sheets and Excel both
WHAT YOU GET
The finished working file
A short written note explaining what I changed and how to use it
Follow-up tweaks free of charge
I always confirm the exact outcome you want before starting, so there are no surprises.
Message me first if your file is large or the task is unusual I'll tell you honestly whether I can do it and what it costs.
Platform:
Excel
•
Google Sheets
•
VBA
Development technology:
VBA
•
Google Apps Script
•
VLOOKUP
Expertise:
Formatting
•
Pivot tables
•
Macros
•
Dashboard
•
Cleaning
FAQ
What file formats do you accept?
Excel (.xlsx), Google Sheets, CSV, TSV, and most database exports. If your file is in another format, message me before ordering and I will tell you straight away whether I can work with it.
Will I be able to edit the formulas myself after delivery?
Yes. Formulas are delivered unlocked and explained in plain English, so you can change ranges or add rows without breaking anything. If anything is unclear, just message me and I will walk you through it.
Can I send a sample instead of my real data?
If your data is sensitive, send a sample with the same structure (5-10 rows) and I will build the logic on it first. For the final deliverable I need the real file - everything you send is deleted after delivery.
Can you connect my sheet to Zapier, an API or a database?
No. I do not build API integrations or no-code automations. I focus on everything that lives inside Excel and Google Sheets: formulas, macros, Apps Script and dashboards.

