Excel Sales Summary Dashboard Build

I have a small sales dataset that needs to be transformed into a clear, at-a-glance dashboard in Excel. Here is exactly what I’m after:

• Re-organize the raw data into a tidy, structured table that will be easy for me to update later.
• Calculate and display three headline figures—Total sales, Number of transactions, and Average sale value—so they stand out immediately.
• Create a concise summary panel that pulls those key numbers together.
• Add one straightforward Pie chart to visualise the breakdown of sales.
• Keep everything on a single, well-formatted worksheet so colleagues can open the file and understand it instantly.

All formulas should be transparent and editable; please avoid hard-coding. When finished, simply send me the Excel file, ready to use.