I will clean, format and fix your excel data with formulas and pivot tables

China

I speak English

ELV CAD engineer and Python developer

I'm Chen Yu, an engineer from Changsha, China with 25+ years in ELV / intelligent-building design. I have produced 30,000+ CAD drawings, worked with Grade-A design institutes, and prepared many BoQs a...
About this Gig

Messy spreadsheet? Duplicates, broken formulas, mixed formats, data spread across many sheets? I'll turn it into a clean, consistent, easy-to-use workbook.


I've used Excel daily for over 25 years as an engineer, building bills of quantities (BoQ), material lists and tender documents where every number has to be right.


What I can do:

  • Remove duplicates, fix blanks, trim spaces, standardize dates/numbers/text
  • - Split or merge columns, combine multiple sheets or files
  • - Formulas: VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, IF logic
  • - Pivot tables, summaries and simple charts
  • - Professional formatting, conditional formatting, data validation and drop-downs
  • - Convert PDF/CSV tables to Excel

You get an organized file, plus notes on what was changed. Please message me before ordering with a sample so I can confirm scope and time.


Platform:

Excel

Development technology:

Excel

Expertise:

Formatting

•

Pivot tables

•

Formulas

•

Functions

•

Cleaning