Tabellab

HR, payroll and workforce analytics courses

People data is full of small calculations that have to be right: hours into gross pay, applicants needed per hire, headcount against budget, and how many people a 24/7 post really requires.

HR, Payroll & Workforce Analytics courses (15)

$9.90Beginner

Payroll Accounting & Bookkeeping

Run a full payroll for Harbor Lane Studio in 20 hands-on labs: gross pay, deductions, employer costs, the register, journal entries, payments, accruals and the reconciliation, then tax bands, annual ceilings, bonuses, starters and leavers, sick pay, benefits, advances, variance and year-end reviews, cost allocation and a 2027 budget, every cell checked live.

20 lessons · 20 labs

$9.90Intermediate

Staffing & Recruitment Agency Economics: Bill vs Pay Rates, Employer Cost Loads, Placement Fees, Fill Rates & Recruiter Productivity

Run a temp and permanent placement agency by the numbers in 20 hands-on labs: pay rate, fictional employer cost load, bill rate and markup, target-margin price floors, pay-rise pass-through, placement fees, fill rates, recruiter desks, timesheet leakage, client cost to serve, rebates, receivables ageing, branch KPIs, the agency P&L and a scenario budget – every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Excel for Payroll Administrators: Hours, Gross-to-Net, Registers & Checks

20 hands-on labs for payroll administrators: timesheet hours, overtime and night premiums, salaried and hourly pay, pre-tax pension, rate-table withholding, gross-to-net, the payroll register, employer cost, year-to-date totals, starters and leavers, variance checks and a payroll dashboard, then holiday accrual and liability, unpaid leave and sick pay, contribution ceilings, back pay and pro-rata bonuses, a payroll calendar, timesheet exception checks, a bank file reconciliation and a year-end payroll dashboard.

20 lessons · 20 labs

$9.90Intermediate

Seasonal Workforce Planning by the Numbers: Peak Demand to Hours, Returning Staff, Hiring Waves, Training Capacity, Ramp-Up, Overtime vs Temps, Labour Costs & a Season Dashboard

Staff a fictional 26-week harvest and packing season by role group in 20 hands-on labs – boxes to hours and heads, returners, hiring funnel and waves, training capacity, ramp-up, overtime versus temps, early leavers, site limits, labour costs, scenarios and a season dashboard – with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Workforce Planning & Headcount Budgeting

Plan people like finance does: headcount roll-forwards, FTE, fully loaded cost, prorated hiring plans, backfill, span of control, demand vs supply and budget-vs-actual variance, then position control, monthly forecasts, vacancy factors, pay-review timing, location mix, cost allocation, a budget cut line, reforecasts, scenarios, sensitivity grids, a three-year plan and a final dashboard: 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Advanced

Performance Calibration & Bonus Pool Math: Rating Curves, Multipliers & Payouts

Compare ratings with a target curve, calibrate managers with z-scores, percent ranks and small-team shrinkage, track what the calibration meeting changed, turn the curve into head counts, fund, stress-test and cap the pool, allocate it to departments, apply two-way multipliers and pro-rating, fit payouts to budget, cap and defer bonuses and check outcomes by group, in 20 hands-on labs with every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Hiring Pipeline Math: Applicants Needed, Time-to-Fill & Recruiter Capacity

Work backwards from a hiring plan to the applicants, interviews and recruiter hours you need: funnel conversion, time-to-fill in working days, source costs, panel load, recruiter capacity and quality of hire, then go further with pipeline aging, step durations, backward scheduling with WORKDAY, pipeline coverage, weekly run-rates, a sourcing mix within capacity, sensitivity tables, interview capacity, a recruiter hours model, data checks, monthly cohorts and a quarterly hiring dashboard: 20 hands-on labs at one fictional retailer, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Staffing 24/7 Posts: Post Hours, Relief Factors, Officers Needed, Shift Patterns, Overtime & Bill-Rate Build-Ups

Staff posts that never close, such as a site gate, a reception desk or a control room: turn opening hours into post hours, subtract leave, training and absence to get net hours, use the relief factor to find the officers you need, check a rota for gaps with MOD, cost overtime against new hires, build a bill rate with a margin that holds and report every site on one dashboard, then go further with night, weekend and holiday premiums, shift length and handover time, relief-factor scenarios, roster and rest checks, summer leave gaps, ad-hoc event quotes, mobile patrol routes, service credits, the hiring pipeline, variation requests and a full tender dashboard: 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Beginner

