I will automate your excel or google sheets with formulas and scripts
About this Gig
Spending hours copying data, fixing broken formulas or making the same report every week? I will automate your Excel or Google Sheets so the work is done in one click.
What I can do:
- Fix broken formulas and errors (#REF, #N/A, wrong totals)
- Write formulas: VLOOKUP, XLOOKUP, INDEX MATCH, QUERY, FILTER, ARRAYFORMULA
- Excel macros (VBA) and Google Apps Script automation
- Import data from other sheets, files, forms or websites
- Clean and organize messy data, remove duplicates
- Simple dashboards, charts and pivot tables
- Python scripts for big files and repeating tasks
What you get:
- A working file or sheet, tested on your data
- Short notes on how everything works
- Free fixes within the agreed scope
Please message me before ordering and send a sample of your file (you can remove private data). I will reply fast and confirm the price.
Platform:
Excel
•
Google Sheets
•
VBA
Development technology:
VBA
•
Google Apps Script
•
Python
Expertise:
Fixing
•
Formulas
•
Macros
•
Dashboard
•
Cleaning
