Excel Data Cleaning & Reporting
Budget: ₹12,500 – ₹37,500 INR
I have several large, mainly numerical datasets that first need meticulous data entry and thorough cleaning. Once everything is error-free and consistently structured, I want the data organised so that I can run quick analyses and share concise insights with my team.
Your first job will be to standardise all incoming rows and columns, weed out duplicates or obvious inaccuracies, and make sure every figure is in its correct place. After that, you’ll apply essential SUM formulas so totals reconcile across the entire file. If this stage goes smoothly, we can expand into more advanced logic such as IF statements, VLOOKUP/XLOOKUP, and automated dashboards, but the immediate focus is clean, accurate data.
When the sheets are tidy, I’ll need you to use native Excel tools—sorting, custom filters, and pivot tables—to shape the information into a clear, well-formatted report that’s ready for presentation. A polished layout with headings, number formatting, and intuitive slicers is a must because stakeholders will be looking at these files directly.
Deliverables I expect:
• A master worksheet with all numerical data correctly entered, de-duplicated, and validated
• A verified column of SUM totals that match control figures I will provide
• At least one pivot table (plus any supporting helper columns) that summarises the key metrics we discuss
• A final, presentation-ready report worksheet—print-friendly and visually tidy
Accuracy is non-negotiable, and I’m working on a tight timeline, so if you have a proven track record of error-free Excel work and can turn this around quickly, I’d love to collaborate.
Your first job will be to standardise all incoming rows and columns, weed out duplicates or obvious inaccuracies, and make sure every figure is in its correct place. After that, you’ll apply essential SUM formulas so totals reconcile across the entire file. If this stage goes smoothly, we can expand into more advanced logic such as IF statements, VLOOKUP/XLOOKUP, and automated dashboards, but the immediate focus is clean, accurate data.
When the sheets are tidy, I’ll need you to use native Excel tools—sorting, custom filters, and pivot tables—to shape the information into a clear, well-formatted report that’s ready for presentation. A polished layout with headings, number formatting, and intuitive slicers is a must because stakeholders will be looking at these files directly.
Deliverables I expect:
• A master worksheet with all numerical data correctly entered, de-duplicated, and validated
• A verified column of SUM totals that match control figures I will provide
• At least one pivot table (plus any supporting helper columns) that summarises the key metrics we discuss
• A final, presentation-ready report worksheet—print-friendly and visually tidy
Accuracy is non-negotiable, and I’m working on a tight timeline, so if you have a proven track record of error-free Excel work and can turn this around quickly, I’d love to collaborate.