HR Dashboard: Turnover, Headcount, and Diversity Metrics in Excel,

Build a complete HR analytics dashboard in Excel for [COMPANY NAME] with [NUMBER] employees across [NUMBER] departments and [NUMBER] locations.

**Tab 1 — Employee Database:**
- Columns: Employee ID, Name, Department, Role, Location, Hire Date, Termination Date (if applicable), Manager, Salary Band, Gender, Ethnicity (if tracked), Performance Rating
- Calculated columns: Tenure (months), Active/Terminated status
- Data validation for all categorical fields

**Tab 2 — Headcount Dashboard:**
- Current headcount by department, location, and level
- Monthly headcount trend (last 12 months) with sparklines
- New hires vs. terminations by month (waterfall chart)
- Open positions vs. filled positions
- Headcount vs. budget variance

**Tab 3 — Turnover Analysis:**
- Monthly turnover rate: Terminations / Average Headcount
- Turnover by department, location, tenure band (<6mo, 6-12mo, 1-2yr, 2-5yr, 5+yr)
- Voluntary vs. involuntary turnover breakdown
- Cost of turnover: recruitment + training + lost productivity per departure
- Exit reason Pareto chart
- Retention rate by cohort (hire month)

**Tab 4 — Diversity Metrics:**
- Gender ratio by department and level
- Diversity hiring rate vs. current workforce composition
- Promotion rate by demographic group
- Pay equity analysis (average by group, adjusted for role/level)

**Tab 5 — Hiring Pipeline:**
- Open requisitions with days open
- Pipeline stages: Applied → Screened → Interviewed → Offer → Hired
- Time-to-fill by department
- Source of hire effectiveness
- Offer acceptance rate

Use INDEX/MATCH, SUMIFS, and Pivot Tables. Include conditional formatting for thresholds.