How to Create an Employee Task Schedule
Getting tasks allocated to employees can be a challenging part of running any business. Making a schedule can go a long way toward reining in the chaos and getting things done efficiently and on time. A task schedule clearly shows each day, what must be done at any given time, by whom it must be done and when. A clear and useful schedule can be made with ordinary spreadsheet software, such as Excel or OpenOffice.
Other People Are Reading
Instructions
-
Procedure
-
1
Create a new spreadsheet. Click the "File" menu and then click "New."
-
2
Type the employee's name in the first row and first column. This will make it easy to identify the owner of the schedule.
-
-
3
Type the days of the week in the second row, leaving the first column blank. The first column will be used for the time of day. Using boldface for these names will make them easier to see.
-
4
Type time periods in the first column, column A, starting at row 3 (below the days of the week). The exact time periods you should use depend on your business; you might use hours such as "9 AM," "10 AM," etc. or larger divisions, such as morning, afternoon and evening. Again, boldfacing these will make them easier to see.
-
5
Type tasks into the grid you've just made. For each day of the week and time period, add the task you want performed at that time.
-
6
Print your schedule and distribute it to the employee involved.
-
1
Tips & Warnings
Consider adding a border to some or all tasks to make them more visually distinct. To do this, highlight the cells where you want to add a border. Then click the "Format" menu, followed by "Cells." In the popup that appears, click the "Borders" tab to create a border around the selected cells.
