I will fix excel formulas, build pivot tables and clean dashboards

Indonesia

I speak English, Indonesian

Python Screeners, LaTeX, Pitch Decks and Academic Posters

I build clean, working deliverables for traders, students and small teams: Python stock screeners and backtests, LaTeX papers and theses formatted to your template, PowerPoint pitch decks, and academi...
About this Gig

Your spreadsheet should answer questions, not create them. Send me the file and I will fix what is broken and turn it into something you can actually read.

What I do

  • Fix broken formulas and errors: #REF!, #N/A, #VALUE!, circular references
  • Rewrite slow or messy formulas: VLOOKUP, XLOOKUP, INDEX MATCH, SUMIFS, array formulas
  • Clean messy data: duplicates, mixed date formats, stray spaces, text stored as numbers
  • Build pivot tables and summary reports that update when you paste new data
  • Build one-page dashboards with charts, slicers and conditional formatting
  • Automate repetitive work with simple macros

How it works

  • Send the file and tell me what the sheet should answer
  • I confirm the price and delivery time before starting
  • You get the working file plus a short note explaining what changed

Works with Excel (.xlsx, .xlsm), Google Sheets and CSV. Your data stays private and I delete it after delivery on request.

Not sure which package fits? Message me with the file size and what you need, and I will tell you honestly.

Platform:

Excel

•

Google Sheets

Development technology:

VBA

•

Excel

•

VLOOKUP

Expertise:

Fixing

•

Pivot tables

•

Formulas

•

Dashboard

•

Cleaning

My Portfolio