Clean Up Excel Sales Data
Budget: £20 – £250 GBP
I have an Excel workbook that has grown messy after months of manual entries. I need a sharp-eyed Excel specialist to bring it back into shape.
Here’s exactly what I’m after:
• Fix every data-entry error you spot in the customer details, sales figures, and product sheets.
• Replace outdated customer, product, and pricing information with the new data set I’ll provide.
• Audit all existing formulas—SUMIF/S, VLOOKUP/XLOOKUP, pivots, percentages—and correct anything that is returning the wrong results or referencing the wrong ranges.
Acceptance criteria
The file comes back with:
1. No broken formulas or #ERROR values.
2. Customer, product, and sales tabs perfectly aligned with the master lists I supply (no duplicates, no stale rows).
3. A brief changelog sheet summarising what you corrected or replaced so I can track the updates.
If you’re quick with data cleansing and know your way around advanced Excel functions, this will be a straightforward project.
Here’s exactly what I’m after:
• Fix every data-entry error you spot in the customer details, sales figures, and product sheets.
• Replace outdated customer, product, and pricing information with the new data set I’ll provide.
• Audit all existing formulas—SUMIF/S, VLOOKUP/XLOOKUP, pivots, percentages—and correct anything that is returning the wrong results or referencing the wrong ranges.
Acceptance criteria
The file comes back with:
1. No broken formulas or #ERROR values.
2. Customer, product, and sales tabs perfectly aligned with the master lists I supply (no duplicates, no stale rows).
3. A brief changelog sheet summarising what you corrected or replaced so I can track the updates.
If you’re quick with data cleansing and know your way around advanced Excel functions, this will be a straightforward project.
Related categories:
Copywriting
Proofreading
PDF
Word
Microsoft
Word Processing
Writing
Google Sheets
Data Management