Sales Revenue Excel Report Creation

I have a raw sales data set that must be transformed into a clean, insightful revenue report delivered in a single Excel spreadsheet. The focus is exclusively on sales data, with revenue as the sole metric to track and visualise. The workbook should: • pull the data into structured tables, • calculate total and segmented revenue with clear formulas or pivot tables, • include slicers or drop-downs so I can filter by date, product or region, and • present a concise summary sheet featuring key charts that update automatically when the underlying data changes. Please build everything natively in Excel—no external BI tools—so the file remains fully editable. Accuracy, transparent calculations, and a layout that lets a non-technical user follow the logic will be the main acceptance criteria. Once the model is working I’ll test it with new data to confirm all links and formulas update without errors.