HR & People Analytics in Excel
Turn HR data into answers: headcount and FTE, turnover, tenure bands, pay analysis, payroll, recruiting and absence KPIs, every cell checked as you go.
The first lesson is free — no account needed.
About this course
An HR and people analytics course in Excel that turns HR data into answers. You calculate headcount and FTE, turnover and retention rates, tenure and age bands with DATEDIF and COUNTIFS, compa-ratios, salary bands and median pay, gross-to-net payroll and employer cost, recruiting funnel KPIs such as time-to-hire and cost-per-hire, and absence and overtime KPIs, every cell checked as you go.
Lessons
- Headcount & FTE with Part-Time StaffFree
- Turnover & Retention Rates Pro
- Tenure & Age Bands with DATEDIF and COUNTIFS Pro
- Compensation: Compa-Ratio, Salary Bands & Median Pay Pro
- Gross-to-Net Payroll & Employer Cost Pro
- Recruiting Funnel: Time-to-Hire, Cost-per-Hire & Offer Acceptance Pro
- Absence & Overtime KPIs: Bradford Factor and Overtime Cost Pro