We are looking for an Excel expert to create a clear and professional dashboard based on provided sales and operations data. The dashboard should include basic visuals and summary tables using formulas and Excel built-in charts (no VBA or macros needed).
Requirements:
Good skills in Excel formulas (SUMIFS, COUNTIFS, AVERAGEIFS, etc.)
Ability to design clean, professional layouts
Experience with PivotTables and Charts
Strong attention to data accuracy and formatting
Key Focus Areas:
Total Orders by Region
Average Delivery Delay
Orders Delivered vs Placed (Trendline)
Average Customer Rating by Agent
To Apply:
Submit a Proposal & send 1 sample of a past Excel dashboard you've created.
Milestones
Project Deliverables
Excel file with a dashboard (in same file or new tab)
Clean design, labeled sections, automatic updates via formulas
No external plugins/macros