How to make an attractive attendance tracker

Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@diveshagarwal4560]

Excellent way of creating & maintaining a Attendance Tracker document. Big Thanks PK!

[@PKAnExcelExpert]

Thanks for your appreciation.

[@soniatriana407]

MR PK...I can see you are an expert! but pls slow down... I really want to learn!!!!!

[@siyaramkijay]

Thanks mate, helped me in getting answers to few questions that I had prior to watching your video. Stay strong| Stay Blessed

[@raghubirbarjatia3558]

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.

[@1shortv]

Hi I'm new in your page.
Your so good Teach the Excel.

[@sulochanaa.r8610]

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.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@narren9]

thanks man, was looking for format cell to assign colors for each variable. very handy

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@comnetcns1]

Fantastic Sir, Really nice way explained everything!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shaikthouseef8507]

Thanks these video very help full Kindly make a video how to make roster in bpo

[@bsaruul8293]

thank you very much. I have learned a lot of things

[@PKAnExcelExpert]

Hi B Saruul,
Thanks for your valuable feedback.

[@gudduram9790]

B Saruul nice

[@gatkuothpeter]

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 .

[@PKAnExcelExpert]

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.

[@kaaa3485]

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.

[@kellyoku]

Excellent job. Thanks

[@flxcedillo100]

Very very helpful! Thank you very much for this tutorial sir!

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends and colleagues.

[@reasonerenlightened2456]

@@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?

[@reasonerenlightened2456]

@@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?

[@abdallakalil290]

OMG it’s cool..... you are best thanks Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@smcasny]

Great tutorial! learned a lot. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@skdkajdbkskskdms1504]

sergio alvarenga bir

[@anushka-nashpathirana8741]

Great Video Mate !!! I need something to record get pass records

[@vedprakash9914]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vedprakash9914]

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

[@shaik4122]

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.

[@tokevin3026]

Very useful skills. Gonna do one with your method! Love u so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@karthiktn4112]

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

[@rIsIng138]

Awsm👍

[@terrellhassan5809]

Great job on this piece of software

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@ramdashwant2024]

Beautifully explained 🎊💗💖

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@1shortv]

I'm waiting for your next video

[@mostafamashhoor]

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.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback. Audience like you always encourage me to do something innovative in Excel.

[@mostafamashhoor]

I'm glad to know such a humble person like you. Thanks my friend.
Mostafa

[@shiladityaray3137]

Superb video.....Thanks a lot......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anilkumarr1181]

Good Sir, Update us for other salary Format

[@gopim6438]

Ur master ... 👍

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@hovhanneskhachatryan4785]

Could you please tell us How do you create "DDD"? Thanks a lot!

[@phirunheng6344]

Very use full formula. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sanjaysodani6286]

Sir your video is very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@svrkrishna43]

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.

[@parvezbhuiyan6825]

Thank you so much for your support. We Really Appreciate Your Initiative.

[@mhmmustha]

very good, can anyone explain how I can add OT in everyday.

[@jameshoward8763]

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?

[@anabathulanaresh]

tqs so much brooo

[@PKAnExcelExpert]

Thanks for watching

[@mazedkhan3319]

Thank you very much ...

[@PKAnExcelExpert]

Thanks for watching

[@rakeshdaskar5741]

If we want to do for Sat and Sunday for holiday what is the formula?

[@rahabwambui9657]

Its a good one only that.......only coming like a flash.slow down sir..thanks

[@mohdsartaj7942]

Awesome !!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jaggs05]

Great help...Please be bit slow when using menus. Keep it up.

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely take care of this in upcoming videos.

[@wastam1581]

Hi, Can we combine this with pivot table as your another video (Process Absenteeism Report)? and make the dashboard? thanks PK

[@mohamaduakbarali7804]

Hi, how to calculate the 1/2 day leave in the same sheet...

[@Anna_Icy_07]

hello thank you for sharing and i want to know how to create an employee database attractive and super easy to use?

[@ghaniakbar132]

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.

[@shaileshparmar9342]

Thank you so much

[@PKAnExcelExpert]

+shailesh parmar Thanks for watching

[@pankajgaur8896]

What do I do for the next month?

[@tranhlam5211]

Thanks for sharing these videos, may i ask how to make color for Sat and Sun instead of Sun only?

[@PKAnExcelExpert]

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.

[@waseemahmad6764]

You can apply another formula for sat or sun formula is
=Or(text(A1,"DDD"),"sat",text(a1,"DDD"),"Sun")

[@sachinpandit8489]

Very good

[@sayedanis2584]

Professional trainer

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sayedanis2584]

PK: An Excel Expert
Please explain MIS in excel

[@parvezbhuiyan6825]

i would like Request To Make A Video With Index & Match Formula .

[@top10tips61]

vry helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@angel_lie217]

Hello, how do i create the summary report with date and reason for specific employee?

[@PKAnExcelExpert]

I will try to make such video very soon

[@karamfangujrat2981]

PLS TELL ME IN SUNDAY FORMULA NOT CORRECT WORK ON SUNDAY DAYS.

