المدة الزمنية 21:13

Fully Automated Attendance Sheet in Excel

بواسطة Deepak EduWorld

1 219 857 مشاهدة

21.2 K

تم نشره في 2021/07/15

Fully Automated Attendance Sheet in Excel A to Z Excel : /channel/UCs4qwt3z81ErKjUE0obmTlg dosto Microsoft excel main attendance kaise maintain kartey hai is topic par main pahele hi 4 videos apke sath share kar chuka hun jinme maine apko alag alag tarike se excel me attendance sheet maintain karna sikhaya. is video main bhi mai excel ki 1 aur Fully Automated Attendance Sheet apke sath share kar raha hun jo apke bahut kaam aayegi. ye attendance sheet bhi fully automatic hai jisme sab kuch automatic hoga salary calculations bhi automatic hongi or Sunday automatic lock ho jayenge. aasha ye attendance register aapke bahut kaam aayega in this video you will learn how to create an Fully Automated Attendance Sheet in MS excel - attendance register in excel in Hindi My Channels : Deepak Techworld : https://bit.ly/3qFrbl5 Deepak EduWorld :https://bit.ly/3zWWtIS Deepak Nehra : https://bit.ly/364SVGV Download Training File https://bit.ly/3yYh7XU Chapters 00:00 intro 03:28 Create Automated Attendance Sheet 19:53 Save Attendance Sheet in Excel Templates 21:03 Outro Attendance Sheet Videos: /watch/cwAtfX1cdB0ct /watch/YDNEIfdRO6lRE /watch/4sPLoU2T6rzTL /watch/gjtrjAER0_SRr #AttendanceSheet #AttendanceRegister #Excel #StaffAttendanceRegister #AttendanceTracker #ExcelTutorial #LearnExcel #Excel_Formulas_and_Functions #Excel_online_course #deepakeduworld #Microsoft_Excel #How_To Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day. Deepak EduWorld Playlist's: POWERPOINT COURSE ► /watch/0PbyNhBrkeOry ADVANCED EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► https://goo.gl/wAj1jh MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► https://goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► https://goo.gl/dFhg54 PHOTOSHOP ► /watch/84VcwHkNK4mNc Subscribe Deepak EduWorld ► /deepakeduworld� �� Instagram ► https://www.instagram.com/deepakeduworld Facebook page ► https://www.facebook.com/deepakeduworld� �� LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/deepakedu� ��world Thanks for watching

الفئة

عرض المزيد

تعليقات - 749

@

@DeepakEduWorldمنذ 3 سنوات Subscribe New Channel : A to Z Excel
32
@

@zahidqamar2143منذ 3 سنوات Excellent, i learned something new, pls keep it up 4
@

@amitdas2025منذ 3 سنوات Your vedio is So much Helpfull. and very educational
Thank you Deepak Ji . 1
@

@mddaoodali7375منذ 3 سنوات Sir.your video very helpful.no suspense.
But overtime coloum also must be included. 3
@

@ManojGupta-nl8fjمنذ 3 سنوات So nice, Sir Aapke sabhi video me naya sikhne ko milta hai jo bahut hi upyogi hota hai. Mai video me di gai tips ka upyog karke apne office work ko smart tarike se kar pata hu. Thank you so much 1
@

@NMPSONGSمنذ 3 سنوات Very useful tutorial.
Thank you so much. 1
@

@HongkongTelecom1منذ 2 سنوات Deepak sir, Thanks for this skillful video. Love from Pakistan.
@

@hemrajgurjar7472منذ 3 سنوات Great knowledge sir. Really useful content 2
@

@UATECHYGRAPHICSمنذ 3 سنوات Amazing brother
You deserve more success 2
@

@somisettyjaganmohanrao9451منذ 2 سنوات Thankyou Deepak
I learned some formulas and formats thru this video.
this is very useful for everyone
@

@sanjaypatil9592منذ 3 سنوات Excellent! I haven't done any formal computer course but you have explained the topic very easily.
I am running a RO water buisness and keeping records manually can you make video on this? 3
@

@muhammadrizwan2629منذ 3 سنوات Outstanding effort , Respect from Pakistan
@

@success4624منذ 3 سنوات Badhiya hai bhai. badi mehnat lagaayi hai aapne.. bahot kuch seekhane ko mila hai aapse. koti naman aur dhanyavaad
@

