How to create a work schedule in Excel

Dive into this step-by-step tutorial and learn how to create a work schedule in Excel. Regardless if you're an Excel veteran or just a beginner, this video will guide you through the simple steps in crafting your very own work schedule. The video includes everything from inputting data to formulating a schedule that suits your needs. Master this crucial technique that can streamline your daily operations, improve team communication, and increase productivity.

#excel
#exceltutorial
#excelforbeginners
#workschedule
#microsoftoffice

[blueskyguy]

Very clear and can be duplicated. If possible create a schedule tutorial that lists multiple locations that an employee would work at, for example : Employee A works at location 123 on Mon and Tuesday and location 567 on Wed, etc

[laxmandissanayake]

thank you for much. i learnt something new today. All the best.

[akatsukimoonlxrd]

the clam river flow sound in the background is really peacefull thanks

[pradeepielts]

Thank you! No one has explained it as simple as this! Keep it up...👍

[itspzvm]

This is so helpful !!! I could not have done this without you! Thank you!!!

[francispasqua]

Thank you very much! Love from Colombia

[dannellraven]

Thank you soooo much for this video. I am a new HR professional and making schedules will be new for me, especially calculating hours for payroll. How would I calculate hours when everyone won’t work 8 hours a day?

[karlacamarena]

Omg thank you soooo much I love it❤just created one. I watched so many and none worked

[Aminuibrahimsulaiman-jhjb]

This is impressing, I learned and understood many things from this video

[mnlqvzv]

I understood very well. I’m not computer savvy at all.

[valentinlishkov]

online scripys for spur gears an chain gears
economical linear cut
online scripys for sheet material products (cones, elbows,
transition square to round section, transition rectangle to round section )

[kbetc.]

thank you so much for this, ive already successfully made my table. What formula do you use if the hours per day are different?

[StellyHubTV]

You teaching is excellent, pls can you teach data cleaning and validation in excel.Thank you

[FxQ]

its very helpful indeed and clear instruction thx you very much

[wajeehkhalil]

your way of teaching is so amazing. you explain it with peacfully, straight to the point and explain the formulas very clearly. i loved it and did it in the first try which never happened with other teachers. keep teaching. I would like to know how you can make a calender for a year like this without wasting much time because for one month you can fill the series for 30/31 but for whole year do we need to do for each months or there is a magic trick, please explain. Thanks

[John-]

This is a marvel. I read a book with similar content, and it was a marvel to behold. "Dominating Your Clock: Strategies for Professional and Personal Success" by Anthony Rivers

[Deidre]

Thank you! Was wondering what formula would be used if there are half days of work?

[kylegurney]

is there a way to turn this to ICAl or ICS format so everyone can get their schedule automatically updated on their personal calendar?

[shambalamaria]

The total hours didn’t work for me. Do you mind explain the formula. I’d like to have total weekly and monthly worked hours without having a column for total daily worked hours. Thx for the helpful video.

[jennsopinion]

When I put the day name and drag it to the end of the numbers, it doesn’t auto pop the different days of the week. Only the same day name