FormulaCamp
Completed
← All paths
Learning paths

Excel for HR & People Ops

Excel for HR: headcount and turnover reports, tenure and leave calculations, clean employee lists, payroll sheets and protected workbooks.

27 lessons · about 7.1 h · 17 lessons are free

0 of 27 lessons done

Start the path

Who it is for

HR generalists, recruiters, payroll and people-operations specialists who keep employee data, time off and headcount in Excel.

What you will be able to do

  • Track headcount, new hires and turnover by department with PivotTables and charts
  • Calculate tenure, probation end dates, working days and overtime from dates and times
  • Keep clean employee lists with dropdowns and validation, free of duplicates and typos
  • Build a payroll sheet and protect sensitive columns before you share the file

Lessons in this path

  1. 1Cells, Rows and RangesFreelesson15 min
  2. 2Data Types: Numbers, Text, Dates, LogicFreelesson15 min
  3. 3Cell FormatsFreelesson15 min
  4. 4Your First FormulaFreelesson15 min
  5. 5The SUM FunctionFreelesson15 min
  6. 6Counting: COUNT, COUNTA, COUNTBLANKFreelesson15 min
  7. 7The IF FunctionFreelesson15 min
  8. 8Nested IF and IFSFreelesson15 min
  9. 9AND, OR, NOTFreelesson15 min
  10. 10COUNTIF and SUMIFlesson15 min
  11. 11Multiple Conditionslesson15 min
  12. 12The VLOOKUP FunctionFreelesson15 min
  13. 13Splitting Stringslesson15 min
  14. 14Cleaning Datalesson15 min
  15. 15Dates Are Numberslesson15 min
  16. 16Tenure, Deadlines, Weekdayslesson15 min
  17. 17Workdayslesson15 min
  18. 18Time and Paying Hourslesson15 min
  19. 19Data Validation and Dropdown ListsFreelesson15 min
  20. 20Dependent Dropdown Listslesson20 min
  21. 21Duplicates and Text to ColumnsFreelesson15 min
  22. 22Filter and SUBTOTALFreelesson15 min
  23. 23PivotTableFreelesson15 min
  24. 24PivotTable with Rows and ColumnsFreelesson15 min
  25. 25ChartsFreelesson15 min
  26. 26Project: Payroll SheetFreeproject30 min
  27. 27Protecting Sheets and Workbookstheory and quiz15 min

Interview-style questions

Typical tasks and questions for this role. Each one is taught in a lesson of the path.

  1. How do you calculate each employee's tenure in years and months from their hire date?

    Learn it in: Tenure, Deadlines, Weekdays

  2. Given a start date and 20 working days of leave, how do you find the return date, skipping holidays?

    Learn it in: Workdays

  3. Show headcount by department and gender in a few clicks. What tool do you use?

    Learn it in: PivotTable

  4. A candidate list has duplicates and full names in one cell. How do you clean it?

    Learn it in: Duplicates and Text to Columns

  5. How do you share a salary workbook while keeping some columns hidden and locked?

    Learn it in: Protecting Sheets and Workbooks

Other paths