Automatic Employee Attendance Tracker in Excel (Effectively Track your Employee's Attendance Record)
Vložit
- čas přidán 11. 09. 2021
- Automatic Employee Attendance Tracker in Excel (Effectively Track your Employee's Attendance Record)
In this video you will learn how to create an automatic employee attendance tracker. Use of Date, Eomonth, Text, Countif, Data Validation, Conditional formatting etc, has made this template dynamic. Our step by step guideline on making this will assist you with creating this dynamic attendance tracking sheet.
Download the practice workbook file used in this video from link given below.
spreadsheetlearning.com/wp-co...
#excel
#employeeattendancetracker
#Attendancetrack
Superb , was very helpful and explained perfectly.
Glad it was helpful!
This was so helpful. I am shocked!!! I took my time and went step-by-step with you, and I now have a huge amount of respect for excel!! Thank you.
Thank you ❤️
Thank you for guidance. ❤
Welcome
Thank you so much!
You're welcome!
Thank you sir
so helpful on my project
Thank you very much for this video. Please i will love to know, how do you design an attendance tracker that can show mutiple employees total hours worked in a week and a month, using a singular sheet.
I love this video! ♥️♥️♥️
Thank you
You are a great teacher. I enjoyed your lesson.
Please, how can I do this successfully using mobile android? I have already started but got stuck at inputing the month, there are no such things as data source on mobile.
I love you, you are a good teacher. Please, how can I create a list on mobile?
is there a way to retain data per month? or do we have to always clear it manually every time we change the month?
Good work bro
Thank you
مرسی
I did it. ☺️ Thanks but I hope there is a way that no need to copy the sheet 😅 but it's good
Welcome
This is has been very helpful thank you. How do I highlight both Saturday and Sunday please
For highlight all Sunday, repeat the same conditional formatting as I do for Saturday 🙏
Hi could you please share the a prepared Attendance Tracker??
Hi, problem with the month. if you change the month the information will all stay there. as example if the 1st September 2021 i said that employee A is in Holiday and i change the month in febraury, the tracker will say that the employee is on holiday on 1st of february :/ hope is make sense XD
After changing the month, previous data needs to be cleaned at the beginning of new month, keep backup every month data at the end of month
the problem is that we cannot put mor than 5 employees did you have a solution. for that .. thanks
This is just for example, u can expand the row as required
Thanks for this. But can you not create a one sheet for all the month such that if you move from month to month within the same sheet, the data of the previous month will disappear so you can enter data for the current month you are on.
have you found the solution to this? sorry 4 months late hehe
@@Psygnosis I have not found a solution yet. Can you help?
@@jamesleleji9470 hello, unfortunately the function we are looking for needs macros to be enabled. Which google sheet doesn't have. It has something else which is called Apps Scripts.
@@jamesleleji9470 Here's the video I found that could somehow work, but I havent tried coding from macros to apps script.
czcams.com/video/OPypfBBUGXo/video.html
@@Psygnosis Thanks, i will try it.
How can I lock the attendance? I don't want it to be created by sheets.
To lock, use the sheet protection option in Home >Format>Protect Sheet
If you want second method of creating , this video might help: czcams.com/video/_SWcjE8S8hk/video.htmlsi=EOp0OEDfbGrsKea7
Would it be possible to send this template?
This you can download from
www.spreadsheetlearning.com
Full leave ke liye
Sir Sand me excel file please
It is possible to send me the file ?thanks
How to download this file
Please write a mail to spreadsheetforu@gmail.com for template
Sir
If we fill Presence and Absence manually than it's not Automatic Attendance Sheet
Let's say it half Automatic then🙂
@@spreadsheet_power
Watch full video Fully Automatic Attendance Sheet in Excel without VBA than you get the answer of your question