Uploaded April 2024 | Updated September 2026, 2 weeks ago
Please check the previous videos on this series in creating a #dashboard in #excel to track Employee Leave and Attendance in this playlist:
youtube.com/playlist?list=PLPA6EhiqturT9QdCVqFMkbH3RAcvWe_ky
In continuation with our videos on building an #interactive Team Dashboard, where in the previous video we've looked at creating the needed named ranges & the logic behind the formula to populate the team dashboard.
This video is all about writing the formula that would populate the status of the employee on any given day for the chosen month. We'll use some key Excel functions like INDEX, MATCH, IFERROR, and more inside a nested IF in this.
Check our Human Resources templates from INDZARA that are ready to use, ranging from recruitment, compensation, leave, and vacation tracking to retention here:
indzara.com/hr-excel-templates
#dashboard #exceltutorials #exceltemplates
Please check the previous videos on this series in creating a #dashboard in #excel to track Employee Leave and Attendance in this playlist:
youtube.com/playlist?list=PLPA6EhiqturT9QdCVqFMkbH3RAcvWe_ky
In continuation with our videos on building an #interactive Team Dashboard, where in the previous video we've looked at creating the needed named ranges & the logic behind the formula to populate the team dashboard.
This video is all about writing the formula that would populate the status of the employee on any given day for the chosen month. We'll use some key Excel functions like INDEX, MATCH, IFERROR, and more inside a nested IF in this.
Check our Human Resources templates from INDZARA that are ready to use, ranging from recruitment, compensation, leave, and vacation tracking to retention here:
indzara.com/hr-excel-templates
#dashboard #exceltutorials #exceltemplates
