Excel Survey Data Analysis Reports

I have a set of raw survey responses that must be turned into meaningful insights inside Excel. The job centers on statistical analysis—descriptives, significance testing where appropriate, and clear visualisations—followed by concise report-ready summaries that a non-technical audience can understand.

The workbook should end up with:
• A clean, documented data sheet (original data preserved, errors corrected)
• Analysis tabs that show formulas or pivot tables, not hard-coded numbers, so everything refreshes when new responses arrive
• Charts and tables that highlight key findings, automatically updating from the analysis tabs
• A final “Report” tab that presents the top-line story: key metrics, notable trends and any statistically significant relationships you uncover

Please keep all work native to Excel—no external add-ins—so my team can maintain the file after hand-off.