Excel Sales Data Cleanup
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I have an Excel workbook packed with sales data and the dates are all over the place—mixed regional settings, text strings, even serial numbers. I need every date field located and converted to a single, consistent format so my reports and pivot tables stop breaking. No duplicate removal or spelling fixes are required right now; accurate, uniform dates are the only priority, though you’re welcome to flag any glaring issues you notice.
Deliverables
• My original workbook returned with every date column unified to one clear format (let me know which format you’ll apply before you begin).
• A brief change log noting which sheets and columns you touched so I can audit quickly.
Please stick to tools native to Microsoft Excel 2016+—Power Query, formulas, or a lightweight VBA routine are all fine, as long as the file is macro-free when you hand it back. A fast turnaround is appreciated; let me know your expected completion time when you respond.
Deliverables
• My original workbook returned with every date column unified to one clear format (let me know which format you’ll apply before you begin).
• A brief change log noting which sheets and columns you touched so I can audit quickly.
Please stick to tools native to Microsoft Excel 2016+—Power Query, formulas, or a lightweight VBA routine are all fine, as long as the file is macro-free when you hand it back. A fast turnaround is appreciated; let me know your expected completion time when you respond.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.