Excel Sales Data Analysis

Monthly sales figures from several CSV exports have to be transformed into clear, actionable insights in Excel. The core of this Excel-based project is data analysis, not general spreadsheet creation or macro automation, so the focus stays on cleaning raw sales data, structuring it, and presenting digestible results.

Scope of work
• Import and consolidate all source files into a single, well-organized workbook.
• Remove duplicates, handle missing values, and standardize date and currency formats.
• Build dynamic pivot tables, slicers, and charts that let me filter by product line, region, and time period.
• Generate a concise dashboard highlighting total revenue, average order value, month-over-month growth, and top-performing SKUs.
• Provide a short written summary of key findings and any notable trends revealed during the analysis.

Acceptance criteria
• Workbook opens without broken links or references.
• All calculations update automatically when new rows are appended.
• Charts stay in sync with pivot filters and display without distortion.
• Summary narrative is no more than one page yet covers at least three major insights.

Native Excel functions, pivot tables, and basic Power Query are all fair game; VBA is optional but not required. Deliver the finished .xlsx file and the written summary.