Just wanted to say your video is very helpful. I will follow you all video and try to implement same to my process. Waiting for more interesting video.
Thank you so much for these tutorial and how simple you make it for anyone to understand it. I work in a foster children and I have a form in excell that I send to the region to fill out about the children and any services we provided. Most the time, the don't know if the form is sent to me or not. How to make it simple? so everytime they fill out the form, it will be collected the data of the form in a different worksheet as a table. they only have to check the table to see if they send it to me. Usually in the form we have, date of service, name of service, child name, child case number. one child can have more than one services. Thank you so much.
Thanks a lot pro!!! BTW, how to include a Half Day Leave into the tracker? I can do it with similar method with Leave Count but how to make the value as 0.5 for it to tally the actually leave count.
Thanks for this Acutely I was finding something which I haven't get but suddenly I saw your video and which formula I was finding that was in this video finally I take very relax breath thanks
PK: An Excel Expert I have one suggestion for you for the beggner very tuff to understand bcz you did very fast all thing so please try to make little bit slow then beginner can understand better thanks
it is good worksheet although my problem has not been sought out, please help me for find the result of how to identify the exact dates on which employee in being absent or leave pending
Thanks a lot Mr PK. But I noticed Data Bar does not reflect correctly. I had 5 meetings scheduled in different months. I need to track meeting attendants by Present Count, Absent Count, Excused Count, staff A's present count is 3 meaning he attended 3 of the 5 meetings, absent count is 1 meaning he absent 1 of the 5 meetings, Excused count is 1 meaning he has 1 excused absent of the 5 meetings. but the Data Bar shows full color on 1, which should only show very small portion not full color, it's misleading. How can I email you an image if I am not describing clearly here.
Hello sir. Your an expert.. Please upload the video which had 25 employees with productivity and accuracy and also for utilization finally to dashboard for daily reports, monthly and quarterly
Dear friend, your video has very helpful. Your simple and easy to follow instructions make even more attractive. I'm glad that I've stumbled in into your video by mere luck. I think it's my lucky day. Thank you again.
my teacher you help me a lot with this video how to make an attendance tracker may the Lord prosper you and you will be a help to the nation, in professional work many thanks to you .
Thank you so much for nice words. Audience like you always encourage me to do something innovative in Excel. Thanks for watching and sharing your valuable feedback.
@@PKAnExcelExpert I agree it is very helpful ... but ... how come a leaver is present the next day? Once he/she leaves shouldn't the cells afterwards be empty?
@@PKAnExcelExpert When you say "leave" do you mean "authorised leave of absence" or do you mean "quit/fired"? If the person quits then there should be nothing marked after the day they quit?
hello Sir, good job. but i have one question. what should we do for ''WO'' to be filled automatic in Sunday columns . for example if i change the register from March to April then the WO must move automatically to the Sunday column.
Hello Pk I have below query, How shell i do color scale conditional formatting in entire table formatted raw by every alternative column. Also any future raw or column to be added the it also should take similar formatting in auto mode. Thanking you in advance. Regards Bharat
How to take a list of dates of leave types of individual employee? Not total leave , but the leave dates. (eg.CL 5th MARCH EL 11,12,13,14 MARCH, LWP MARCH 20,21,22)
dear Pk when you put the formula , why r you in so hurry ....we know you have master the excel but when you are explaining to new learners try to be slow in explaining the formula .... i hope you understand , try to know how to transform Knowledge transfer ...rest all was good
@@PKAnExcelExpert please assist me on I have created automatic attendance with the help of TH-cam! However if I change the month in dropdown the data of previous data remains there, how can I use properly!! How can check the previous data on single selection in the same sheet!! Is it possible please share this will helpful for many whose having same question
How to improve the accuracy and reduce the redundancy of the data ? By this i mean how to keep the data protected from other employees by avoiding entering wrong data?
Hello , How can i transfer data from Sheet 1 to Sheet 2 daily basis and when data changes in Sheet 1, data is transfer to Sheet 2 without deleting previous data in sheet2 in google spreadsheet
Dear, Your ignoring is very good but am new to learning this and i didn't understand this. Because it's very fast teaching.so pls could you provide another video for us with possible learning speed. I believe you that as you will support about this and am going to subscribe your channel. Thanks BOSS
hello dear PK can u please do real estate tenant tracking sheet , - tenant paid rent -tenant late paid vacancy apartment occupied apartment how can i do it if i have more than one buildings ? thank u very much
Hi, I have given the download link in video's discretion box. Please download this excel file from there. In that Excel file I have given two worksheets. One for Sunday off and second for Sat and Sun off. For shift wise attendance I will create another video very soon.
Dear PK, I don't want to edit manual entries, when a person opening his excel and put Automated PC Date with time, then the excel needs to record and shows the outcome/results in pdf format as a monthly basis. Can we do it? And pl explain slowly, so users can understand
Hi, I have given excel download link in video's discretion box. Please download this excel file from there. I have given 2 sheets one sun off and 2nd for sat and sun off. I hope it will help you.
Hi! I have found your video very useful. Thank you! Do you happen to have any type of video showing how to create a spreadsheet for tracking employee time off (vacation, sick, unpaid, holiday, etc.) that has formulas using a employee anniversary date? Our company offers vacation at anniversary date and not at beginning of the new year. I appreciate any help you may be able to offer.
Do you know how to conditionally format a cell based on the formula in the cell? For example, let's say that I use a formula to compute the value of a given cell. Well, I am trying to do a conditional format based on a string of text that is included in the formula that was used to create the value. (e.g., =if(c3="red apple, "eat apple). I want to conditionally format a cell if the string "red apple" is within the formula. Note, I am not trying to conditionally format the result of the cell; I'm trying to conditionally format based on what's within the formula of the cell. Read more REPLY
Mr pk, please let me know that I want to know the date and time of the data entered in a database (excel workbook) .I need date and time of each data in a database.
Hi Vicky, I have uploaded an excel file on google drive and link has been given in videos discretion box. Please download this excel file from there for better understanding. Thanks for your valuable feedback. I will take care of this thing in my upcoming videos.
Please tell me that how to do the SL as Cl Because in my attendance sheet two column in that manul i can write and one more column in that formulae is there only it will reflect that CL and El Not SL means Sick leave
Hi Nikhil, You can change the dropdown, conditional formatting and formula as per your requirements. Please download this excel file from the link given vedio's description box.
hello I need a 2 two Serial Column column A is Normal Serial for eg. 0000001 to 0100000 column B is 000001 this number change after 100 row to 000002 then after 100 row 000003.
what are formula to change number after 100 Automatially..
SIR you are so good but the only problem with u is you are so fast when you try to explain pleas everything is try to make your speed minimize pleas again do u think every body is computer engineer not so try your best
Show off or teaching others? If teaching others then be cooperative by showing the formulas، I Don't think this tracker as necessary at all، there are much more better than this on TH-cam، which will help us more in teaching ۔۔۔ Thx
Sir aap intana good work karata Ho to muzhe Ek excel sheet banakar chahiye please banakar do n sir Mai aapaki fess paid karneko tayar hu ......please sir
Excellent way of creating & maintaining a Attendance Tracker document. Big Thanks PK!
Thanks for your appreciation.
Just wanted to say your video is very helpful. I will follow you all video and try to implement same to my process. Waiting for more interesting video.
Dear Mr PK.... Thank you so much for your help... I have gone through all the class of yours. Very good opportunity to learn excel for us.
Thanks for watching and sharing your valuable feedback
Thanks mate, helped me in getting answers to few questions that I had prior to watching your video. Stay strong| Stay Blessed
Thank you so much for these tutorial and how simple you make it for anyone to understand it. I work in a foster children and I have a form in excell that I send to the region to fill out about the children and any services we provided. Most the time, the don't know if the form is sent to me or not. How to make it simple? so everytime they fill out the form, it will be collected the data of the form in a different worksheet as a table. they only have to check the table to see if they send it to me.
Usually in the form we have, date of service, name of service, child name, child case number. one child can have more than one services.
Thank you so much.
OMG it’s cool..... you are best thanks Sir
Thanks for your valuable feedback
MR PK...I can see you are an expert! but pls slow down... I really want to learn!!!!!
Thanks a lot pro!!! BTW, how to include a Half Day Leave into the tracker? I can do it with similar method with Leave Count but how to make the value as 0.5 for it to tally the actually leave count.
Very use full formula. Thank you
Thanks for your valuable feedback
Thanks for this
Acutely I was finding something which I haven't get but suddenly I saw your video and which formula I was finding that was in this video finally I take very relax breath thanks
Thanks for your valuable feedback
PK: An Excel Expert I have one suggestion for you for the beggner very tuff to understand bcz you did very fast all thing so please try to make little bit slow then beginner can understand better thanks
Beautifully explained 🎊💗💖
Thanks for your valuable feedback
it is good worksheet although my problem has not been sought out, please help me for find the result of how to identify the exact dates on which employee in being absent or leave pending
Thanks a lot Mr PK. But I noticed Data Bar does not reflect correctly. I had 5 meetings scheduled in different months. I need to track meeting attendants by Present Count, Absent Count, Excused Count, staff A's present count is 3 meaning he attended 3 of the 5 meetings, absent count is 1 meaning he absent 1 of the 5 meetings, Excused count is 1 meaning he has 1 excused absent of the 5 meetings. but the Data Bar shows full color on 1, which should only show very small portion not full color, it's misleading. How can I email you an image if I am not describing clearly here.
Hello sir. Your an expert.. Please upload the video which had 25 employees with productivity and accuracy and also for utilization finally to dashboard for daily reports, monthly and quarterly
Excellent job. Thanks
Dear friend, your video has very helpful. Your simple and easy to follow instructions make even more attractive. I'm glad that I've stumbled in into your video by mere luck. I think it's my lucky day. Thank you again.
Thanks for watching and sharing your valuable feedback. Audience like you always encourage me to do something innovative in Excel.
I'm glad to know such a humble person like you. Thanks my friend.
Mostafa
my teacher you help me a lot with this video how to make an attendance tracker may the Lord prosper you and you will be a help to the nation, in professional work many thanks to you .
Thank you so much for nice words. Audience like you always encourage me to do something innovative in Excel.
Thanks for watching and sharing your valuable feedback.
Fantastic Sir, Really nice way explained everything!!!
Thanks for your valuable feedback
Very very helpful! Thank you very much for this tutorial sir!
Thanks for your appreciation. Request you to please share this with your friends and colleagues.
@@PKAnExcelExpert
I agree it is very helpful ... but ... how come a leaver is present the next day? Once he/she leaves shouldn't the cells afterwards be empty?
@@PKAnExcelExpert
When you say "leave" do you mean "authorised leave of absence" or do you mean "quit/fired"?
If the person quits then there should be nothing marked after the day they quit?
thanks man, was looking for format cell to assign colors for each variable. very handy
Thanks for your valuable feedback
If we want to do for Sat and Sunday for holiday what is the formula?
Superb video.....Thanks a lot......
Thanks for your valuable feedback
hello Sir, good job. but i have one question. what should we do for ''WO'' to be filled automatic in Sunday columns . for example if i change the register from March to April then the WO must move automatically to the Sunday column.
Hi, Can we combine this with pivot table as your another video (Process Absenteeism Report)? and make the dashboard? thanks PK
Very useful skills. Gonna do one with your method! Love u so much
Thanks for your valuable feedback
Great job on this piece of software
Thanks for your valuable feedback.
Hello Pk
I have below query,
How shell i do color scale conditional formatting in entire table formatted raw by every alternative column.
Also any future raw or column to be added the it also should take similar formatting in auto mode.
Thanking you in advance.
Regards
Bharat
Hello, how do i create the summary report with date and reason for specific employee?
I will try to make such video very soon
Very good. How to download it not given link ?
How to take a list of dates of leave types of individual employee? Not total leave , but the leave dates. (eg.CL 5th MARCH EL 11,12,13,14 MARCH, LWP MARCH 20,21,22)
Which formula you used in highlight Sunday
Very nice videos
Thanks for your valuable feedback
dear Pk when you put the formula , why r you in so hurry ....we know you have master the excel but when you are explaining to new learners try to be slow in explaining the formula .... i hope you understand , try to know how to transform Knowledge transfer ...rest all was good
Hi Lalit,
I will take care in upcoming videos. Thanks for watching and sharing your valuable feedback.
Very smart but he should slow while explaining.
@@PKAnExcelExpert please assist me on I have created automatic attendance with the help of TH-cam! However if I change the month in dropdown the data of previous data remains there, how can I use properly!! How can check the previous data on single selection in the same sheet!! Is it possible please share this will helpful for many whose having same question
Hi I'm new in your page.
Your so good Teach the Excel.
Hi PK,
How about l the employees will take half day leaves
How to improve the accuracy and reduce the redundancy of the data ? By this i mean how to keep the data protected from other employees by avoiding entering wrong data?
thank you very much. I have learned a lot of things
Hi B Saruul,
Thanks for your valuable feedback.
B Saruul nice
Hello ,
How can i transfer data from Sheet 1 to Sheet 2 daily basis and when data changes in Sheet 1, data is transfer to Sheet 2 without deleting previous data in sheet2 in google spreadsheet
NICE VIDEOS.....HAS THERE ANY OPTIONS FOR RANDBETWEEN FUNCTION FOR THE TEXT LIKE P,A,L,WO?
Thanks for your valuable feedback. Yes it can be achieved by CHOOSE and RANDBETWEEN function. I will create a video on this very soon.
Love you sir
Thanks🙏
Great tutorial! learned a lot. Thank you.
Thanks for your valuable feedback
sergio alvarenga bir
Dear,
Your ignoring is very good but am new to learning this and i didn't understand this.
Because it's very fast teaching.so pls could you provide another video for us with possible learning speed. I believe you that as you will support about this and am going to subscribe your channel. Thanks BOSS
Sorry
You're video is very good. Pls be noted.
Set your youtube setting playback speed to (0.75) for better understanding... Hope answers to ur question....
hello dear PK
can u please do real estate tenant tracking sheet ,
- tenant paid rent
-tenant late paid
vacancy apartment
occupied apartment
how can i do it if i have more than one buildings ?
thank u very much
Dear PK,
thanks for this video and i want to ask you how to make this for shift basis thats mean the working days say it to be 4 and then 2 days off ?
Hi,
I have given the download link in video's discretion box. Please download this excel file from there. In that Excel file I have given two worksheets. One for Sunday off and second for Sat and Sun off.
For shift wise attendance I will create another video very soon.
Thank you so much for your support. We Really Appreciate Your Initiative.
What do I do for the next month?
thanks. but i want the month start from this month 26 to next month 25 please help
Dear PK, I don't want to edit manual entries, when a person opening his excel and put Automated PC Date with time, then the excel needs to record and shows the outcome/results in pdf format as a monthly basis. Can we do it? And pl explain slowly, so users can understand
hello thank you for sharing and i want to know how to create an employee database attractive and super easy to use?
Great help...Please be bit slow when using menus. Keep it up.
Thanks for your valuable feedback. I will definitely take care of this in upcoming videos.
What would be the day off formula for Friday and Saturday according to our country ? Please state me the formula here please
You can watch this tutorial I found in this day off highlighting formula as you need
th-cam.com/video/62Z2RbbR5Os/w-d-xo.html
Pk excellent knowledge on excel. can u pse make one for me too. i want a different chart. showing 8 subjects of a student total and actual marks.
Thanks for sharing these videos, may i ask how to make color for Sat and Sun instead of Sun only?
Hi,
I have given excel download link in video's discretion box. Please download this excel file from there. I have given 2 sheets one sun off and 2nd for sat and sun off.
I hope it will help you.
You can apply another formula for sat or sun formula is
=Or(text(A1,"DDD"),"sat",text(a1,"DDD"),"Sun")
Very good
Awesome
Thanks for your valuable feedback
Do u conduct courses related to these..
Hello sir, i have 7 employees, 24x7, I want to make a roaster with 3 shift, employees rotattand weekly off is mandatory....pls guide me....
How if the Annual Leave and Unpaid Leave happen on the same day? How to track it...
sir aapne jo formula use kiya h sunday ko show krne k liye kya aap mujhe woh formula type krke send kr skte ho please sir.
Its a good one only that.......only coming like a flash.slow down sir..thanks
So, on the Sundays when it is automatically highlighted, how can you also format the cells to show “WO” without having to type that in?
Same formet use Google Sheet ??
Great Video Mate !!! I need something to record get pass records
You are not clearly showing all, neither we can see any formula typed by you.
First , highlighted thing didn't came correct . Nothing happened
Could you please tell us How do you create "DDD"? Thanks a lot!
Sir your video is very good
Thanks for your valuable feedback
Hi! I have found your video very useful. Thank you! Do you happen to have any type of video showing how to create a spreadsheet for tracking employee time off (vacation, sick, unpaid, holiday, etc.) that has formulas using a employee anniversary date? Our company offers vacation at anniversary date and not at beginning of the new year. I appreciate any help you may be able to offer.
PLS TELL ME IN SUNDAY FORMULA NOT CORRECT WORK ON SUNDAY DAYS.
Mr PK, how can I verifying time Attendance vs finger print?
i would like Request To Make A Video With Index & Match Formula .
Thanks these video very help full Kindly make a video how to make roster in bpo
very good, can anyone explain how I can add OT in everyday.
Do you know how to conditionally format a cell based on the formula in the cell? For example, let's say that I use a formula to compute the value of a given cell. Well, I am trying to do a conditional format based on a string of text that is included in the formula that was used to create the value. (e.g., =if(c3="red apple, "eat apple). I want to conditionally format a cell if the string "red apple" is within the formula. Note, I am not trying to conditionally format the result of the cell; I'm trying to conditionally format based on what's within the formula of the cell.
Read more
REPLY
Awsm👍
Hi, how to calculate the 1/2 day leave in the same sheet...
Mr pk, please let me know that I want to know the date and time of the data entered in a database (excel workbook) .I need date and time of each data in a database.
sir you should be make it slowly, so that we can understand very well and follow you for learn this
Hi Vicky,
I have uploaded an excel file on google drive and link has been given in videos discretion box. Please download this excel file from there for better understanding.
Thanks for your valuable feedback. I will take care of this thing in my upcoming videos.
Please tell me that how to do the SL as Cl Because in my attendance sheet two column in that manul i can write and one more column in that formulae is there only it will reflect that CL and El Not SL means Sick leave
Hi Nikhil,
You can change the dropdown, conditional formatting and formula as per your requirements.
Please download this excel file from the link given vedio's description box.
Thank u
Most welcome🙏
Good Sir, Update us for other salary Format
I'm waiting for your next video
How can creat data this??????
Student card with result link,attandance link and fee list with pictures links
Try to Next video.???
Awesome !!
Thanks for your valuable feedback
hello
I need a 2 two Serial Column
column A is Normal Serial for eg. 0000001 to 0100000
column B is 000001 this number change after 100 row to 000002 then after 100 row 000003.
what are formula to change number after 100 Automatially..
HOW TO SOLVE ######### THIS PROBLEM ?
Professional trainer
Thanks for your valuable feedback
PK: An Excel Expert
Please explain MIS in excel
SIR you are so good but the only problem with u is you are so fast when you try to explain pleas everything is try to make your speed minimize pleas again do u think every body is computer engineer not so try your best
MR PK SORRY YOU ARE A BIT FASTER TO BE LEARNED FROM. HOWEVER, VERY GOOD DEMO
i want to create simple system concern about inventory system how can help me?
How did you auto filled dates. Please tell the shortcut
The shortcut is Alt+E+I+S
hi! how to create in excel example! i have 5 printer in referent model,,, when i type the serial its automatic in row appear the model of printer
Cool idea , i will use it :)
Nice
Thanks for your valuable feedback
How to use of this data at a big organisation?
Can I get the link to the practical file, please?
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
What if I have to make it for entire year
How can I take conditional formatting and data validation to next sheet
Please revert soon
You can copy it to next sheet or its better make the duplicate sheet and changes the dates.
@@PKAnExcelExpert
Is there any shortcut to create duplicate sheet or I have to prepare as I did the first one
Show off or teaching others?
If teaching others then be cooperative by showing the formulas،
I Don't think this tracker as necessary at all، there are much more better than this on TH-cam، which will help us more in teaching ۔۔۔
Thx
i unable to download the attendance excel sheet there is no link...
Thank u sir
Thanks for watching
Sir aap intana good work karata Ho to muzhe Ek excel sheet banakar chahiye please banakar do n sir Mai aapaki fess paid karneko tayar hu ......please sir
contact abhijeetrathod5858@gmail.com
Userform me tick option dekar koi attendance sheet banao
the EMP is the kind of Russian light tank, right? =)))))