Excel Cleanup & Reporting Prep -- 2
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted3 hours ago
I have a sizeable set of financial data that needs to be turned into a clean, well-structured workbook ready for immediate reporting or deeper analysis. Here is what I need done:
• Data cleaning: remove every duplicate entry and correct any inconsistent formats so dates, currency, and percentages all display uniformly.
• Logical organisation: sort and filter the data into an intuitive layout that anyone on my team can follow at a glance.
• Formula layer: build a solid framework of Sum, Average, IF statements, plus VLOOKUP and HLOOKUP so common comparisons and roll-ups are automatic.
• Final polish: apply clear headings, freeze panes, and light conditional formatting so key figures stand out without clutter.
The finished file should open with no warnings, pass basic error checks, and be simple enough for a colleague to pick up and run with. Accuracy matters more than speed, but I do need a reliable turnaround, so let me know how quickly you can deliver once you see the raw sheet.
• Data cleaning: remove every duplicate entry and correct any inconsistent formats so dates, currency, and percentages all display uniformly.
• Logical organisation: sort and filter the data into an intuitive layout that anyone on my team can follow at a glance.
• Formula layer: build a solid framework of Sum, Average, IF statements, plus VLOOKUP and HLOOKUP so common comparisons and roll-ups are automatic.
• Final polish: apply clear headings, freeze panes, and light conditional formatting so key figures stand out without clutter.
The finished file should open with no warnings, pass basic error checks, and be simple enough for a colleague to pick up and run with. Accuracy matters more than speed, but I do need a reliable turnaround, so let me know how quickly you can deliver once you see the raw sheet.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.