Excel formulas
HR KPI Excel Formulas
Copy Excel formulas for common hr KPIs and adapt them for your spreadsheet or dashboard.
Affiliate resources
Ideas for You
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
HR Excel KPI books
Books that help you understand HR Excel KPI and related business metrics more deeply.
Explore resources →
HR Excel KPI audiobooks
Audiobook searches for learning HR Excel KPI while commuting, walking, or working.
Explore resources →
People analytics resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Recruiting analytics resources
Practical resources for turning HR Excel KPI into reports, dashboards, and business decisions.
Explore resources →
HR formulas for Excel
| KPI | Formula | Excel |
|---|---|---|
| Employee Turnover Rate | Employees Who Left / Average Number of Employees | =IFERROR(B2/C2,0) |
| Voluntary Turnover Rate | Voluntary Departures / Average Number of Employees | =IFERROR(B2/C2,0) |
| Absenteeism Rate | Absence Days / Available Work Days | =IFERROR(B2/C2,0) |
| Revenue per Employee | Revenue / Number of Employees | =IFERROR(B2/C2,0) |
| Cost per Hire | Total Recruiting Cost / Number of Hires | =IFERROR(B2/C2,0) |
| Time to Hire | Offer Accepted Date - Application Date | =B2-C2 |
| Time to Fill | Position Filled Date - Job Opened Date | =B2-C2 |
| Offer Acceptance Rate | Accepted Offers / Total Offers | =IFERROR(B2/C2,0) |
| Employee Retention Rate | Employees Remaining / Employees at Start of Period | =IFERROR(B2/C2,0) |
| Training Cost per Employee | Total Training Cost / Employees Trained | =IFERROR(B2/C2,0) |
| Employee Productivity | Output / Employee Hours | =IFERROR(B2/C2,0) |
| Headcount Growth Rate | (Current Headcount - Previous Headcount) / Previous Headcount | =IFERROR((B2-C2)/C2,0) |
| eNPS | % Promoters - % Detractors | =B2-C2 |
| Promotion Rate | Employees Promoted / Total Employees | =IFERROR(B2/C2,0) |