@anisulhoquechowdhury7873منذ 3 سنوات Tnx, learnt many things frm ur video.. Would u pls prepare a demo tournament fixtures where i input goal number beside team in 1st round, deserving team id="hidden4" class="buttons"> take place in 2nd round automatically. After inputting goal in 2nd round, deserving team take place in Quarter Final automatically. Thus go on to Final. Dat means i don’t need to rewrite team name frm 2nd round. Tnx ....وسعت 2
@

@travelyaareeمنذ 3 سنوات Hi Deepak, thanks for a nice video. I am just wondering if we can lock Saturday as well so that entry cant be done for Sat as well?? 1
@

@suvendusamanta4242منذ 2 سنوات Thankyou sir this video is very helpful thankyou 1
@

@TheKing-yd2stمنذ 3 سنوات Very good work. When I followed your instructions I could not do only one thing. After date insertion, minimised space, 'from' to 'date' id="hidden5" class="buttons"> portion become blurred. If I make that clear, space of date increases. Please tell me what to do? ....وسعت 3
@

@vijayikale9366منذ 2 سنوات Thank you helped me to upgrade my work style
@

@krishnamoorthy5953منذ 2 سنوات Useful information video. Thanks for your valuable support and update sir
@

@KundanKumar-hk5eyمنذ 3 سنوات Aapki ye jankari mere liye bahot helpfull he sir thanku so much
@

@Hawalk76-fb4pkقبل 2 أشهر Useful information video. Thanks for your valuable support and update,
But if there are two days are OFF Like Saturday & Sunday then how the data validation can applied?
@

@muhammadtaqi4435منذ 2 سنوات Very well and informative video. Kindly tell us how can highlighted both days Saturday & Sunday. In this video, you only told about Sunday.
Kindly share the any formula about this.
@

@ragivdutta09منذ 3 سنوات Good job.quick and easy way.appreciate it and do keep up the good work
@

@sairamvadranapu4760منذ 2 سنوات Thank you, this video helped me a lot. Keep up the good work
@

@sunithap1189منذ 3 سنوات Wonderful and very useful video sir,tq so much 1
@

@trickysportsbesttricks7383منذ 2 سنوات I have a bookstore. With your help, I have maintained a cash sales letter in the excel of daily sales. I want that whoever sells the book by mentioning id="hidden8" class="buttons"> it in the cash sale letter, he should automatically tell the balance of the number of books in stock and the total value of the book. please make a video of it ....وسعت
@

@shivajaiswal985منذ 3 سنوات Tera video dekh raha bhai bahot acha lag raha h.thumbs up
@

@m.ramzanakhtarrao8261العام الماضي Can we save separately on monthly basis in same file when on required I can see the monthly attendance
@

@asharjawaid4286منذ 3 سنوات The record needs to be unique for every month and for every individual in the sheet month wise. So how to make it that way, also how can we merge if we id="hidden9" class="buttons"> already have a record on different sheet. Please add some more information to make it work finally. thanks ....وسعت 2
@

@ayeshhkhan8132العام الماضي 1 year ago
Hi Deepak,thank you for all your useful videos,tips and tricks.
I have a question, even though this attendance register is automated id="hidden10" class="buttons"> but when I change month entries from the previous months are still in the can I get a blank sheet when I go to next month? Please advise on that ....وسعت 2
@

@vivekbharti9090منذ 3 سنوات K4 ko Lock karne ke liye Kaun se key use karte hai 1
@

@sathidey837منذ 2 سنوات Nice video. I learnt two new things.tnx 1
@

@pratshukمنذ 3 سنوات Pls advise formula -
Our Attendance starts from 27 day of the month till next month 27th 1
@

@communicationmuthayammal6267منذ 3 سنوات Thank you Deepak, i'm using this format for students attendance but i have a problem while we move on next month, pervious month attendance is available so please clarify me. 7
@

@mehmoodkhalid109منذ 2 سنوات Hi Deepak, thanks for a nice video , KEEP IT UP
@

@darshanshah5502منذ 3 سنوات I want a Formula for Sat and Sun off. As we are having 5 days week. 8
@

@TRMNPSمنذ 3 سنوات EXCELLENT VIDEO
CAN WE SAVE DATA OF EVERY MONTH IN ONE SHEET. 2
@

