Excel Data Entry & Management -- 2

via Freelancer ·

Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted1 hour ago
I have several Excel workbooks that hold my financial and accounting records, but months of ad-hoc edits have left them cluttered and unreliable. I need you to turn this into a clean, trustworthy data source I can analyse with confidence.

The core of the job is to identify and remove every duplicate or incomplete line, standardise all names, dates, and address fields to a single clear format, then sort, filter, and group the information into well-defined columns. Along the way, please correct any broken formulas or obvious formatting errors you encounter so the file is ready for future dashboards and reporting.

I will provide the current spreadsheets and let you know the conventions I want followed for dates, currency, and naming. Once the file is returned, I should be able to run simple pivots or charts without hitting errors, and a quick scan should show consistent formatting throughout.
data processing data entry excel excel vba data cleansing excel vb capabilities data analysis data management
Apply on Freelancer →

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