Excel Data Tabulation & Metrics
Budget: ₹18,000 – ₹22,000 INR
I have three separate Excel workbooks that need to be brought into a single, cleanly structured format. Each file contains raw rows of sales figures, productivity rates, and incentive calculations; I want them consolidated so I can see all performance data side-by-side without having to jump between sheets.
Here’s what I’m expecting:
• Combine the data from the three spreadsheets into a master sheet, keeping every original record intact while standardising column names, date formats, and number styles.
• Insert the basic formulas I rely on—SUM and AVERAGE for quick roll-ups, plus IF and VLOOKUP wherever they streamline incentive look-ups or cross-sheet references.
• Double-check totals and any derived fields so the final file is free of missing values, misalignments, or duplicate entries.
• Apply a tidy, professional layout: clear headings, frozen panes for headers, and filtered tables so I can sort metrics on the fly.
Once everything balances and looks sharp, send back the finished workbook for review. I’ll do a final spot-check against my source files, and if the numbers tie out we’re done.
Here’s what I’m expecting:
• Combine the data from the three spreadsheets into a master sheet, keeping every original record intact while standardising column names, date formats, and number styles.
• Insert the basic formulas I rely on—SUM and AVERAGE for quick roll-ups, plus IF and VLOOKUP wherever they streamline incentive look-ups or cross-sheet references.
• Double-check totals and any derived fields so the final file is free of missing values, misalignments, or duplicate entries.
• Apply a tidy, professional layout: clear headings, frozen panes for headers, and filtered tables so I can sort metrics on the fly.
Once everything balances and looks sharp, send back the finished workbook for review. I’ll do a final spot-check against my source files, and if the numbers tie out we’re done.