How to create a Work Schedule (Roster) using Excel @chandoo_
How to create a Work Schedule (Roster) using Excel  @chandoo_
Uploaded February 2024 | Updated November 2026, 2 hours ago
๐Ÿ’ฅGet Connecteam for FREE ๐Ÿ‘‰ connecteam.cc/3QSAjlQ

~

Recently I made this beautiful, interactive and automated Employee Roster using Excel. In this video let me explain how I made it and how you can use it to assign employees to shifts.

Using this scheduling tool, you can plan and set up your employees on an interactive calendar view.

Using this roster you can,
๐Ÿ‘‰ You can set up (upto 3) employees on shifts across a 4 week grid.
๐Ÿ‘‰ See who is working on what days with staff pictures
๐Ÿ‘‰ Manage employee's time off and get alerted if you map someone on their day off.
๐Ÿ‘‰ Look at staff allocation and workloads in a graph to see who is doing more and who is doing less work.
๐Ÿ‘‰ Beautiful, simple and elegant worksheet to interactively manage the shift / roster.


๐Ÿ“ DOWNLOAD THE ROSTER
========================
chandoo.org/wp/staff-roster-excel-template-free


โฑ IN THE VIDEO:
===============
0:00 - Staff Roster Demo
1:38 - Key components of the staff roster workbook
2:15 - Staff Roster - 4 Week Grid Set up
3:45 - How to show the Employee Profile Picture dynamically
4:45 - Warning icon set up with formulas and conditional formatting
6:53 - Workload (resource utilization) calculation and graph
9:00 - 3 Problems with my roster and the solution

~

#EXCEL #roster
How to create a Work Schedule (Roster) using ExcelFind the Longest Winning Streak in Excel #excel #tutorial #exceltipsLearn Tableau in 15 minutes and create your first report (FREE Sample Files)Can I Make an Entire Dashboard with One Formula?Dynamic Moving Averages with *new* MAP FunctionHow to make an interactive TOP 10 Chart with Power BI (using parameters)ONLY Excel pros use this INDEX MATCH trick ๐Ÿ’กTOP 10 XL Functions #excelLearn For Loop in Python Properly (with sample code ๐Ÿ‘ฉโ€๐Ÿ’ป)Auto Format Excel numbers in thousands / millions / billions - 2 TRICKS๐Ÿ’กWhat is ETL with a clear example - Data Engineering ConceptsHow I made a COLOURFUL slicer in Power BI ๐ŸŽจ
Chandoo |

How to create a Work Schedule (Roster) using Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER