Tabellab

HR Analyst Interview Practice: Headcount & FTE Questions, Turnover Rates, Time-to-Fill, Pay Range Tasks, Absence Rates, Survey Scores, Workforce Cost Cases & a Timed Mock Case

Practise 20 hands-on labs of HR analyst interview and take-home tasks at fictional companies – count heads and FTE, work out turnover and early-leaver rates, time-to-fill and cost per hire, compa-ratios and merit splits, absence, survey and overtime rates, clean an HR export and forecast workforce cost – with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

HR analyst interviews and take-home tasks test whether you can turn people data into clear, fair numbers. In 20 hands-on labs you work through short practice cases at fictional companies: you convert positions into headcount and FTE, calculate turnover with an average headcount, early-leaver rates by hire cohort, time-to-fill, offer acceptance and cost per hire, place positions in pay ranges with compa-ratios and range penetration, split a merit budget, compare absence, survey favourability and overtime rates by team, build a fully loaded workforce cost forecast, clean an HR export with duplicate IDs and bad dates, and finish with a timed mock case.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. The Headcount Question: Heads vs FTE for 24 PositionsLabFree
  2. Turnover Question: Average Headcount and the Leaver RateLab Locked
  3. Early Leaver Question: First-Year Leavers by Hire QuarterLab Locked
  4. Recruiting Question: Time-to-Fill and Offer AcceptanceLab Locked
  5. Cost per Hire Question: Pooled Cost by SourceLab Locked
  6. Pay Range Question 1: Compa-Ratio and Range PenetrationLab Locked
  7. Pay Range Question 2: Range Spread and Catch-Up CostLab Locked
  8. Merit Budget Question: Guideline Rates and a Scaled SplitLab Locked
  9. Absence Rate Question: Lost Days by TeamLab Locked
  10. Survey Question: Response Rates, Favourability, Small GroupsLab Locked
  11. Overtime Question: Overtime % and Premium Cost by TeamLab Locked
  12. Workforce Cost Question: Fully Loaded Cost per FTELab Locked
  13. Workforce Cost Forecast: FTE Plan, Pay Rise, Budget GapLab Locked
  14. Data Cleaning Take-Home 1: Duplicate Employee IDsLab Locked
  15. Data Cleaning Take-Home 2: Missing and Impossible DatesLab Locked
  16. Headcount Bridge Question: Opening to ClosingLab Locked
  17. Hiring Funnel Question: Applicants Needed per RoleLab Locked
  18. Rates Trap: Pooled Turnover vs Average of Hotel RatesLab Locked
  19. Presenting Results: KPI Table, Targets and StatusLab Locked
  20. Final Project: Timed Mock Case – Which Teams Need a Review?Lab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy