Accounts Excel Data Entry
Budget: ₹750 – ₹1,250 INR
I have several job-account spreadsheets and CSV exports that need to be consolidated into one clean Microsoft Excel workbook. Each record contains a mix of text fields (project names, client references, notes) and numbers (balances, invoice totals, codes).
Your assignment is to transfer every row from the source files into the new master sheet, preserve all data exactly, and apply clear, consistent formatting so the figures read correctly at a glance. Basic validations—such as currency number formats, drop-downs for status, and simple SUM formulas for column totals—will help me run quick checks later, so please include them where they make sense.
Deliverables
• Final Excel workbook containing all records, fully formatted and verified
• Short log of any unreadable lines or discrepancies discovered during entry
Acceptance criteria
• 100 % of rows present and matching their originals
• No formula or reference errors when opened in Microsoft Excel 2019+
• Numeric columns total correctly against the source figures
If you work accurately and can turn this around promptly, I’ll share the files immediately so you can begin.
Your assignment is to transfer every row from the source files into the new master sheet, preserve all data exactly, and apply clear, consistent formatting so the figures read correctly at a glance. Basic validations—such as currency number formats, drop-downs for status, and simple SUM formulas for column totals—will help me run quick checks later, so please include them where they make sense.
Deliverables
• Final Excel workbook containing all records, fully formatted and verified
• Short log of any unreadable lines or discrepancies discovered during entry
Acceptance criteria
• 100 % of rows present and matching their originals
• No formula or reference errors when opened in Microsoft Excel 2019+
• Numeric columns total correctly against the source figures
If you work accurately and can turn this around promptly, I’ll share the files immediately so you can begin.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Financial Analysis
Excel VBA
Excel Macros
Data Analysis