How to create a Work Schedule (Roster) using Excel

💥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-e...
⏱ 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

[@chandoo_]

💥Get Connecteam for FREE 👉 connecteam.cc/3QSAjlQ Use it to manage your staff, shift schedules and vacation details and so much more.

[@adipazz]

Really nice app! We have it for years now and we all love it! Employees and managers

[@abbylynn8872]

I absolutely love your sense of humor. 😂😂😂 Thank you for all you do to pull and push us along in this data journey💕

[@jeekakrishna]

exactly 😂😂e

[@chrism9037]

Great video, thanks Chandoo!

[@user-tw2cd4yq5s]

Your classes are, so much useful for beginners, sir

[@erniesak]

You are so good with explaining concept. god of exce. How did you become so good with excel?

[@Mahi_paul]

Praise the Lord Brother 🎊

[@arbazahmad7177]

Excellent 🎉thanks for sharing 👍

[@chandoo_]

Thanks for watching

[@rashs9901]

Helpful ..

[@ramilaquino5350]

Which version of 365 are you using? I'm using 365 as well but I don't have that Place in cell option yet.

[@kirankali8096]

Amazing Sir, could pls schedule live session for Q & A, tq

[@lifecycles9625]

Please can you do a video on what Power Bi is and what it is used for?

[@AnupamaJoze]

Hi. ..Are you able to do video about Business Analyst tutorial and give some projects to try out pls

[@barttitulaerexcelbart9400]

Hi Chandoo. Very nice made! One other drawback of this model is that it only sees one month. What if an employee worked many hours in the previous month? You want to take this into consideration as well. You also want to see the cumulative hours per year. For calculating the numbers of days per employee you used the VSTACK, but why did you not just used COUNTIF and use the “planning range” as input?

[@warmachine676]

As a beginner how can i be good at Excel? What is the proper roadmap? It will be very helpful for me. Thanks.

[@tofikqureshi3662]

Chandoo pls love from india. I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help

[@tofikqureshi6507]

Hello Sir Pls help me I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help

[@richaarora1939]

Hey Chandoo, would you be able to create step by step excel sheet for staff timesheet. As staff comes in they can scan their unique barcodes and the sheet takes the time. Time in, time out, break in, break out and lunch in, lunch out, time out. Total hours of shift worked deducting break times. Thanks

[@debbyroseanalytics]

Hey Chandoo Have you gotten the technical writer? Or you are still accepting applications?

[@gaganwadhwafreelancer]

Hi chandoo hope so you are doing well. I have a query. Let's say we are having two cols Named Category and Subcategory. Like List A List B Category 1 S1 Category 1 S2 Category 1 S3 Category 1 S4 Category 2 H1 Category 2 H2 Category 2 H3 Category 2 H4 What i want Category 1 S1 S2 S3 S4 Category 2 H1 H2 H3 H4 In a simgle column. For creating drop down.

[@jakhongirmuratov1652]

Thank you! Is it possible to learn python 3 on codecademy?

[@TravelwithSatya]

Large bush…😂

[@chandraprakashmogha1745]

Can anyone start a data analytics company for small business company using only Excel expertise

[@USMANkhan73090]

Hello bro I'm from Pakistan I want to learn Data analyst basic to advance and go to usa uk or canada for data analyst job thanks

[@189HK]

hello, i am from India and want to take your classes available on the website. Can you provide google pay (G-PAY) option?

[@moazzamkhan398]

Large Bush 😂😂😂

[@NightCreeper666]

Hi, looks download file doesn't exist, ( page not found)|, any chance you can update. Thanks for all knowledge that I've gained thanx to you.

[@chandoo_]

Hey... Try again please. It works now.

[@Shifter-bp2hu]

Your employee list isn't dynamic? Use in AM5: =unique(filter(B5:B15,B5:B15"","")) and in the list conditional formatting =$AM$5#

[@tantrikgamer6089]

data download is not working

[@chandoo_]

Try again please. It works for me.