I will automate your excel and google sheets with dashboards

China

I speak Chinese, English

Data Analysis, Python Scraping and SPSS Statistics

Hi! I provide practical data work with fast turnaround: - Python web scraping and data collection (public data only) - Data cleaning and formatting in Excel / Python / R - Statistical analysis with S...
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