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.
- 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
- Candidate Pipeline: Counting Candidates by StageFree
- Stage Conversion Rates: Where Candidates Drop Out Locked
- Time-to-Fill and Time-to-Hire from Dates Locked
- Source Effectiveness: Which Channels Bring Hires Locked
- Cost per Hire: Internal and External Recruiting Costs Locked
- Offer Acceptance Rate and Why Offers Are Declined Locked
- Interviewer Load: Interviews and Hours per Person Locked
- Agency Fees: Placement Fee, Guarantee Refunds and Net Cost Locked
- Open Requisition Aging: Days Open and Overdue Flags Locked
- Recruiter Weekly Report with SUMIFS Locked
- Mid-Course Dashboard: Hires Chart and Time-to-Fill Alerts Locked
- Candidate Response Times: Working Days to First Contact and SLA Breaches Locked
- Offer Checks: Looking Up the Salary Range with XLOOKUP Locked
- Hourly Offers: Annual Pay, Night Premiums and First-Year Cost Locked
- Referral Bonuses: Two Instalments, Due Dates and What Is Still Owed Locked
- Job Ads: Apply Rate, Cost per Qualified Applicant and When to Pause an Ad Locked
- Requisition Flow by Month: Opened, Filled, Cancelled and Still Open Locked
- Recruiting Budget: Spend vs Budget by Channel and a Full-Year Forecast Locked
- Candidate Experience Survey: Response Rate, Candidate NPS and Scores by Stage Locked
- Final Project: Quarterly Recruiting Scorecard by Role Family Locked
Learner reviews
Be the first to review this course.