*New Video of Fully Advanced Attendance Sheet for 12 months* 👉 th-cam.com/video/0Bdc1XftAwc/w-d-xo.html Must Watch it 👌 दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰 *My New Channel :* bit.ly/3qFrbl5 *Complete Microsoft Word Tutorial :* th-cam.com/video/Xkq0-xXAj48/w-d-xo.html *Complete Powerpoint Tutorial :* th-cam.com/video/OekrBhNybP0/w-d-xo.html *Xlookup Complete Tutorial :* th-cam.com/video/0LjfRVD7srU/w-d-xo.html *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb *Excel All Formulas :* th-cam.com/video/C9y53fedo04/w-d-xo.html *Office Work in Excel :* th-cam.com/video/PT8D1qQwe1k/w-d-xo.html
Mr Deepak I am facing serious problem in setting the day and date and I am unable to go ahead in this video plz look to this and give me quick solution.
Hi Deepak, Seems there is a flaw with the automatic sheet. Pls assist with the query below, 1) If data is updated in the sheet (say P or L) of any month initially, the same would reflect in other months as well when we list down the months/change months. 2) How can we show empty columns for the coming month's when changed, so that attendance can be tracked accordingly. Hope to see your response soon. Thank You!
Hi Deepak, I am also facing the same issue, I have prepared the attendance sheet and I understand the procedure. But when I have filled the attendance for January, some of the data from January will get reflect to the other month. When I will change the month from January to other. Please help us
Im just loving yur videos, what if I need to highlight only Sunday ,then how can I do that., because you highlight sat,Sunday for weekly holidays but I need only sunday.can u help me please how to drive this formula..
NICE BRO I have one Query ki agar hum month change krte hai kya pichla data jo ki hmne pichle month attendance bhari this vo save rhega isme. ki har baar hme new sheet banaani padedi. matlab ye hai ki hmne is sheet ko bna liya hia attendance har mahina ki lagaani hoti hai agar baad me hame maan lo may ki attendance dekhni hai aur hum isi sheet se may month ko select krte hai kya hum may ki attendance jo fill ki this dekh payenge isme ki nahi
Sir this is nice but when i change month then presence and absence data will not change if you can give trick so it will work otherwise this sheet is totally waste and i also waste my time 🙄
Sir...when you change the month, the days and day is changing, but the details of absent and present is not changing .....what ever we enter in one month the same is being displayed for all the months?? Ravi kumar
सर, हमने आपका अटेंडन्स शीट वाला व्हिडीओ देखा व्हिडिओ काफी अच्छा था । लेकिन हमे कुछ समस्या थी । अगर कर्मचारीयो की विकली ऑफ अलग अलग है तो उसको कैसे हायले किया जा सकता है ।
play.google.com/store/apps/details?id=comm.example.takemyroll_teacher.takemyroll_ssw Sir, please try this app It will help you do all this with just few clicks.
Please mention WK off with a new colour as they assigned a separate colour for leave & absent , then search as WK off in table you will find your results
Rajesh, Deepak sir ji aapne video me attendance sheet banaanaa sikhaaye vo bahut badhiya bataaye, aur aage me ye kahna chaha raha hu ki mujhe ase hi data entry excel ki job bataiye kahi bhi, aaj me excel me full expected hu lekin kahi job mil hi nahi pa rahi hai, to aap jaroor-2 data entry ki job bataiye, aur video achha hai
Sir namaste, आप बहुत अच्छे से बताते है, आसानी से समझ मे आ जाता है. एक प्रॉब्लम हो रही है, मैने Aug ki attendance शीट बनाई, जब इसमे month चेंज करते है तो aug का फिल किया हुआ डाटा sep मे भी आ जाता है. इसको कैसे ओके करें.pls बताये...🙏
great bro, great bro,.... bro ap aik attandence sheet bna kr dikhao k jb staff apni attandence khud lagay to us ka arrival time khud ba khud lag jay k ya staff mamber is time pr offuce pohancha ha. thanks bro
New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍 Here is one More NEW Interesting video on ATTENDANCE SHEET th-cam.com/video/l6ORdfIENDY/w-d-xo.html
Nice job man. Learn alot from your videos. es format me jab aik month ki entries kar lyty hain phir jb next month ko select karty hain tu wohi entries dobara ajati hain. agar entries ko delete kar dain tu previous month sy be khatam ho jati hain. es ka koi hal bataye plz.
Not helpful man its seems smart but actualy there is nothing valueable this is just waste of time you just try tum khud ko gali dene lagoge ek bar try karke dheko
Excellent Deepak sahib you have very well knowledge about Excel I have seen yours more video about excel my child says that uncle Deepak has fully command in formulas of Excel. ( Kamal ha bie)
Thank you very much, sir, for the most important tutorial you teach us. "Respect from Nepal"
Very nice video.... very useful thank you
😃
*New Video of Fully Advanced Attendance Sheet for 12 months* 👉 th-cam.com/video/0Bdc1XftAwc/w-d-xo.html Must Watch it 👌
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* th-cam.com/video/Xkq0-xXAj48/w-d-xo.html
*Complete Powerpoint Tutorial :* th-cam.com/video/OekrBhNybP0/w-d-xo.html
*Xlookup Complete Tutorial :* th-cam.com/video/0LjfRVD7srU/w-d-xo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* th-cam.com/video/C9y53fedo04/w-d-xo.html
*Office Work in Excel :* th-cam.com/video/PT8D1qQwe1k/w-d-xo.html
Hi
Sir g vba coading se related vdo bno koi jisme alg alg month ka data save ho
Sir 2007 me work nahi horha
Mr Deepak I am facing serious problem in setting the day and date and I am unable to go ahead in this video plz look to this and give me quick solution.
Hello sir meri salary list me month by month present and absent change nhi ho rha h to kya krna pdega
bhai thank u itna deep mein samjhane k liye
Friend, Excellent way to transfer knowledge. learnt a lot, thanks
Thank you brother wish you all the best
Hi Deepak, Seems there is a flaw with the automatic sheet. Pls assist with the query below,
1) If data is updated in the sheet (say P or L) of any month initially, the same would reflect in other months as well when we list down the months/change months.
2) How can we show empty columns for the coming month's when changed, so that attendance can be tracked accordingly.
Hope to see your response soon. Thank You!
@Gauri Dhame No Sir
Same here. Did you find the solution
I am also want know how to solve it please Deepak sir give us solution
Learn payroll from us
Yes sir .even I have the same issue
U r so intelligent.... thank you for sharing the video
Sir ak asi excel sheet banao jisme time In time out fir outomatic over time calculate hojaye.
Mila kya
Very nice sir, very very useful to us, thank u very much
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Sir ap ni jo attendance sheet bena he ose m ek month ki results he next month ki results kese deki vo bate sir
Hi Deepak, I am also facing the same issue, I have prepared the attendance sheet and I understand the procedure. But when I have filled the attendance for January, some of the data from January will get reflect to the other month. When I will change the month from January to other.
Please help us
And sir is there any way....which can inform us if we wrongly type any other word in the sheet except "P" and "A" ???
Im just loving yur videos, what if I need to highlight only Sunday ,then how can I do that., because you highlight sat,Sunday for weekly holidays but I need only sunday.can u help me please how to drive this formula..
sir, my keyboard f4 buttom if i clic dont lock my cell .how can i lock my cell plz im watting for your replay.
NICE BRO I have one Query ki agar hum month change krte hai kya pichla data jo ki hmne pichle month attendance bhari this vo save rhega isme. ki har baar hme new sheet banaani padedi. matlab ye hai ki hmne is sheet ko bna liya hia attendance har mahina ki lagaani hoti hai agar baad me hame maan lo may ki attendance dekhni hai aur hum isi sheet se may month ko select krte hai kya hum may ki attendance jo fill ki this dekh payenge isme ki nahi
KARAN SINGH .. it is most important question which needs to be answered. Hope Deepak ji will answer it
Nice question.. Please wait. I will publish another video shortly on this topic.. Regarding your very nic query...
sir make a video early about this problem . We are waiting.........
KARAN SINGH deepak sir same problem . The data which i prepared for may that is also coming on the month June. Pls tell us how to solve this.
Deepak EduWorld when u publish new video on this
Thank you sir apke smjhane ka tarika bahut achha hai so agin than thank you
😊😊
Sir this is nice but when i change month then presence and absence data will not change if you can give trick so it will work otherwise this sheet is totally waste and i also waste my time 🙄
Even I am also facing the same issue..do you know how to fix it?
Hi Sir, I am also facing the same issue... Could you please provide the solution..
I want to use this file itself
Yes i am also facing same issue pls guide us asap .it will help me alot
मेरी बहुत बडी समस्या का हल बताया है ।आपने सर जी इसके लिये दिल से आभार करते है ।
❤️
Bhai ap jab month change kar rahay hy tou sunday walay column may bhi Absent likha a raha hy is ka solution batai
th-cam.com/video/0Bdc1XftAwc/w-d-xo.html
Thanks alot for education share for the worlds, GOD BLESS YOU
Sir...when you change the month, the days and day is changing, but the details of absent and present is not changing .....what ever we enter in one month the same is being displayed for all the months?? Ravi kumar
th-cam.com/video/0Bdc1XftAwc/w-d-xo.html
dipak ji aapke knowledge ka kmal hai
सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में दिखाई देती है
Please wait.. I will publish video as soon as possible on this topic
Sir plz give solution as soon as b. coz its very need full
Sir plz solve the query as soon as
Deepakji Namaste, I am facing the same problem. will be greatful if you can solve this major issue. I am also waiting for this query.
@@DeepakEduWorld ak hi month ka data fill krte hai to sabhi me vahi fill hota sir solution to batao hame
LOWER SHEET FOR INDICATING "P" "A" NOT CHANGING MONTHWISE, ONLY SAT & SUN COLUMN IS HIGHLIGHED WITH COLOUR
I ll publish next part of this sheet as soon as possible
@@DeepakEduWorld YOU ARE PUBLISH THIS PROBLEM?
th-cam.com/video/0Bdc1XftAwc/w-d-xo.html
Hi Sir I am also facing same issue... I wanted to fix the problem in same file... Can that be done
@@DeepakEduWorld सर इस प्रॉब्लम का सोल्यूशन बताओ plz
Nice bahut hi achhi jankari mili
😊
सर, हमने आपका अटेंडन्स शीट वाला व्हिडीओ देखा व्हिडिओ काफी अच्छा था । लेकिन हमे कुछ समस्या थी । अगर कर्मचारीयो की विकली ऑफ अलग अलग है तो उसको कैसे हायले किया जा सकता है ।
play.google.com/store/apps/details?id=comm.example.takemyroll_teacher.takemyroll_ssw
Sir, please try this app
It will help you do all this with just few clicks.
Please mention WK off with a new colour as they assigned a separate colour for leave & absent , then search as WK off in table you will find your results
I have made from wacth your video. Working.
Thanks sir but isme hamne January k month m presents fill ki to bahi presents next month m bhi fill rahati h. Aisa kyo kuchh upay sir...
Next part of this sheet is coming shortly
@@DeepakEduWorld i am facing same problem..
Yes same problem
I have resolve this issue
@@vikaskatiyar007 will provide us on the same
Rajesh, Deepak sir ji aapne video me attendance sheet banaanaa sikhaaye vo bahut badhiya bataaye, aur aage me ye kahna chaha raha hu ki mujhe ase hi data entry excel ki job bataiye kahi bhi, aaj me excel me full expected hu lekin kahi job mil hi nahi pa rahi hai, to aap jaroor-2 data entry ki job bataiye, aur video achha hai
Thank you so much Sir , how much effort you do to teach us
how to create April 2019 to march 2020
th-cam.com/video/0Bdc1XftAwc/w-d-xo.html
VERY GOOD AND USEFUL VIDEO
😊
how to extract only leave dates from this excel sheet using with formula.
Super thanks u r for update this video
Video toh pura banao yaar absent and present toh vaise hi reh jate hain fuddu wali harkatein mat karo yaar part 2 abhi tqk banaya ni
th-cam.com/video/0Bdc1XftAwc/w-d-xo.html
Sir namaste,
आप बहुत अच्छे से बताते है, आसानी से समझ मे आ जाता है.
एक प्रॉब्लम हो रही है, मैने Aug ki attendance शीट बनाई, जब इसमे month चेंज करते है तो aug का फिल किया हुआ डाटा sep मे भी आ जाता है. इसको कैसे ओके करें.pls बताये...🙏
New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍👍👍
Isko bananeka koi value hi nahi he kyuki date change karnese jo likha vo change hi nahi hota he to itna mehenat karne ka kya faida
true
Yes k koi solution nhi h kya. Baki sab achha h
Sahi me bhai
@@sonalithanekar7227 vba use kar sakte hai
TRUE
Bahat acha deepak sir❤❤
mindblowing attendence sheet sir thank u so mauch
Sir humane aapaka attdence walk
Vedio dekha baht achchha laga lekin kisi company ki salary sheet kaise banaye samjhane ka tarika achchha hai.
Thankyou sir very helpful video 👌👌👌👌♥️
great bro, great bro,.... bro ap aik attandence sheet bna kr dikhao k jb staff apni attandence khud lagay to us ka arrival time khud ba khud lag jay k ya staff mamber is time pr offuce pohancha ha. thanks bro
वाह दीपक जी वाह
Thanks Deepak Bhai, Very knowledgeable video provided.. I learnt lot of things from this very video.
Thank u Deepak for sharing the excellent knowledge.it was very useful for my career.
Great job Deepak.....👍🏻
😊
Very good and easy method of using excel formulas. Thank you Mr. Deepak.
👍😊😊
your work looking awesome sir
This video for me most useful thanks sir
Thank you so much. It helped me a lot
very nice style of teaching thank you great information
Thank u Broo Nice Teaching Style with Knowledge. Excellent Keep it up.
😊😊😊
Very nice videos sir
Sir video bahut acha hai.
Likin sir next year ka kise karege. Next year ka kise banayege
Next video on attendance sheet is coming shortly
Very useful video
ماشااللہ سر آپ بہت اچھی ویڈیوز بنا رہے ہیں
سر پلیز آپ اس طرح کریں کہ VBA میں بھی اس طرح کی ویڈیوز بنائیں تو ہمیں VBA بھی سمجھ آ جائے گا Thanks a lot
Thaknyou deepak sir i just downloaded your vedio and completed too I learnt much about excel with this one vedio thanks alot
Assalam u Alaikum sir. I created cash book, Day book and now I am working on attendance sheet. thank u sir from Pakistan
New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍 Here is one More NEW Interesting video on ATTENDANCE SHEET th-cam.com/video/l6ORdfIENDY/w-d-xo.html
@@DeepakEduWorld inshaa Allah I will watch it.
I looked for many videos, This one is the best
New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍👍👍
Thank you, Very good teaching.
👍😊
Very nice 👌👍👍👍
It's really very helpful Brother
bht bht bht bht bht achi knowledge really helpful
Execellent sir i love your talent
Waw very nice video sir ji very good
Bahut Dhanyavad, Jai Siyaram.
Mere dost deepak thanks
Thank you sir!!
hello sir
nice and important secession
thanks
Super guru
🤗😊😊
best teacher
😊♥️♥️
Thank you so much sir🤗👍👍👍👍
Deepak ji.. It's very gud
Ab tk video me sbse best h ye
So dear sir keep it up
Thanku
Thank you bro its helpful
Useful video,Nice
😊
Useful video sir
Very good video
Superb thank you sir.
👍
For your valuable teaching
Very useful Sir, thank you.
😊😊😊
You are great yeaar
🤗😊
Thanks bhaiiii
Nice job man. Learn alot from your videos. es format me jab aik month ki entries kar lyty hain phir jb next month ko select karty hain tu wohi entries dobara ajati hain. agar entries ko delete kar dain tu previous month sy be khatam ho jati hain. es ka koi hal bataye plz.
I ll publish next part of this video shortly
@@DeepakEduWorld Thanks and will be waiting for the new video.
Thank your so much sir
First time kisi ki video really like krne Ka mn kr rha hai
very nice vedio
Lot of Thanks Mr.Deepak very helpful Excel attendance sheet!
Not helpful man its seems smart but actualy there is nothing valueable this is just waste of time you just try tum khud ko gali dene lagoge ek bar try karke dheko
really appreciated video.....good brother keep it up
😊
Out standing sir ji I am waiting for new video
Good evening sir
😊 good morning
Excellent Deepak sahib you have very well knowledge about Excel I have seen yours more video about excel my child says that uncle Deepak has fully command in formulas of Excel.
( Kamal ha bie)
😊
Nice. Tutorial
😊
this is very bioinformatic Love from Pakistan bro
😊
Good job..
Can I use this for student attendance also... Or need to change some format
thank you sir .... nice video next month ke liye new sheet create karni padti he kaya
Noooo.. I m publishing another video shortly on this topic
Super bro awesome
😊😊
Superb
Really you Are very professional Thank you
Thanks for such video uploaded by you. Please make an user form to perform this attendance register which stores data in an excel sheet.
Really good work
Super 👌
Wonderful explanation and so much helpful, thanks for tutor
Good work👌👌👌
Excellent
Easy to teach