Leave & Rota Planning: PTO Accruals, Holiday Liability & Shift Coverage
Set leave entitlements by service tier, pro-rate joiners and leavers, track accruals and the carry-over cap, count leave days around rest days and public holidays, value unused leave, score absence patterns, check a shift rota against minimum staffing, price night and weekend premiums and build a team leave calendar – 8 hands-on labs at one hotel, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you build an HR coordinator's leave and rota workbook for a fictional hotel, one checked formula at a time. You look up leave entitlements by service tier with XLOOKUP and pro-rate them for joiners and leavers to the nearest half day. You calculate monthly accruals, available balances and the carry-over cap with MIN, count the real working days of each request with NETWORKDAYS.INTL, custom rest days and public holidays, and value unused leave as a holiday liability by cost centre. Then you score absence patterns with the Bradford factor, check a weekly shift rota against minimum staffing, price night and weekend premiums and build a team leave calendar that flags clash days.
Lessons
- Annual Leave Entitlement: Service Tiers, Joiners, Leavers & Half Days Pro
- Accruals, Balances & the Carry-Over Cap Pro
- Counting Leave Days: Custom Rest Days & Public Holidays with NETWORKDAYS.INTL Pro
- Holiday Liability: What Unused Leave Is Worth, by Cost Centre Pro
- Absence Patterns: Spells, Days & the Bradford Factor Pro
- Shift Rota Coverage: Staff per Shift vs Minimum Staffing Pro
- Overtime & Premium Hours: Nights, Weekends and the Weekly Contract Pro
- Capstone: Team Leave Calendar, Daily Overlaps & the Busiest Day Pro