Home › Excel case studies › Employee Attrition & Headcount Review
Employee Attrition & Headcount Review
Northgate's People team pulled a raw HR export ahead of the quarterly headcount review, but department names are spelled inconsistently, a few employee records are duplicated, and some manager fields are blank. Practice calculating attrition rate, tenure, and salary benchmarking from real, messy HR data. **What you'll learn:** - Department-level attrition-rate calculations - Tenure calculations from hire/termination dates - Salary benchmarking against a reference table - Spotting duplicate or incomplete records
Open this Excel case study
Work on a realistic business scenario for data analytics and business analytics practice. See the full details and get the assignment on Cellgrids.
View case study → Free Excel formula practiceAll Excel case studies · Excel interview prep · Excel formulas