Uploaded May 2024 | Updated November 2026, 2 days 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 the last video, we looked at how to apply 2 types of conditional formatting using formulas for weekends, holidays, and other vacation types on this report. In this video, we'll calculate the monthly summary of all the vacation and leaves for the employee in the employee report.
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 the last video, we looked at how to apply 2 types of conditional formatting using formulas for weekends, holidays, and other vacation types on this report. In this video, we'll calculate the monthly summary of all the vacation and leaves for the employee in the employee report.
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










