Product Sales Spreadsheet Update & Calculations

I have an existing Excel workbook that tracks our product sales, and I need it brought fully up to date. Your first task is to enter the latest batch of product-level transactions I will supply (same column structure as the current sheet). Once the new rows are in, please set up clear weekly and monthly summaries so I can see total units sold, gross revenue, and average selling price at a glance. A simple combination of dynamic formulas—SUMIFS, AVERAGEIFS, maybe a PivotTable or two—should handle it, but feel free to use Power Query if it speeds things up.

Accuracy is critical: dates, SKUs, and revenue amounts must match the source files exactly. I’ll sign off once the numbers in your summaries reconcile with my own quick checks. Let me know if you spot anomalies; I may need you to flag any duplicates or missing fields before finalizing.

Deliverable is the updated .xlsx file with:
• All new product sales data entered and validated
• Weekly and monthly subtotal sections that auto-update when more rows are added

If you’re comfortable working directly in Excel and can turn this around quickly, I’d love to get started today.