Excel Data Cleanup & Charts

I have a raw sales dataset that needs to be transformed into a polished, decision-ready Excel workbook. The job covers three core stages.

1. Data cleaning
• Removing duplicates
• Handling missing values
• Correcting formatting issues

2. Data organisation
After the clean-up, I need the information logically sorted and structured so filters, PivotTables, and formulas work seamlessly.

3. Visual insight
Please build a set of bar charts, pie charts, and line graphs that look great on a PowerPoint slide and instantly convey the key trends. Use clear labelling, consistent colour palettes, and ensure the visuals update automatically if the data changes.

Deliverable
One .xlsx file containing the cleaned sales data on a dedicated sheet, an organised analysis sheet, and a dashboard sheet with the requested charts. Everything should be easy to follow for someone who will later present the findings.

Accuracy is critical, so I will verify that no duplicates remain, blanks are handled sensibly, formats are consistent, and each chart reflects the final dataset without errors.