Excel Data Entry & Reporting -- 2

I have several Excel workbooks that need to be brought up to production standard. The job centres on data entry—specifically Excel spreadsheets—and covers three concrete tasks:

• Data input and validation: copy-paste or import raw records, then check for duplicates, missing values, and format inconsistencies using validation rules or conditional formatting.
• Creating formulas and functions: drop in SUMIFS, VLOOKUP/INDEX-MATCH, text-to-columns, and other dynamic functions so the sheets calculate on their own.
• Generating reports and charts: transform the cleaned data into PivotTables, charts, and summary tabs that give at-a-glance insights.

I’ll provide the raw CSVs and a template showing the desired column order and naming conventions. For each workbook I expect a clean, error-free data sheet, a formula layer that auto-updates, and one summary report with at least two visual charts.

Use any recent version of Microsoft Excel or Excel 365. A quick screen-share walk-through of your first finished file will serve as acceptance before the rest proceed. Accuracy is top priority, followed closely by clear, well-commented formulas so the team can maintain them later.