How to Create Work Schedules

Growth Trends for Related Jobs

Although many places of business close down around 5 or 6 o'clock in the evening, there are other businesses that stay open longer. Likewise, there are other businesses that stay open 24 hours a day. Places like restaurants, gas stations, hospitals and movie theaters cannot expect all of their employees to simply come from 9:00 a.m. to 5:00 p.m. Therefore, managers of these establishments must be able to create schedules to make sure there are always people available to staff the businesses during all open hours. This includes requiring some employees to come early in the day, and others to come later.

Open Microsoft Excel by clicking on the "Excel" icon in the Programs folder in the Start menu of the computer.

Click on the "File" button on the top left corner of the screen after Excel has opened. A drop-down menu will open. Click on "New." A New Workbook window will appear.

Find the "Templates" header on the top left side of the page. Just underneath this will be a header that says "Microsoft Office Online." Under this header, several types of documents can be viewed. Click on "Schedules."

Click on "Work Schedule" in the next window that opens. Then, click on the "Download" button on the bottom right-hand side of the window.

Fill in the necessary information after the page downloads and opens. The form allows you to enter information about daily and weekly hours worked. It also includes a space for employee names and the dates worked.


If there are employees that work the same hours each week, highlight their names and hours in green. When the next week comes, you can simply transfer their names and hours to the next week without making changes.


Scheduling employees for holidays and weekends is not something most people want to do; however, when the schedules are being made, it is important to spread these assignments around.