Excel Descriptive Analysis with Charts

I have a dataset that needs to be brought into Excel, organized, and put through clear descriptive analysis. Once the numbers are in place, I’d like to see the story behind them told through well-designed charts and graphs—no predictive modelling or advanced statistics, just solid summaries that let me grasp totals, averages, distributions, and any obvious patterns at a glance.

You’ll receive the raw data (currently in mixed formats), enter or import it into a single workbook, carry out the descriptive calculations directly in Excel, and then present the findings visually. Pivot tables are optional; feel free to use them if they speed things up, but the final output must include:

• A tidy data sheet ready for future updates
• One analysis sheet with the key summary figures clearly labelled
• A separate dashboard or section containing the charts/graphs that illustrate those summaries

Everything should be built using standard Excel functions so I can maintain it myself later.