Home › Excel case studies › Employee Attrition & Exit Analysis
Employee Attrition & Exit Analysis
A 460-person retail group’s HR Director says attrition is out of control. Work out which departments are truly above target, why people leave, and what it costs. **What you’ll learn:** Attrition rates from opening and closing headcount, annualised against targets Cleaning HR data (text dates, text salaries, duplicate employees) Costing attrition and spotting “regretted” leavers
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