Excel HR Dashboard Templates
A hR dashboard tracks your people: hiring, attrition, attendance, training and pay in one place. Pick your industry below to see a live preview of the Excel version.
Choose your industry
Retail HR DashboardExcel · $29E-commerce HR DashboardExcel · $29SaaS HR DashboardExcel · $29Restaurant HR DashboardExcel · $29Café & Bakery HR DashboardExcel · $29Hotel HR DashboardExcel · $29Real Estate HR DashboardExcel · $29Construction HR DashboardExcel · $29Manufacturing HR DashboardExcel · $29Logistics HR DashboardExcel · $29Clinic HR DashboardExcel · $29Hospital HR DashboardExcel · $29Dental Practice HR DashboardExcel · $29Pharmacy HR DashboardExcel · $29Gym & Fitness HR DashboardExcel · $29Salon & Spa HR DashboardExcel · $29Coaching Institute HR DashboardExcel · $29School HR DashboardExcel · $29University HR DashboardExcel · $29Marketing Agency HR DashboardExcel · $29Consulting HR DashboardExcel · $29Law Firm HR DashboardExcel · $29Accounting Firm HR DashboardExcel · $29Insurance HR DashboardExcel · $29Banking HR DashboardExcel · $29Fintech HR DashboardExcel · $29Automotive HR DashboardExcel · $29Car Dealership HR DashboardExcel · $29Agriculture HR DashboardExcel · $29Food Processing HR DashboardExcel · $29FMCG Distribution HR DashboardExcel · $29Wholesale HR DashboardExcel · $29Kirana Store HR DashboardExcel · $29Fashion & Apparel HR DashboardExcel · $29Jewellery HR DashboardExcel · $29Electronics Store HR DashboardExcel · $29Furniture HR DashboardExcel · $29Pharma HR DashboardExcel · $29Telecom HR DashboardExcel · $29Solar & Energy HR DashboardExcel · $29Non-profit HR DashboardExcel · $29Events HR DashboardExcel · $29Travel Agency HR DashboardExcel · $29Media & Publishing HR DashboardExcel · $29Gaming HR DashboardExcel · $29Creator Business HR DashboardExcel · $29Freelancer HR DashboardExcel · $29Startup HR DashboardExcel · $29IT Services HR DashboardExcel · $29Security Services HR DashboardExcel · $29Cleaning Services HR DashboardExcel · $29Printing & Packaging HR DashboardExcel · $29Pet Care HR DashboardExcel · $29
KPIs in every hR dashboard
| KPI | What it tells you | Formula |
|---|---|---|
| Headcount | Number of active employees at period end. | COUNT of employees with status = Active |
| Attrition rate | Share of employees who left in the period. | Leavers ÷ Average headcount |
| Time to hire | Average days from job opening to offer accepted. | AVERAGE of (Offer accepted − Opening date) |
| Open positions | Roles approved but not yet filled. | COUNT of open requisitions |
| Absenteeism | Share of scheduled work time lost to unplanned absence. | Days absent ÷ Scheduled working days |
| Training hours | Total hours of learning completed. | SUM of training hours logged |
| eNPS | How likely employees are to recommend you as a workplace. | % Promoters − % Detractors |
| Avg salary | Average monthly pay per employee. | Total payroll ÷ Headcount |