Tabellab
HR & People Ops Beginner

Excel for Recruiters: Candidate Pipeline, Time-to-Fill, Sources & Cost per Hire

20 hands-on labs for in-house recruiters and talent acquisition coordinators: pipeline counts by stage, conversion rates, time-to-fill and time-to-hire, source effectiveness, cost per hire, offer acceptance, interviewer load, agency fees, requisition aging, a weekly report and a mid-course dashboard, then candidate response times in working days, salary-range checks with XLOOKUP, hourly offers with night premiums, referral bonus payouts, job ad performance, monthly requisition flow, a budget forecast, a candidate experience survey and a quarterly scorecard – every cell checked instantly.

20 lessons 20 labs Certificate

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

About this course

This course turns the exports a recruiter works with every day into clear answers, in 20 hands-on labs at a fictional logistics company. You count candidates by stage, calculate conversion rates, time-to-fill and time-to-hire, compare sources, work out cost per hire, offer acceptance, interviewer load and agency fees, age open requisitions and build a weekly report and a mid-course dashboard. The second half goes further: working days to first contact with NETWORKDAYS and an SLA flag, salary-range checks with XLOOKUP, hourly offers with night premiums and sign-on bonuses, referral bonuses paid in two instalments, cost per qualified applicant for job ads, a monthly requisition flow with COUNTIFS and EDATE, a run-rate budget forecast, a candidate experience survey with NPS and a quarterly scorecard by role family with charts and alerts. Every formula is checked as you type.

Lessons

  1. Candidate Pipeline: Counting Candidates by StageLabFree
  2. Stage Conversion Rates: Where Candidates Drop OutLab Locked
  3. Time-to-Fill and Time-to-Hire from DatesLab Locked
  4. Source Effectiveness: Which Channels Bring HiresLab Locked
  5. Cost per Hire: Internal and External Recruiting CostsLab Locked
  6. Offer Acceptance Rate and Why Offers Are DeclinedLab Locked
  7. Interviewer Load: Interviews and Hours per PersonLab Locked
  8. Agency Fees: Placement Fee, Guarantee Refunds and Net CostLab Locked
  9. Open Requisition Aging: Days Open and Overdue FlagsLab Locked
  10. Recruiter Weekly Report with SUMIFSLab Locked
  11. Mid-Course Dashboard: Hires Chart and Time-to-Fill AlertsLab Locked
  12. Candidate Response Times: Working Days to First Contact and SLA BreachesLab Locked
  13. Offer Checks: Looking Up the Salary Range with XLOOKUPLab Locked
  14. Hourly Offers: Annual Pay, Night Premiums and First-Year CostLab Locked
  15. Referral Bonuses: Two Instalments, Due Dates and What Is Still OwedLab Locked
  16. Job Ads: Apply Rate, Cost per Qualified Applicant and When to Pause an AdLab Locked
  17. Requisition Flow by Month: Opened, Filled, Cancelled and Still OpenLab Locked
  18. Recruiting Budget: Spend vs Budget by Channel and a Full-Year ForecastLab Locked
  19. Candidate Experience Survey: Response Rate, Candidate NPS and Scores by StageLab Locked
  20. Final Project: Quarterly Recruiting Scorecard by Role FamilyLab 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