Excel Data Entry & Cleanup

I have several batches of mixed numeric and text information scattered across text files, old e-mails, and a few odds-and-ends formats. My immediate need is straightforward: get every single record entered into a master Excel workbook accurately, then tidy it so the sheet is ready for formulas, filters, and pivot-table analysis. Here is what the job looks like from my side: • Consolidate the raw files into one workbook, respecting any original column order that matters and flagging inconsistencies you discover. • Clean and re-format the data—remove duplicates, standardise dates, align text casing, and make sure numeric fields behave like numbers. • Once everything is pristine, create a simple summary tab that gives me quick counts or basic statistics I can build on later. I’m comfortable if you lean on functions such as VLOOKUP, IF, SUMIFS, or Power Query where helpful—whatever keeps the process reliable and repeatable. Deliverables I expect at hand-off: 1. A single, well-structured Excel file containing all entered data. 2. A “Clean Log” sheet briefly noting any major issues you corrected (e.g., duplicate IDs or unreadable values). 3. The summary/report tab described above. Accuracy matters more than speed, but I would like the first draft within a week so I can review and give feedback. If this goes smoothly there will be extra datasets waiting.

Project ID: 40278875