[@praveenrao8973]

Hi PK,
How about l the employees will take half day leaves

[@pavitrananda8729]

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?

[@rajangodar]

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

[@umarshad3862]

Love you sir

[@PKAnExcelExpert]

Thanks🙏

[@mahmoudkasem6048]

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 ?

[@PKAnExcelExpert]

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.

[@MohdroslanAwangsenik]

Mr PK, how can I verifying time Attendance vs finger print?

[@g.k.kori1589]

Very nice videos

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Deepak4U1li]

Very good. How to download it not given link ?

[@sredharbalaraman1387]

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.

[@thenlilan8701]

How if the Annual Leave and Unpaid Leave happen on the same day? How to track it...

[@bbrbestbestreport3816]

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

[@bbrbestbestreport3816]

Sorry
You're video is very good. Pls be noted.

[@mmincredible1451]

Set your youtube setting playback speed to (0.75) for better understanding... Hope answers to ur question....

[@MrDoraville]

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

[@anabathulanaresh]

Sir, How to insert 2nd Saturday and 4th Saturday in condition ,solll

[@saud5133]

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

[@user-hf6yw3gb7j]

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)

[@smartwork4768]

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

[@kamalakanta4488]

Thank u sir

[@PKAnExcelExpert]

Thanks for watching

[@MSHL007]

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.

[@1shortv]

How can creat data this??????
Student card with result link,attandance link and fee list with pictures links
Try to Next video.???

[@naveenkondle9898]

Same formet use Google Sheet ??

[@alone_heartless5681]

How to use of this data at a big organisation?

[@cutedogstube6184]

thanks. but i want the month start from this month 26 to next month 25 please help

[@sonaarmygirlbts9030]

Which formula you used in highlight Sunday

[@Vickykumar-cp1mx]

sir you should be make it slowly, so that we can understand very well and follow you for learn this

[@PKAnExcelExpert]

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.

[@inoxus1988]

very very useful

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@inoxus1988]

I'm subscribed and I'm going to continue watching the videos

[@PKAnExcelExpert]

Thanks Onix,
Audience like you always encourage me to do something innovative in Excel.

[@navanitha11]

Awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@navanitha11]

Do u conduct courses related to these..

[@NewsTripuraToday]

Sir, How to insert 2nd Saturday and 4th Saturday in condition

[@PONCEJE]

If you need help send me your workshet. I gonna help you out.

[@kbud4013]

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.

[@kiboridaniel9837]

i want to create simple system concern about inventory system how can help me?

[@seatown2012]

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

[@MuraliKrishna-tp9fp]

Thank u

[@PKAnExcelExpert]

Most welcome🙏

[@avyanshsystemhightech3610]

sir I want to multiple material fill setup in one file ?

[@lalitsahni2130]

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]

Hi Lalit,
I will take care in upcoming videos. Thanks for watching and sharing your valuable feedback.

[@sonic-su5ob]

Very smart but he should slow while explaining.

[@parshuthonti]

@@PKAnExcelExpert please assist me on I have created automatic attendance with the help of RUclips! 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

[@zeratech3997]

NICE VIDEOS.....HAS THERE ANY OPTIONS FOR RANDBETWEEN FUNCTION FOR THE TEXT LIKE P,A,L,WO?

[@PKAnExcelExpert]

Thanks for your valuable feedback. Yes it can be achieved by CHOOSE and RANDBETWEEN function. I will create a video on this very soon.

[@aloysiuslan3813]

i guess the condition formatting part kills most people lol

[@paresh282]

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

[@ravimishra550]

Yes I can see Attendance sheet

[@shyinkadir6702]

What would be the day off formula for Friday and Saturday according to our country ? Please state me the formula here please

[@kamransohail3024]

You can watch this tutorial I found in this day off highlighting formula as you need
ruclips.net/video/62Z2RbbR5Os/видео.html

[@fittness4me]

Nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mrboss3602]

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.

[@rameshch3431]

How it is if we have w/off saturday as well

[@PKAnExcelExpert]

Hi ramesh,
Please download this excel file the link given in vedio's description box. I have given 2 sheets one sun off and 2nd for sat and sun off.

[@rameshch3431]

Excellent ! Thanks. Any videos related to VBA

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback.
I have created several videos regarding VBA:
EXCEL VBA: ruclips.net/p/PLbDvAYjpWJ7DrR6AjGaIbzTe_Ur3vyvBx
VBA Tutorial: ruclips.net/p/PLbDvAYjpWJ7BcoaFQD-syOrZzNSLZycwH
Excel Games: ruclips.net/p/PLbDvAYjpWJ7A7p_mhdbnx-WHO7noPPDsG

[@mdhasanujjal]

HOW TO SOLVE ######### THIS PROBLEM ?

[@shafeems.c1963]

You are not clearly showing all, neither we can see any formula typed by you.
First , highlighted thing didn't came correct . Nothing happened

[@risenfly6485]

i unable to download the attendance excel sheet there is no link...

[@reynantesaludo2955]

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

[@dianaodintsov4371]

Cool idea , i will use it :)