Question

Process of timetable making in worksheet of excel

Answer 1

Answer:

Using the Excel work schedule

Select the work schedule template manually by dragging an area with the mouse that covers all relevant cells.

Copy the table into your new worksheet.

Click on the SmartTag “(Ctrl)” in the lower-right corner of the inserted table.

Answer 2

1. Choose an area of your work schedule and list the names of all your employees. Write each employee’s name in a separate cell. In our example, Matthew S. is assigned to cell L9.
2. Enter the following formula in the adjacent cell M9: NUMVERIF(C2:I29;“Matthew S.”)
3. In our example, area C2:I29 represents the totality of cells in which employees can be entered and counted in their respective shifts.
4. Excel now automatically counts all Matthew S. entries in the work schedule and displays the total in cell M9. If you enter additional shifts for Matthew S., the numerical value is updated automatically.
5. Formatting the layout of your work schedule should be done at the very end. You can use the “Fill color” button on the “Start” tab to color rows, columns, or individual cells differently in order to highlight them. Remember, however, to explain the coloring using a legend for your employees.
6. Do not forget to activate the border lines with the button of the same name. This is the only way to clearly separate the individual cells of your tabular work schedule.
7. Finally, you can protect your work schedule from being edited by others by activating “write protection” in the “Check” tab.