Uploaded April 2024 | Updated November 2026, 5 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 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
🚀 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 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
🚀 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