Once more with an interactive video, Thanks, and appreciated your efforts!

That was some heavy formatting. Thank you PK. I'm glad I went through that lesson. I feel like I learned conditional formatting a lot better. Thank you.

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Awesome!! It's really helpful for me as well. Thank you so much for this video. Good Job!! Much appreciated!!

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you PK, have learned a lot by watching your videos

@PKAnExcelExpert

Жыл бұрын

Most welcome🙏

You are genius sir thank you for teaching us . Make us god of excel.❤️❤️

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

excellent explanation. Any lay man can understand. Once again very very great.

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Amazing man! Will to do by myself and use it later =)

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you! Just got my new monitoring sheet.

@PKAnExcelExpert

2 жыл бұрын

Glad I could help!

thanks very much! It is useful

@PKAnExcelExpert

3 жыл бұрын

Glad it was helpful!

You are excel magician

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

You are genius sir🙏

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you for making out time to put together this clip. I have tried to do the conditional formating for the webbing text but it keeps showing the wrong symbol. What can i do??

Awesome work, i have one question for you. How can I have the marked days with symbols moves along when we change the month period. in other word, if I changed the month period the attendance sheet in the schedule also follow it the change period. for example, if X person attended on 1st. Jan but did not attend on 1st Feb then when i change the month above I want to have the attendance also be changed with the change of month so I can meet my exact match of the attendance. ♥

very useful file I do like it so much PK

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thanks.

@PKAnExcelExpert

3 жыл бұрын

Welcome

Can you check if the practice file format is correct ? It's downloading as txt file.

thanks alot :P

@PKAnExcelExpert

3 жыл бұрын

Welcome

Can you make a video on 3 × 8 hour weekly Shift planner for 30 days with alternating week shifts with changing week off after every week to preceding day??

Plz make one video for software office administrator work in Excel. All in one vid 🙏🙏plz

Sir Assume, we have columns emp code, name, date and attendance from 1 to 31. How to clear cells as per the date updated in column number 3. If i put date as 4th march 2021, I need the cells as blank from columns 5th March to 31st March. If it is possible, pls help..

What about the public holidays in the setting sheet?

Hi Bro .Thank you for incridible video . I am from Uzbekistan . I am having problem with formula it cant type (=text ) this formula doesnt work what can I do ?

Hi sir please explain how to rotate each shift as 10 to 17 staff roster approximate 3 shift

Nice..

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

If u change any month the previous month data is not saved.. it ll display for every month same..say if i mark March 1st as present..nd change April month ...data for March 1st is still appears.. were it supposed to be new sheet for april

conditional formating custom rule not working, it shows only 'a' instead of symbol. please tell me anything else to do

@sureshkumarpantla

3 жыл бұрын

ok now its working thank you

How to do background color .. that blue color

Dear PK ,IF ATTENDANCE MENTIONED 21st TO 20th of month then...if make a vedio if possible 😊

Dear Sir, Please upload such more video

@PKAnExcelExpert

Жыл бұрын

I will try my best

how do i add half days in this sheet please explain

Sir 24 hour attendance for Petrol Pump shift

Hindi me banoa sir apke subscriber aur jyada badh jayenge