Excel Sales Dashboard Templates
A sales dashboard shows how much you are selling, which deals are closing and whether the team will hit target. Pick your industry below to see a live preview of the Excel version.
Choose your industry
Retail Sales DashboardExcel · $29E-commerce Sales DashboardExcel · $29SaaS Sales DashboardExcel · $29Restaurant Sales DashboardExcel · $29Café & Bakery Sales DashboardExcel · $29Hotel Sales DashboardExcel · $29Real Estate Sales DashboardExcel · $29Construction Sales DashboardExcel · $29Manufacturing Sales DashboardExcel · $29Logistics Sales DashboardExcel · $29Clinic Sales DashboardExcel · $29Hospital Sales DashboardExcel · $29Dental Practice Sales DashboardExcel · $29Pharmacy Sales DashboardExcel · $29Gym & Fitness Sales DashboardExcel · $29Salon & Spa Sales DashboardExcel · $29Coaching Institute Sales DashboardExcel · $29School Sales DashboardExcel · $29University Sales DashboardExcel · $29Marketing Agency Sales DashboardExcel · $29Consulting Sales DashboardExcel · $29Law Firm Sales DashboardExcel · $29Accounting Firm Sales DashboardExcel · $29Insurance Sales DashboardExcel · $29Banking Sales DashboardExcel · $29Fintech Sales DashboardExcel · $29Automotive Sales DashboardExcel · $29Car Dealership Sales DashboardExcel · $29Agriculture Sales DashboardExcel · $29Food Processing Sales DashboardExcel · $29FMCG Distribution Sales DashboardExcel · $29Wholesale Sales DashboardExcel · $29Kirana Store Sales DashboardExcel · $29Fashion & Apparel Sales DashboardExcel · $29Jewellery Sales DashboardExcel · $29Electronics Store Sales DashboardExcel · $29Furniture Sales DashboardExcel · $29Pharma Sales DashboardExcel · $29Telecom Sales DashboardExcel · $29Solar & Energy Sales DashboardExcel · $29Non-profit Sales DashboardExcel · $29Events Sales DashboardExcel · $29Travel Agency Sales DashboardExcel · $29Media & Publishing Sales DashboardExcel · $29Gaming Sales DashboardExcel · $29Creator Business Sales DashboardExcel · $29Freelancer Sales DashboardExcel · $29Startup Sales DashboardExcel · $29IT Services Sales DashboardExcel · $29Security Services Sales DashboardExcel · $29Cleaning Services Sales DashboardExcel · $29Printing & Packaging Sales DashboardExcel · $29Pet Care Sales DashboardExcel · $29
KPIs in every sales dashboard
| KPI | What it tells you | Formula |
|---|---|---|
| Revenue | Total value of sales booked in the period. | SUM of invoice or order value |
| Deals won | Number of deals or orders closed as won. | COUNT of deals with stage = Won |
| Win rate | Share of closed deals that you won. | Deals won ÷ (Deals won + Deals lost) |
| Avg deal size | Average value of a won deal. | Revenue ÷ Deals won |
| Pipeline value | Value of all open deals that could still close. | SUM of open deal value (optionally × probability) |
| Sales cycle | Average days from first contact to a won deal. | AVERAGE of (Close date − Created date) |
| Quota attainment | How much of the sales target has been achieved. | Revenue ÷ Target |
| New customers | Customers who bought for the first time in the period. | COUNT of customers with first order in period |