Excel for HR Assistants: Headcount, Hiring, Leave & Payroll Prep

20 hands-on labs for HR assistants and coordinators at a 60-person company: employee list cleanup and XLOOKUP, headcount, tenure, birthdays and anniversaries, time-to-hire, cost per hire, leave balances, overtime for payroll, compa-ratio, turnover, training hours and an HR dashboard, then names and email addresses, dynamic lists, two-key pay scale lookups, probation and contract end dates, headcount on any date, salary changes with back pay, input rules and a monthly HR report.

20 lessons · 20 labs

$9.90Beginner

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

$9.90Intermediate

Call Center Metrics & Erlang C Staffing

AHT, ASA, abandonment and FCR, traffic in Erlangs, the Erlang C formula built by hand, 80/20 service level, agents needed, shrinkage, hourly forecasts and cost per contact, then short abandons and patience curves, Erlang B for phone lines, queue pooling, square-root staffing, roster coverage, intraday re-forecasts, capacity plans with hiring classes, chat concurrency, forecast accuracy, email backlogs and a final peak-day sensitivity dashboard: 20 labs on one contact center's data, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Contingent Workforce Costs: Agency Markups, Contractor Day Rates, Fixed-Fee Statements of Work, Conversion Fees & Total Cost per Hour

See what temps, contractors and outsourced projects really cost the company that buys them: comparable hourly rates, agency markups vs loaded employee costs, rate-card checks, fixed fee vs time and materials, temp-to-perm fees and extensions, then overtime premiums, timesheet-to-invoice checks, agency quote comparisons, volume rebates, retainers, expenses, rate increase requests, spend forecasts, hire-or-temp crossovers, register checks, a supplier scorecard and a cost dashboard, in 20 hands-on labs with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Employee Benefits Budgeting: Plan Options, Enrolment by Tier, Employer Contribution Strategies, Renewals & Cost per Head

Plan next year's benefits budget for a fictional company in 20 hands-on labs: plan options and coverage tiers, who pays what, renewals, opt-outs, flexible allowances and pension matching, then quote checks, payroll deductions, funding options, invoice reconciliation, sensitivity grids, monthly phasing, cost allocation and a three-year projection, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Employee Engagement Survey Analytics: Response Rates, Favourability, Index Scores, eNPS, Small-Group Suppression & Driver Analysis

Turn a staff survey into results you can act on: track participation while the survey is open, work out response rates and favourable scores per item and team, means and spreads from answer counts, theme and index scores and an eNPS, suppress groups too small to report and check for secondary disclosure, compare teams with the rest of the company, an external benchmark and last year, roll results up reporting lines, compare pulses like for like, find the drivers that matter most, follow up action plans and build a team report and a company dashboard, in 20 hands-on labs with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

HR Service Delivery Metrics: HR-to-Employee Ratios, Case Volumes, Resolution Times, Self-Service Rates, HR Cost per Employee & Service Levels

Measure the HR function itself. You will benchmark HR staffing ratios, analyse case logs by category and channel, measure resolution times against service levels, see how self-service and knowledge articles change the workload, cost the HR function per employee and plan the team size, then clean a raw case export, map demand by weekday and time slot, follow the backlog and the age of open cases, run phone-desk, satisfaction and quality measures, weight the workload by case mix, turn paid hours into productive hours, forecast with seasonal indices, price every channel and finish with a service scorecard, in 20 hands-on labs with every cell checked as you go.

20 lessons · 20 labs

People data is full of small calculations that have to be right: hours into gross pay, applicants needed per hire, headcount against budget, and how many people a 24/7 post really requires. These courses collect the Excel skills used by payroll administrators, recruiters, HR assistants and workforce planners, together with benefits budgeting, contingent labour costs and engagement-survey analytics. Labs use realistic fictional data, so nothing is real personal information.

This topic hub gathers 15 HR, Payroll & Workforce Analytics courses from HR, Business, Accounting: 5 beginner, 9 intermediate, 1 advanced. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: payroll excel template; time to fill recruiting metrics; headcount planning excel; workforce planning excel.

Frequently asked questions

Which HR, Payroll & Workforce Analytics course should I start with?

Start with “Excel for HR Assistants”. It is a beginner-level course, so no prior knowledge is assumed. Then move on to the more specialised courses in the list above.

How much do the HR, Payroll & Workforce Analytics courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the HR, Payroll & Workforce Analytics courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses