Excel Sales Data Formatting Cleanup

via Freelancer ·

Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted3 hours ago
I have an Excel workbook containing sales data that I need to plug straight into my reporting dashboards, but the file is full of formatting inconsistencies. Your job is to go through every sheet and standardise two things:

• Dates – everything must follow a single, clearly documented format across the entire file (e.g. YYYY-MM-DD).
• Currency values – all monetary figures need to display as the same currency symbol, use consistent thousand-separator rules, and carry two decimal places.

There are no duplicate-removal or missing-value exercises this time; the sole focus is on making the file presentation-ready. I’ll supply the spreadsheet and my preferred final styles. Once you’re done I want the cleaned .xlsx plus a short changelog so I can see exactly what was adjusted. Accuracy and quick turnaround are priorities, and I’m happy to answer any structural questions before you begin.
visual basic data processing data entry excel excel vba excel macros data visualization data analysis
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.