I will fix your excel formulas and spreadsheet errors

China

I speak Chinese, English

Excel and Data Processing Specialist

I specialize in Excel and data processing: fixing broken formulas, repairing messy spreadsheets, cleaning and restructuring messy data, and building clear summary reports. I also do website testing an...
About this Gig
A broken formula or a spreadsheet that refuses to add up can stall your whole day. Send me the file and I will find the problem, fix it, and hand back a workbook that calculates the way it should. What I work on: - Formula errors: #REF!, #DIV/0!, #N/A, #VALUE!, #NAME? and circular reference warnings - VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIF/SUMIFS, COUNTIF, IF logic, text and date functions - Pivot tables that show wrong totals or will not refresh - Data cleaning: duplicates, inconsistent formats, numbers stored as text - Google Sheets equivalents of the above How it works: you send the file and tell me what the correct result should look like. I diagnose the cause, fix the formula or structure, then check the recalculated results before delivery. You get back the working file plus a short note explaining what was changed, so the same issue is easier to avoid next time. This gig covers one agreed issue in one workbook. If your file needs broader work, message me first and we can scope it before you order.

Platform:

Excel

Google Sheets

Microsoft Office

Development technology:

VBA

Power Query

Excel

Expertise:

Fixing

Pivot tables

Formulas

Functions

Cleaning