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.
- 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
- Team Cost Budget: Salaries, On-Costs and Cost per FTEFree
- Budget vs Actual: Variances and Lines to Review Locked
- Shift Rota: Coverage per Day with COUNTIF and COUNTIFS Locked
- Holiday Requests: Workdays and Overlap Check Locked
- Workload and Capacity: Who Is Overloaded? Locked
- KPI Tracker: Targets, Scores and Traffic Lights Locked
- Performance Reviews: Weighted Scores and Rating Bands Locked
- 1:1 Meeting Tracker: Days Since and Overdue Check Locked
- Training Budget: Prioritise Requests Within the Budget Locked
- Overtime Cost Check: Hourly Rates, Premium and Budget Locked
- Hiring Cost and Time to Productivity Locked
- Mid-course Project: Monthly Team Report – Unit Costs, Productivity and a Chart Locked
- Staffing by Hour: Contacts, Handle Time, Advisors Needed & the Gap to the Rota Locked
- Next Year’s Team Budget: a Pay Rise from April, a New Hire from May & Monthly Phasing Locked
- What Meetings Cost: Person-Hours, Money per Year & the Share of Team Time Locked
- Team Absence Rate: Available FTE Days, Monthly Rates, a Rolling Three Months & Year to Date Locked
- Complaint Reasons: Shares, Cumulative Share & the Vital Few That Cause 80% Locked
- Backlog Burn-Down: New vs Closed Tickets, the Backlog Trend & Weeks to Clear Locked
- Fair Weekend Rota: Saturdays Worked, a Fair Share by FTE & Who Is Asked Next Locked
- Final Project: The Quarterly Team Pack – Service Level, Cost per Ticket & Absence vs Targets Locked
Learner reviews
Be the first to review this course.