HR Analytics Dashboard (Excel): Attrition, Hiring and Workforce Planning

Not another headcount chart. It shows when people leave, who leaves, under which manager and from which hiring source, then plans the next 12 months: hires, requisitions and payroll.

What is inside

• Workforce Planner: headcount targets per department become hires needed, how many only replace leavers, requisitions to open now, recruiter capacity, payroll with employer on-costs, and what attrition costs.
• Dashboard: headline sentence, 6 KPI cards, headcount bridge, retention curve, attrition heat map, source quality, pay vs band, manager map, talent 9-box, flight-risk list.
• Monthly Report: one printable A4 page for the month.
• KPI Scorecard: 38 KPIs with target, status and a 12-month trend line.
• Chart Library (16 charts), Learning & Engagement, Advanced Analytics (11 methods: control chart, forecast, cohorts, Lorenz + Gini and more).
• Data tabs: Employees, Recruitment, Absence, Training, Engagement, Grades, Settings.

Who it is for

• HR managers and owners of companies with 30 to 1,000 people who want answers, not just tables.

Format

• One ZIP: the Excel workbook (.xlsx) + a PDF user guide.
• Needs Excel for Microsoft 365, Excel 2024 or Excel for the web (free at office.com). Excel 2019 / 2016 and Google Sheets cannot run its formulas.
• No macros, no add-ins. Windows and Mac.
• Comes with fictional sample data: replace it with yours in the data tabs.
• Instant download after payment.