Tabellab
HR & People Ops Beginner

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 Certificate

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

About this course

This beginner course follows the HR assistant of a fictional 60-person wholesaler through 20 labs. You clean the employee list and look up departments, count headcount and FTE, calculate tenure, list birthdays and anniversaries, track time-to-hire and cost per hire, work out leave balances, prepare overtime for payroll, check compa-ratios, turnover and training hours and build an HR dashboard. The second half adds everyday tools: splitting names and building email addresses, FILTER, SORT and UNIQUE lists, pay-scale lookups by grade and step, probation and contract end dates with EDATE, headcount on any date from start and leaving dates, salary changes with back pay, input rules with data validation and a monthly HR report with a consistency check and a combo chart. Every cell is checked instantly; all people and figures are fictional.

Lessons

  1. Employee List: Clean Names and Look Up Department and ManagerLabFree
  2. Headcount by Department with COUNTIF and COUNTIFSLab Locked
  3. Tenure from Start Dates: DATEDIF and YEARFRACLab Locked
  4. Birthdays and Work Anniversaries This MonthLab Locked
  5. Hiring Pipeline: Time-to-Hire and Open RolesLab Locked
  6. Recruiting Cost per Hire by SourceLab Locked
  7. Leave Balances: Accrual, Days Taken and Overdrawn LeaveLab Locked
  8. Timesheets for Payroll: Regular Hours, Overtime and Week PayLab Locked
  9. Salary Bands and Compa-RatioLab Locked
  10. Employee Turnover Rate by Month and for the Half-YearLab Locked
  11. Training Hours Tracker: Hours per Department and per HeadLab Locked
  12. HR Dashboard: Headcount Chart and Turnover AlertsLab Locked
  13. Names and Email Addresses: Splitting Full Names, Building Logins & a Salutation LineLab Locked
  14. Dynamic HR Lists: FILTER by Department, SORT by Start Date & UNIQUE LocationsLab Locked
  15. Pay Scale Lookups with Two Keys: Grade and Step, Part-Time Salaries & Next Year’s Step IncreasesLab Locked
  16. Fixed-Term Contracts & Probation: End Dates with EDATE, Days Left & a 30-Day Reminder ListLab Locked
  17. Headcount on Any Date: Active Employees, Joiners and Leavers per Month from Start and Leaving DatesLab Locked
  18. Salary Changes for Payroll: Percentage Raises, Effective Dates & Back PayLab Locked
  19. Input Rules for the Employee List: Drop-Down Lists, Allowed Hours & FTE, and Counting Old ErrorsLab Locked
  20. Final Project: The Monthly HR Report – Headcount Movements, a Consistency Check, Turnover & a Combo ChartLab 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