Duration 21:13

Fully Automated Attendance Sheet in Excel

by Deepak EduWorld

1 219 861 watched

21.2 K

Published 15 Jul 2021

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

Category

Comments - 749

@

@DeepakEduWorld3 years ago Subscribe New Channel : A to Z Excel
32
@

@zahidqamar21433 years ago Excellent, i learned something new, pls keep it up. 4
@

@amitdas20253 years ago Your vedio is so much helpfull. And very educational
thank you deepak ji. 1
@

@mddaoodali73753 years ago Sir. Your video very helpful. No suspense.
but overtime coloum also must be included. 3
@

@ManojGupta-nl8fj3 years ago 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
@

@NMPSONGS3 years ago Very useful tutorial.
thank you so much. 1
@

@HongkongTelecom12 years ago Deepak sir, thanks for this skillful video. Love from pakistan.
@

@hemrajgurjar74723 years ago Great knowledge sir. Really useful content. 2
@

@UATECHYGRAPHICS3 years ago Amazing brother
you deserve more success. 2
@

@somisettyjaganmohanrao94512 years ago Thankyou deepak
i learned some formulas and formats thru this video.
this is very useful for everyone.
@

@sanjaypatil95923 years ago 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
@

@muhammadrizwan26293 years ago Outstanding effort, respect from pakistan.
@

@success46243 years ago Badhiya hai bhai. Badi mehnat lagaayi hai aapne. Bahot kuch seekhane ko mila hai aapse. Koti naman aur dhanyavaad.
@

@anisulhoquechowdhury78733 years ago 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 . ...Expand 2
@

@travelyaaree3 years ago 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
@

@suvendusamanta42422 years ago Thankyou sir this video is very helpful thankyou. 1
@

@TheKing-yd2st3 years ago Very good work. When i followed your instructions i could not do only one thing. After date insertion, minimised space, #39; from' to ' date' . ...Expand 3
@

@vijayikale93662 years ago Thank you helped me to upgrade my work style
@

@krishnamoorthy59532 years ago Useful information video. Thanks for your valuable support and update sir.
@

@KundanKumar-hk5ey3 years ago Aapki ye jankari mere liye bahot helpfull he sir thanku so much.
@

@Hawalk76-fb4pk3 months ago 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?
@

@muhammadtaqi44352 years ago 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.
@

@ragivdutta093 years ago Good job. Quick and easyit and do keep up the good work.
@

@sairamvadranapu47602 years ago Thank you, this video helped me a lot. Keep up the good work.
@

@sunithap11893 years ago Wonderful and very useful video sir, tq so much. 1
@

@trickysportsbesttricks73832 years ago 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 . ...Expand
@

@shivajaiswal9853 years ago Tera video dekh raha bhai bahot acha lag raha h. Thumbs up.
@

@m.ramzanakhtarrao8261last year Can we save separately on monthly basis in same file when on required i can see the monthly attendance.
@

@asharjawaid42863 years ago 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 . ...Expand 2
@

@ayeshhkhan8132last year 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 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 .. ...Expand 2
@

@vivekbharti90903 years ago K4 ko lock karne ke liye kaun se key use karte hai. 1
@

@sathidey8372 years ago Nice video. I learnt two new things. Tnx. 1
@

@pratshuk3 years ago Pls advise formula -
our attendance starts from 27 day of the month till next month 27th. 1
@

@communicationmuthayammal62673 years ago 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
@

@mehmoodkhalid1092 years ago Hi deepak, thanks for a nice video, keep it up.
@

@darshanshah55023 years ago I want a formula for sat and sun off. As we are having 5 days week. 8
@

@TRMNPS3 years ago Excellent video
can we save data of every month in one sheet. 2
@

@navneetkumaragarwal92843 years ago My salary month is from 21 to how I create for this attendence sheet 1
@

@46ashwini3 years ago Very useful, u hv very good knowledge.
@

@shamoonraza20763 years ago Sir apki repots bht achi he in
kindly fully automatic recipe cost ka format tutorial b btein. 1
@

@excel11733 years ago 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
@

@anupsharma43033 years ago Wow! It' s vedio magnificent for us.
@

@dkmusical20173 years ago Very gud sir bahut advance hai toh thanks sir.
@

@deepranaup7103 years ago Sir punching time ke according bnaoo attendance sheet, jisme time ho or late time deduction bhi ho. 42
@

@paighamofficial-03 years ago Thank you for the polite request to put a project link in all your videos. 1
@

@a4afreeen3 years ago Nice video, very helpful.
your new channel has nothing, no video in it. 1
@

@totalgamings.g26622 years ago Thanks for vidio
thanks sir
ase hi excel document kora debe.
@

@raajaas22002 years ago 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.
@

@atif549893 years ago 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
@

@omprakashthakur45153 years ago So nice tips thank you so much sir, sir day sunday hi to automatic column merge karnemilega kaya sir. 4
@

@muhammadtahiramin47402 years ago 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
@

@arfanrasheed99413 years ago 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 . ...Expand
@

@rajkumar54613 years ago This video should be to set any holiday- sunday, second saturday or any other holiday- as not marking and messagebesides it there should be counting of holiday in presence if pre or post is presennce. 9
@

@asharafkhan19513 years ago Deepak ji autometic admition form par vedio banaye jo autometic pdf me save bhi ho jaye. 3
@

@makkimax58343 years ago Very nice dear. Lekin agr sat and sun ko lock karna ho to 2 columns pr kesy formula lagega? 1
@

@kailaschavan40753 years ago 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 and pls also require name of month and week days in hindi. ...Expand
@

@bvenkatesh87083 years ago Dear sir thanks for this information.
nd i want same information vertical way is it possible plz advise. 1
@

@asadmasood33993 years ago 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?
@

@rahilgamingzone102 years ago Daily wages ke liye a aur p ke saath ot aur half day per video banao pls. 1