Excel Sales Summary Dashboard

I need a streamlined Microsoft Excel dashboard that quickly turns our internal sales data into clear, insightful summaries. All information will come straight from our own systems—no external feeds—so the workbook must be structured to accept raw data exports and refresh the visuals automatically.

Here is what I am after:
• A single-file Excel solution (xlsx, no macros if possible) with tidy source tables, named ranges and a refresh button.
• Dynamic charts, pivot tables and slicers that highlight revenue, units, average order value and year-over-year growth.
• A top-level summary page that executives can read at a glance, followed by drill-down views by product, region and salesperson.
• Clean, corporate-ready formatting and color-coding that matches our style guide (will be supplied).

Acceptance criteria: every figure on the dashboard must recalculate correctly when I paste a new month of sales into the source sheet; no broken links or #REF errors.

The initial data sample is ready to share as soon as we start. If you are comfortable with advanced Excel features—Power Query, Power Pivot, nested formulas and dashboard layout best practices—I would love to see this turned around quickly.

---
來源：Freelancer.com | 出價次數：4 | 剩餘時間：6 日 | 專案類型：固定預算