Uploaded May 2024 | Updated November 2026, 1 day 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
The last video gets straight to the logic and the formula to populate the calendar data in the Employee report. In this video, we'll look at how to apply 2 types of conditional formatting using formulas for weekends, holidays, and other vacation types on this 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
The last video gets straight to the logic and the formula to populate the calendar data in the Employee report. In this video, we'll look at how to apply 2 types of conditional formatting using formulas for weekends, holidays, and other vacation types on this 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










