Timesheets for Payroll: Regular Hours, Overtime and Week Pay
Lessons in this course
- Employee List: Clean Names and Look Up Department and ManagerFree
- Headcount by Department with COUNTIF and COUNTIFS Locked
- Tenure from Start Dates: DATEDIF and YEARFRAC Locked
- Birthdays and Work Anniversaries This Month Locked
- Hiring Pipeline: Time-to-Hire and Open Roles Locked
- Recruiting Cost per Hire by Source Locked
- Leave Balances: Accrual, Days Taken and Overdrawn Leave Locked
- Timesheets for Payroll: Regular Hours, Overtime and Week Pay Locked
- Salary Bands and Compa-Ratio Locked
- Employee Turnover Rate by Month and for the Half-Year Locked
- Training Hours Tracker: Hours per Department and per Head Locked
- HR Dashboard: Headcount Chart and Turnover Alerts Locked
- Names and Email Addresses: Splitting Full Names, Building Logins & a Salutation Line Locked
- Dynamic HR Lists: FILTER by Department, SORT by Start Date & UNIQUE Locations Locked
- Pay Scale Lookups with Two Keys: Grade and Step, Part-Time Salaries & Next Year’s Step Increases Locked
- Fixed-Term Contracts & Probation: End Dates with EDATE, Days Left & a 30-Day Reminder List Locked
- Headcount on Any Date: Active Employees, Joiners and Leavers per Month from Start and Leaving Dates Locked
- Salary Changes for Payroll: Percentage Raises, Effective Dates & Back Pay Locked
- Input Rules for the Employee List: Drop-Down Lists, Allowed Hours & FTE, and Counting Old Errors Locked
- Final Project: The Monthly HR Report – Headcount Movements, a Consistency Check, Turnover & a Combo Chart Locked