Excel Daily Sales Dashboard Creation

Title: Build Interactive Daily Sales Dashboard in Excel (Delivery in 1 Day)

Description:
I need an experienced Excel expert to create a fully interactive daily sales dashboard that updates automatically when I paste in new sales data.

Dashboard Requirements:
Data Source:

Sales data will come in CSV/Excel format (columns: Date, Product, Category, Units Sold, Unit Price, Total Sales, Region, Channel)

Filters:

Date range selector (daily, weekly, monthly, custom)

Product filter

Category filter

Region/Channel filter (if possible)

KPIs (at top of dashboard):

Total Sales (₹)

Units Sold

Average Order Value (₹)

Top 5 Products by Sales

Top 5 Categories by Sales

Best Performing Region/Channel

Charts & Visuals:

Sales Trend (line chart by day/week/month)

Category-wise Sales (bar/column chart)

Product-wise Sales (bar/column chart, Top 10)

Sales by Region/Channel (pie/donut chart)

Units Sold vs. Revenue (dual-axis chart)

Other Features:

Searchable & sortable sales table

Fully automated — charts/tables update when new data is pasted

Clean, professional design with clear headings and color coding

One-click export to PDF for reports

Technical Notes:

Must work on any standard Excel version (Windows & Mac)

Avoid VBA/macros unless absolutely necessary for functionality

Bonus: Also set up in Google Sheets for online use

Deliverables:

Final Excel file (.xlsx)

Simple step-by-step instructions on updating the data

Timeline: 1 day (24 hours) max