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.
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.
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.
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.
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
@@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 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
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.
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 UA-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
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
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.
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
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.
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 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.
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)
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
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! 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.
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 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, 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
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
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.
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
Excellent way of creating & maintaining a Attendance Tracker document. Big Thanks PK!
Thanks for your appreciation.
OMG it’s cool..... you are best thanks Sir
Thanks for your valuable feedback
Beautifully explained 🎊💗💖
Thanks for your valuable feedback
Very use full formula. Thank you
Thanks for your valuable feedback
MR PK...I can see you are an expert! but pls slow down... I really want to learn!!!!!
Excellent job. Thanks
Superb video.....Thanks a lot......
Thanks for your valuable feedback
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.
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.
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
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.
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.
Great job on this piece of software
Thanks for your valuable feedback.
Hello, how do i create the summary report with date and reason for specific employee?
I will try to make such video very soon
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
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 mate, helped me in getting answers to few questions that I had prior to watching your video. Stay strong| Stay Blessed
Fantastic Sir, Really nice way explained everything!!!
Thanks for your valuable feedback
Very nice videos
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
thanks man, was looking for format cell to assign colors for each variable. very handy
Thanks for your valuable feedback
Sir your video is very good
Thanks for your valuable feedback
Awesome
Thanks for your valuable feedback
Do u conduct courses related to these..
Which formula you used in highlight Sunday
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.
Awsm👍
Very good. How to download it not given link ?
Very good
Love you sir
Thanks🙏
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 UA-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
Great tutorial! learned a lot. Thank you.
Thanks for your valuable feedback
sergio alvarenga bir
Very useful skills. Gonna do one with your method! Love u so much
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
Hi, Can we combine this with pivot table as your another video (Process Absenteeism Report)? and make the dashboard? thanks PK
thank you very much. I have learned a lot of things
Hi B Saruul,
Thanks for your valuable feedback.
B Saruul nice
If we want to do for Sat and Sunday for holiday what is the formula?
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
Could you please tell us How do you create "DDD"? Thanks a lot!
Thank you so much for your support. We Really Appreciate Your Initiative.
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?
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
Hi I'm new in your page.
Your so good Teach the Excel.
Great Video Mate !!! I need something to record get pass records
Thanks these video very help full Kindly make a video how to make roster in bpo
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.
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.
Professional trainer
Thanks for your valuable feedback
PK: An Excel Expert
Please explain MIS in excel
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")
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 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.
Its a good one only that.......only coming like a flash.slow down sir..thanks
Nice
Thanks for your valuable feedback
hello thank you for sharing and i want to know how to create an employee database attractive and super easy to use?
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)
thanks. but i want the month start from this month 26 to next month 25 please help
What do I do for the next month?
Same formet use Google Sheet ??
very good, can anyone explain how I can add OT in everyday.
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
ua-cam.com/video/62Z2RbbR5Os/v-deo.html
i would like Request To Make A Video With Index & Match Formula .
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?
I'm waiting for your next video
Good Sir, Update us for other salary Format
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.
How if the Annual Leave and Unpaid Leave happen on the same day? How to track it...
Thank u
Most welcome🙏
Awesome !!
Thanks for your valuable feedback
Hi, how to calculate the 1/2 day leave in the same sheet...
Mr PK, how can I verifying time Attendance vs finger print?
Userform me tick option dekar koi attendance sheet banao
HOW TO SOLVE ######### THIS PROBLEM ?
You are not clearly showing all, neither we can see any formula typed by you.
First , highlighted thing didn't came correct . Nothing happened
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
PLS TELL ME IN SUNDAY FORMULA NOT CORRECT WORK ON SUNDAY DAYS.
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....
i want to create simple system concern about inventory system how can help me?
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! 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.
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
Sir, How to insert 2nd Saturday and 4th Saturday in condition
If you need help send me your workshet. I gonna help you out.
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.
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 very much ...
Thanks for watching
How can creat data this??????
Student card with result link,attandance link and fee list with pictures links
Try to Next video.???
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....
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
How to use of this data at a big organisation?
Sir, How to insert 2nd Saturday and 4th Saturday in condition ,solll
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
How did you auto filled dates. Please tell the shortcut
The shortcut is Alt+E+I+S
vry helpful
Thanks for your valuable feedback
Yes I can see Attendance sheet
tqs so much brooo
Thanks for watching
Ur master ... 👍
Thanks for watching and sharing your valuable feedback
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.
Thank u sir
Thanks for watching
MR PK SORRY YOU ARE A BIT FASTER TO BE LEARNED FROM. HOWEVER, VERY GOOD DEMO
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 :)
the EMP is the kind of Russian light tank, right? =)))))