Uploaded April 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 continuation of the previous video where we've created an EMPLOYEE sheet, this video focuses on:
0:20 Creating a VACATION sheet
1:08 Convert to a table
2:15 Apply data validation to omit erroneous data entry
4:01 Create a Named Range for Vacation Type
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
๐ NEW LAUNCH: Indzara Apps!
Take it further with Indzara Apps!
โ Work seamlessly across desktop, tablet, and mobile
โ No setup, formulas, or file management required
โ Your data is saved and ready whenever you need it
๐ LAUNCH OFFER: FLAT 50% OFF for the first 100 customers!
Try Indzara Apps today and make your work simpler ๐
๐ฅ PEOPLE โ Leave Management App
โ go.indzara.com/people/yt
๐ PROJECTS โ Resource Capacity Planning App
โ go.indzara.com/projects/yt
๐ฆ BUSINESS โ Stock Management App
โ go.indzara.com/business/yt
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 of the previous video where we've created an EMPLOYEE sheet, this video focuses on:
0:20 Creating a VACATION sheet
1:08 Convert to a table
2:15 Apply data validation to omit erroneous data entry
4:01 Create a Named Range for Vacation Type
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
๐ NEW LAUNCH: Indzara Apps!
Take it further with Indzara Apps!
โ Work seamlessly across desktop, tablet, and mobile
โ No setup, formulas, or file management required
โ Your data is saved and ready whenever you need it
๐ LAUNCH OFFER: FLAT 50% OFF for the first 100 customers!
Try Indzara Apps today and make your work simpler ๐
๐ฅ PEOPLE โ Leave Management App
โ go.indzara.com/people/yt
๐ PROJECTS โ Resource Capacity Planning App
โ go.indzara.com/projects/yt
๐ฆ BUSINESS โ Stock Management App
โ go.indzara.com/business/yt










