@excelerateau: Building a staff roster from scratch in Excel? This tutorial shows the core workflow: create a 4-week date grid, group staff by type, use conditional formatting for roster codes, then tally shifts with SUMPRODUCT + COUNTIF. The finished logic connects naturally to my Excel Employee Roster Template for rotating shifts, hours and workforce planning. Save this for your next roster build. The ready-made template is available from ExcelerateAU on Etsy. #excel #exceltutorial #exceltemplate #staffscheduling #exceltips

excelerateau

Open In TikTok:

Region: AU

Thursday 17 September 2026 00:41:00 GMT