Clean Up Excel Sales Data
Publicada el 2026-08-02
Descripción de la oferta
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.
Skills
Fuente original: freelancer