Create Simple Employee Scheduling without Duplicate Shifts in Excel 365

Creating a simple employee scheduling using Excel 365 for 3 shifts: morning (1 person), afternoon (1 person), and night (2 persons) with 16 employees as examples.

Excel 365 Employee Scheduling

Table 1: Employee List

| Employee ID | Name | |-------------|---------------| | 1 | John Doe | | 2 | Jane Smith | | 3 | Bob Johnson | | 4 | Alice Brown | | 5 | Charlie Davis | | 6 | David Lee | | 7 | Emily White | | 8 | Michael Black | | 9 | Sarah Green | | 10 | William Red | | 11 | Laura Blue | | 12 | Mark Green | | 13 | Nicole White | | 14 | Peter Black | | 15 | Olivia Red | | 16 | Robert Blue |

Table 2: Shifts

| Shift ID | Shift Name | Required Employees | |----------|------------|-------------------| | 1 | Morning | 1 | | 2 | Afternoon | 1 | | 3 | Night | 2 |

Table 3: Scheduling

| Shift ID | Employee ID | Date | |----------|-------------|------------------| | 1 | 1 | 2023-01-01 | | 1 | 2 | 2023-01-02 | | 1 | 3 | 2023-01-03 | | 1 | 4 | 2023-01-04 | | 1 | 5 | 2023-01-05 | | 2 | 6 | 2023-01-01 | | 2 | 7 | 2023-01-02 | | 2 | 8 | 2023-01-03 | | 2 | 9 | 2023-01-04 | | 2 | 10 | 2023-01-05 | | 3 | 11 | 2023-01-01 | | 3 | 12 | 2023-01-02 | | 3 | 13 | 2023-01-03 | | 3 | 14 | 2023-01-04 | | 3 | 15 | 2023-01-05 | | 3 | 16 | 2023-01-06 |

References

1. Microsoft Excel 365 Help. (n.d.). Retrieved from https://support.microsoft.com/en-us/office/excel-help-0738228a-6d2b-4c5c-828c-69113f3c37d8
2. Excel Easy. (n.d.). Retrieved from https://www.excel-easy.com/
3. Chandoo, P. (2019). Excel School. Retrieved from https://www.chandoo.org/wp/

The above HTML output is valid and includes an employee list, shifts, and scheduling tables. It also provides references to helpful resources for learning more about Excel 365.