Excel Cleanup & Reporting Prep -- 2

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour 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.
visual basic data processing data entry excel financial analysis data visualization data analysis data management
Apply on Freelancer →

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