@navneetkumaragarwal9284منذ 3 سنوات My salary month is from 21 to how I create for this attendence sheet 1
@

@46ashwiniمنذ 3 سنوات Very useful, u hv very good knowledge.
@

@shamoonraza2076منذ 3 سنوات Sir apki repots bht achi he in
Kindly fully automatic recipe cost ka format tutorial b btein 1
@

@excel1173منذ 3 سنوات Sir iske alva new practical project jo company and business me use hota vo bhi batao please sir
Really you are superb master in excel ❤️❤️❤️ 2
@

@anupsharma4303منذ 3 سنوات Wow! it's vedio magnificent for us
@

@dkmusical2017منذ 3 سنوات Very gud sir bahut advance hai toh thanks sir
@

@deepranaup710منذ 3 سنوات Sir punching time ke according bnaoo attendance sheet, jisme time ho or late time deduction bhi ho 42
@

@paighamofficial-0منذ 3 سنوات Thank you for the polite request to put a project link in all your videos 1
@

@a4afreeenمنذ 3 سنوات Nice video, very helpful.
Your new channel has nothing, no video in it. 1
@

@totalgamings.g2662منذ 2 سنوات Thanks for vidio
Thanks sir
Ase hi Excel document kora debe
@

@raajaas2200منذ 2 سنوات VERY NEEDFULL & HELPFULL THANKS.ONE MORE QTN. SIR IF WE GO TO FILL P OR A AFTER FILL I WANT THAT COLUMN IS LOCKED NO ANYBUDY CHANGE THAT COLUMN FOR SECU.PURPOSE CAN THIS POSIBLE SIR.
@

@atif54989منذ 3 سنوات Sir bhot khob .kindly daybook b banay .jis mein yeh b bty ga k jo log aj pasy ly kr gy h.but bill kal ya hafty baad dy gy us ko kasy apni daybook mein rkh 1
@

@omprakashthakur4515منذ 3 سنوات So nice tips thank you so much sir, sir day Sunday hi to automatic column merge karnemilega kaya sir 4
@

@muhammadtahiramin4740منذ 2 سنوات Hi, too smart work, but i have one question please, i two days off in a company than data validation formula how for block cell entry. Please let me know. Waiting 1
@

@arfanrasheed9941منذ 3 سنوات Informative video bro 1 swal hy mera agr classes 1 ki bjae 2 hoti hen college me same date pe 2 attendance kese add krien gy? Ya agr kisi din koi class id="hidden16" class="buttons"> ni hy to us ko manually eliminate krna pre ga? Ya agr koi public holiday ajata to us ko kese highlight krien gy , waiting for your response thanks in advance ....وسعت
@

@rajkumar5461منذ 3 سنوات THIS VIDEO SHOULD BE TO SET ANY HOLIDAY- SUNDAY, SECOND SATURDAY OR ANY OTHER HOLIDAY- AS NOT MARKING AND MESSAGE "HOLIDAY". BESIDES IT THERE SHOULD BE COUNTING OF HOLIDAY IN PRESENCE IF PRE OR POST IS PRESENNCE. 9
@

@asharafkhan1951منذ 3 سنوات Deepak ji autometic admition form par vedio banaye jo autometic PDF me save bhi ho jaye 3
@

@makkimax5834منذ 3 سنوات Very Nice Dear.. lekin agr Sat and Sun ko lock karna ho to 2 columns pr kesy formula lagega? 1
@

@kailaschavan4075منذ 3 سنوات Hello sir this video is very nice and useful but 1 video is required for the same organization, where is working continue going on 24/7 and there employees id="hidden18" class="buttons"> weekly off is different day in week.
And pls also require name of Month and week days in Hindi. ....وسعت
@

@bvenkatesh8708منذ 3 سنوات Dear sir thanks for this information.
Nd I want same information vertical way is it possible plz advise 1
@

@asadmasood3399منذ 3 سنوات Great video.
Jb mein aik month ke attendance bnata hun or drop-down sy month change kirta hun to wo attendance is month mein b show hoti hy. Is ko kis trha solve kiryen gey?
@

@rahilgamingzone10منذ 2 سنوات Daily wages ke liye A aur P ke saath OT aur Half day per video banao pls. 1