Excel Data Analysis Spreadsheet Creation

I have a set of raw figures that must be typed into Excel and shaped into a clean, analysis-ready spreadsheet. The work starts with accurate data entry: each number, label and date needs to be transcribed exactly as it appears in the source files. From there, the sheet should be structured for quick data analysis—think clear column headers, consistent data types, and built-in checks that flag typos or missing values.

Once everything is organised, I’ll need basic analytical tools in place: formulas or pivot tables that summarise totals, averages and growth percentages, plus a couple of simple charts for at-a-glance insights. Keep the layout intuitive so I can append new rows and have the summaries refresh automatically.

I value experience above all else on this job, so in your bid just highlight similar Excel data-analysis projects you’ve handled and the techniques you rely on (lookups, pivot tables, conditional formatting, Power Query, etc.). I will provide the raw files after award; the final deliverable is a fully functional .xlsx file together with any brief notes needed to understand your structure.

Acceptance criteria
• All source data accurately transcribed
• Formulas/pivots return correct results with no errors
• Workbook opens cleanly in the latest Excel version, ready for immediate use