Tabellab

Timesheets for Payroll: Regular Hours, Overtime and Week Pay

Lesson 8 of 20 Lab 🔒 Locked

Lessons in this course

  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