Tabellab

Excel for New Team Managers: Team Budget, Schedules, KPIs & Reviews

20 hands-on labs for first-time managers of a small team: team cost budget, budget vs actual, rota coverage, holiday overlaps, workload, KPI traffic lights, weighted reviews, 1:1 tracker, training budget, overtime, hiring cost and a monthly report – then staffing by hour, next year’s budget by month, meeting costs, team absence rates, complaint reasons, a backlog burn-down, a fair weekend rota and a quarterly team pack.

20 lessons 20 labs Certificate

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

About this course

This course gives first-time managers the spreadsheets they need in their first year. In 20 hands-on labs you build a team cost budget with on-costs and cost per FTE, compare budget and actual, check rota coverage with COUNTIFS, test holiday requests for overlaps, compare workload with capacity, score KPIs with traffic lights, weight review criteria, track 1:1s, prioritise training requests, cost overtime and hiring, and report unit costs. The second part plans staffing hour by hour from contacts and handle time, phases next year’s budget by month with a pay rise and a new hire, prices recurring meetings, tracks the team absence rate, finds the vital few complaint reasons, forecasts a backlog burn-down, shares weekend shifts fairly by FTE and finishes with a quarterly team pack against targets.

Lessons

  1. Team Cost Budget: Salaries, On-Costs and Cost per FTELabFree
  2. Budget vs Actual: Variances and Lines to ReviewLab Locked
  3. Shift Rota: Coverage per Day with COUNTIF and COUNTIFSLab Locked
  4. Holiday Requests: Workdays and Overlap CheckLab Locked
  5. Workload and Capacity: Who Is Overloaded?Lab Locked
  6. KPI Tracker: Targets, Scores and Traffic LightsLab Locked
  7. Performance Reviews: Weighted Scores and Rating BandsLab Locked
  8. 1:1 Meeting Tracker: Days Since and Overdue CheckLab Locked
  9. Training Budget: Prioritise Requests Within the BudgetLab Locked
  10. Overtime Cost Check: Hourly Rates, Premium and BudgetLab Locked
  11. Hiring Cost and Time to ProductivityLab Locked
  12. Mid-course Project: Monthly Team Report – Unit Costs, Productivity and a ChartLab Locked
  13. Staffing by Hour: Contacts, Handle Time, Advisors Needed & the Gap to the RotaLab Locked
  14. Next Year’s Team Budget: a Pay Rise from April, a New Hire from May & Monthly PhasingLab Locked
  15. What Meetings Cost: Person-Hours, Money per Year & the Share of Team TimeLab Locked
  16. Team Absence Rate: Available FTE Days, Monthly Rates, a Rolling Three Months & Year to DateLab Locked
  17. Complaint Reasons: Shares, Cumulative Share & the Vital Few That Cause 80%Lab Locked
  18. Backlog Burn-Down: New vs Closed Tickets, the Backlog Trend & Weeks to ClearLab Locked
  19. Fair Weekend Rota: Saturdays Worked, a Fair Share by FTE & Who Is Asked NextLab Locked
  20. Final Project: The Quarterly Team Pack – Service Level, Cost per Ticket & Absence vs TargetsLab 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