I will write or fix excel formulas, xlookup, and pivot tables

Singapore

I speak English

Excel and Google Sheets Data Specialist

I turn messy spreadsheets into clean, working tools. I build and fix Excel and Google Sheets files: data cleanup, formulas, payment and instalment trackers, overdue flags, KPI dashboards, weekly sales...
About this Gig

Need a formula written, fixed or explained? I will build it in your workbook so it calculates correctly and is easy to update later.


I work in Excel and Google Sheets. Typical requests include XLOOKUP and VLOOKUP, IF and nested IF, SUMIFS and COUNTIFS, INDEX/MATCH, text and date formulas, named ranges, data validation, conditional formatting and pivot tables.


How I work:

You send the file and tell me what the result should be

I write or repair the formulas and check them against your numbers

I leave short notes on how each formula works, so you can maintain the sheet


I will not replace a formula with a typed number. If something is broken, I will find the cause and fix it, and I will only rebuild the sheet if that is the better option.


Tell me how many formulas you need and whether you use Excel or Google Sheets, and I will recommend a package.

Platform:

Excel

•

Google Sheets

Development technology:

Excel

Expertise:

Fixing

•

Pivot tables

•

Formulas

•

Functions