Indzara - Simple and Effective Templates | Vacation and Attendance Tracker Excel Dashboard - Chapter 2 Lesson 4 - Employees @indzara | Uploaded 2 years ago | Updated October 03 2023
Excel Dashboard Course - Vacation and Attendance Tracker Dashboard
To watch the previous videos in this series, please see
playlist: https://www.youtube.com/playlist?list=PLPA6EhiqturT9QdCVqFMkbH3RAcvWe_ky
Attendance and Leave Tracker Excel template
Entering Employee Data
Create a new sheet if needed or rename the default sheet as EMPLOYEES.
Type a few rows of employee data, to begin with.
The critical fields here are Employee Name, Start Date and End Date.
Now, select the cells and press Ctrl+T to convert to a Table.
Name the table T_EMP.
Name the list of employee names L_EMP.
Excel Dashboard Course - Vacation and Attendance Tracker Dashboard
To watch the previous videos in this series, please see
playlist: https://www.youtube.com/playlist?list=PLPA6EhiqturT9QdCVqFMkbH3RAcvWe_ky
Attendance and Leave Tracker Excel template
Entering Employee Data
Create a new sheet if needed or rename the default sheet as EMPLOYEES.
Type a few rows of employee data, to begin with.
The critical fields here are Employee Name, Start Date and End Date.
Now, select the cells and press Ctrl+T to convert to a Table.
Name the table T_EMP.
Name the list of employee names L_EMP.