Excel Data Entry & Formatting
Budget: ₹12,500 – ₹37,500 INR
I have an existing Excel template that captures sales and support metrics, and I need it populated and refined on a recurring basis. Raw figures will arrive in mixed formats—CSV downloads, handwritten scans, and short text files—and I want every line transferred manually into the correct columns of the master sheet.
Once the numbers are in place, formulas and functions already embedded in the template must run without errors. Where calculations are missing, you’ll add appropriate SUMIFS, VLOOKUP/XLOOKUP, or simple logical statements so totals and variances update automatically. After that, create or refresh the pivot tables and linked charts that sit on the “Dashboard” tab; these visuals drive weekly performance reviews, so accuracy and clear labeling are critical.
Acceptance criteria
• All source rows entered with 100 % accuracy (spot-checked against originals)
• Formulas return correct results and remain intact for future imports
• Pivot tables reflect the full data range and are sliced by Region and Product as in the template
• Charts auto-update and match the pivot outputs in style and values
Files are shared through OneDrive; please work directly in the cloud version of Excel so change history is preserved. I’ll provide sample data and the locked-down template once we start, and I’m available for quick clarifications by chat.
Once the numbers are in place, formulas and functions already embedded in the template must run without errors. Where calculations are missing, you’ll add appropriate SUMIFS, VLOOKUP/XLOOKUP, or simple logical statements so totals and variances update automatically. After that, create or refresh the pivot tables and linked charts that sit on the “Dashboard” tab; these visuals drive weekly performance reviews, so accuracy and clear labeling are critical.
Acceptance criteria
• All source rows entered with 100 % accuracy (spot-checked against originals)
• Formulas return correct results and remain intact for future imports
• Pivot tables reflect the full data range and are sliced by Region and Product as in the template
• Charts auto-update and match the pivot outputs in style and values
Files are shared through OneDrive; please work directly in the cloud version of Excel so change history is preserved. I’ll provide sample data and the locked-down template once we start, and I’m available for quick clarifications by chat.
Related categories:
Data Processing
Data Entry
Excel
PDF
Excel VBA
Excel Macros
Data Visualization
Data Analysis