Excel Sales Data Revamp

I have a raw sales workbook that needs to move from “messy spreadsheet” to a clean, insight-ready file.
Here is what I need you to handle:

• Reorganise the existing columns and rows so each transaction is clearly structured and easy to filter or pivot.
• Build the essential formulas directly into the sheet—totals, averages and any additional calculations you recommend—so figures update automatically as new data is added.
• Design a small set of clear charts and graphs (bar, line, pie, or whichever best suits the data) on a separate dashboard sheet for at-a-glance trends.

I will supply the current Excel file as soon as we start. Feel free to suggest naming conventions, conditional formatting or other quick wins that make the data even more readable. Final deliverable is a single Excel workbook, fully formatted, formula-driven and with the charts laid out neatly.