New ! 🔥 Fully Automated Attendance Sheet in Excel ( You've Never Seen Before )

Поделиться
HTML-код
  • Опубликовано: 13 окт 2024
  • Excel me dosto fully automated professional attendance sheet kaise banaye ye is video me maine detail me sikhaya hai jisme aap month wise or year wise attendance easily maintain kar saktey hain... attendance sheet ke 5 videos main pahele hi apke sath share kar chuka hun jinme maine alag alag tarike se apko attendance maintain karna sikhaya... but ye vali sheet sabse alag hai jo bilkul simple but fully automated hai jisko aap step by step aasani se excel ke kisi bhi version me bana saktey ho umeed hai ye attendance register apke kaam aayega
    in this video you will learn how to create a Fully Automated Attendance Sheet in MS excel - attendance register in excel in Hindi
    Download Training File : bit.ly/3K4Yh9R
    Attendance Sheet Videos :
    • How To Make Attendance...
    • 🔥🔥 Fully Automated Att...
    • How To Maintain Attend...
    • 😮 Create Fantastic Ful...
    • How to Maintain Attend...
    My Channels :
    A to Z Excel : bit.ly/3hQCRiw
    Deepak Techworld : bit.ly/3qFrbl5
    Deepak EduWorld :bit.ly/3zWWtIS
    Deepak Nehra : bit.ly/364SVGV
    Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
    Deepak EduWorld Playlist's:
    POWERPOINT COURSE ►
    • MS Power Point Tutoria...
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    EXCEL TIPS & TRICKS ►
    goo.gl/wAj1jh
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ►
    goo.gl/paZmpn
    AUTOMATIC INVOICE IN EXCEL ►
    goo.gl/dFhg54
    PHOTOSHOP TUTORIALS ►
    bit.ly/3kJyIBv
    Thanks for Watching
    Deepak EduWorld

Комментарии • 375

  • @DeepakEduWorld
    @DeepakEduWorld  Год назад +68

    Dosto Kaisa Laga Video 🙏

    • @shivanikashyap8592
      @shivanikashyap8592 Год назад +2

      Osam video & congratulations 1 million subscription.

    • @nafisalam3937
      @nafisalam3937 Год назад +2

      video bahut badiya hai bhai lekin ek request hai ki ek video pay slip per banao using vba macros

    • @DREAMCATCHER-o1q
      @DREAMCATCHER-o1q Год назад +1

      Kamal ki video hei sir, ur always gven us amazing trickks such as simply way.

    • @MasterNivaan
      @MasterNivaan Год назад +1

      congratulations deepak ji.... one day we make history🎉

    • @GyanBLimbu-xh9zs
      @GyanBLimbu-xh9zs Год назад +1

      Sir jab maine January ka data enter kiya toh wo February March sabhi months me aa rha hai
      Please help

  • @muhamadfareedsaeed4153
    @muhamadfareedsaeed4153 Год назад

    بہترین بہت محنت سے آپ سکھا رہے ہیں
    بہت خوب

  • @DREAMCATCHER-o1q
    @DREAMCATCHER-o1q Год назад +2

    AM FROM KERALA.... AM FOLLOWING UR CLASESS TO IMPROOVE MY SELF IN EXCEL. ACTUALLY AM A BEGINER OF EXCEL.... BUT UR CLASES MAKES ME CRAZY ABOUT EXCEL. UR EXPLANATION SKILL IS VERY NICE SO SIMPLE ANYONE CAN CATCH IT.
    THANK U... 🙏

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Год назад

    3 year sa app ka subscriber ho boht achi video mile hn..with practice file👌🏻👌🏻👌🏻👌🏻👌🏻

  • @vikashmourya8964
    @vikashmourya8964 Год назад +1

    Sir aap genius ho ......Maine apse bahut Kuch sikha hai....aur hamesa sikhta rahunga.....muche lagta hai Zindagi Mai sabse jaruri ek accha insaan banna jaruri h....

    • @DeepakEduWorld
      @DeepakEduWorld  Год назад

      Bilkul vikash g … learning kabhi mahenat or learning kabhi waste nhi jaati 😊😊😊

    • @vikashmourya8964
      @vikashmourya8964 Год назад

      ​@@DeepakEduWorld sir plz VBA bhi sikhaye hame bilkul basic to advance.....

  • @narendrasaini6264
    @narendrasaini6264 Год назад +1

    Sir aap bhut acha explain karte ho

  • @childrensgyan8123
    @childrensgyan8123 Год назад +2

    बहुत ही अच्छी वीडियो लगी इससे बहुत अधिक ज्ञान बड़ा है मुझे यह बहुत खुशी हुई कि आपने यह फाइल का डाउनलोड के लिए लिंक भी दिया पर सर यह बताइए एक से ज्यादा वीक ऑफ हो तो या फिर होलीडे हो तो हम इस फार्मूले में क्या एडिटिंग करेंगे और एक बात और है सर week off वाले दिन कुछ कर्मचारियों ने काम करा हो तो उनके लिए उनके लिए क्या कंडीशन लगानी पड़ेगी पर मैं बहुत खुश हूं आप की बनाई हुई वीडियो से धन्यवाद सर धन्यवाद

  • @Vanshushorts778
    @Vanshushorts778 Год назад

    ❤❤❤ maine apke jaise samjane wala RUclipsr poori RUclips pr nahi Mila thank you Bhai 👍👍👍

  • @rajurock1532
    @rajurock1532 Год назад

    Sir Apka Class Achha Lagta hay. AP ka Voice bohut Achha Hay.

  • @mohdshuaib1914
    @mohdshuaib1914 Год назад +1

    Aap ki videos bhut aachi aati hai

  • @dafdaanil1979
    @dafdaanil1979 Год назад

    Great 👍 Sir ji 👍 Aapkaa sikhana bahut hi zabardast hai great great great 👍👍👍 Sir

  • @GyanBLimbu-xh9zs
    @GyanBLimbu-xh9zs Год назад +1

    Amazing format sir
    Jab maine data entry kiya January me toh wo sab February me bhi wahi aur March me bhi and continue
    Please guide me

    • @DeepakEduWorld
      @DeepakEduWorld  Год назад

      Apne formulas me mistake ki hai… cell lock nahi kiye sayed.. fir se try karo 1 baar video dekh ke step by step formulas lagao

  • @atuljanardan3783
    @atuljanardan3783 Месяц назад +1

    suuuuuper video bhai. aur kam ke video bhejo. googgle sheet ki jaroorat nahi hai na?? excel sheet pe ho jayega na kamm??

  • @Moizfoodi
    @Moizfoodi Год назад +1

    Very nice …. Wow… you are the best teacher…. Shabir from Dubai….

  • @darshitchavda8264
    @darshitchavda8264 Год назад +1

    before watch this video i must say .... Really awesome.....

  • @tarakpopat2150
    @tarakpopat2150 Год назад +1

    Very Good facilitator and great

  • @Joydip007
    @Joydip007 Год назад

    Sir app to bohut Kamal ki video banate hay, app ki video se maine bohut kuch sikha and implement kya, thank you and app eisehi bohut accha video banaiya, and app ko ek chis accha lagta hay app practice karne klea file ko download option deta hay, RUclips me bohut channel hay lakin o sab nahi link share karte hay, app ki teaching techniques mind-blowing, thank you sir ❤️❤️❤️

  • @muhammadiftikhar5856
    @muhammadiftikhar5856 Год назад +1

    Deepak Sahib heartiest congratulation from me no dout you are master of Excel. I am watching yours videos regularly.

  • @thedebapriyakar
    @thedebapriyakar 4 месяца назад

    Bohot hi khatarnaak and beautiful tutorial. Well done!

  • @graphicdesign2507
    @graphicdesign2507 Год назад +1

    Ap ka kam bohat acha he ❤ kya ap attendence sheet or monthly salery with overtime be ho us pr video bna dayn plz attendance be lag jay or overtime be calculate ho jay salery be nikl jay monthly plzz

  • @intzar_Express
    @intzar_Express Год назад

    No1 excel expert on youtube

  • @rajantech3572
    @rajantech3572 Год назад +2

    Sir bahut hi badiya and best ❤

  • @shaileshsolanki7763
    @shaileshsolanki7763 Год назад +1

    Bahut hi badhiya hai sir..

  • @akbarmajeed9034
    @akbarmajeed9034 Год назад +6

    Good work. Very helpful. Kindly add calculation of overtime on Sunday or daily hours basis. For example if our working hours are 10am to 6 pm and if worker work till 10 pm how we calculate automatically the overtime hours.

  • @umarshafi3815
    @umarshafi3815 Год назад

    Its very helpful.. Lots of love from Pakistan.. ❤

  • @akm6370
    @akm6370 Год назад

    बहुत ही अच्छी वीडियो है ये
    इसमें मुझे एक चीज एड करनी है की जैसे कई कंपनी में 7 डेज वर्क होता है और एम्प्लॉय की अलग अलग दिन छुट्टी होती है उसको हम। इसमें कैसे मैनेज कर सकते है
    अगर सेम फॉर्मेट में हम।मैनेज कर सकते है तो प्लीज आप हमे मार्गदर्शन दे।
    या जैसे मैंने ऊपर लिखा है उसपे कोई एक वीडियो ईजी फॉर्मूला के साथ बनाए
    ये वीडियो आपकी काफी सराहनीय है
    बहुत बहुत धन्यवाद 🙏

  • @umairzahid3743
    @umairzahid3743 Год назад +1

    Sir congratulations you are so sweet and hardworker

  • @zahirbabar8055
    @zahirbabar8055 Год назад +3

    Congratulations Mr Deepak for 1 mil subscribers 🎉🎉🎉! I wish now you would post frequent videos!

  • @nitendramishra1680
    @nitendramishra1680 11 месяцев назад +1

    mind blowing sir very use full for me

  • @kishorpanara4191
    @kishorpanara4191 Год назад +1

    Awesome dear but har ek employee ka week off alag alag ho to attendance sheet create kijiye pls dear

  • @nasirabbas8149
    @nasirabbas8149 5 дней назад +1

    Very very nice sir

  • @khiladichunky3673
    @khiladichunky3673 Год назад +1

    Bahut badiya excellent video👌👌
    Thankew Deepak sir aisi aisi videos banane k liye

  • @jodharawat4744
    @jodharawat4744 Год назад +1

    वन मिलियन होने पर आपको बहुत-बहुत बधाई सर 👏👏

  • @aayushraj5017
    @aayushraj5017 Год назад

    Due to excellent I enroll for monthly subscription.
    Hope you keep on great work...
    And make us to improve or Excel in your every excel class.
    .

  • @santoshhulenawar8519
    @santoshhulenawar8519 9 месяцев назад

    Sir god bless you❤...I Learned the Formula

  • @parvezrajani4930
    @parvezrajani4930 Год назад +1

    congratulation for 1m supporters

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Год назад

    Sir very informative this your all videos believe me that..

  • @shajar_A0A
    @shajar_A0A Год назад +1

    Really Great Sir... But Month me koi Week off hi nhi hai to kya kre phr uske liye ???

  • @LiaqatAli-qk8yp
    @LiaqatAli-qk8yp 2 месяца назад

    Really good for students as well as office staff

  • @84iamthebest
    @84iamthebest Месяц назад

    Deepak ji ek video daily project report ki bhi banaiye na. Consultation company ke liye.

  • @9970mario
    @9970mario Год назад +2

    I very much like all of ur videos....very detailed and at a slow pace so all can understand. This same sheet where the off day is hidden..... can u show the off day as well as not all people take off on that particular day as some of them work. For example on Monday some are given off and some are working. So we need to see the Monday column as well. Thank you

  • @84iamthebest
    @84iamthebest Месяц назад

    Great video. Very usefull🎉

  • @suryaanil6173
    @suryaanil6173 Год назад +1

    Sir ur video is excellent.
    Pls tell me, how to get the Present period, leave period.
    I mean, 01 to 05 present, 6-8, leave, 9 to 12 absent..... Vaisa date k saath aaye..
    In ur video, u had taught how to get number of days present or leave. But I need with period.
    Pls reply sir

  • @mohammadilyas2260
    @mohammadilyas2260 Год назад

    Excellent زبردست

  • @damodardas9363
    @damodardas9363 Год назад +1

    Sir kuch stock market trading templet ke bare main video banaye

  • @Virendrasagar1
    @Virendrasagar1 10 дней назад +1

    Deepak sir mein aapse ek request karna hai aap ek stock accounting ki file banaye jismein autometic data set ho

  • @angadpandit7077
    @angadpandit7077 Год назад +2

    sir me आपका वीडियो का इंतज़ार करता था

  • @TheHimanshushah37
    @TheHimanshushah37 Год назад +1

    Superb awesome...But request to make Salary Slip also with this Format.

  • @jmotsara
    @jmotsara Год назад

    दीपक भाई बधाई हो 🎉
    मुझे कंडीशनल फॉर्मेटिंग के बारे में पूछना था।
    जैसे - एक्सेल में सेल खाली हो तो उसमें "Year" लिखा आना चाहिए, अदरवाइज जो लिखें वो आ जाए।
    आपकी मदद की अपेक्षित है।

  • @khanzahid2003
    @khanzahid2003 Год назад +2

    Good learning video. How to prepare alternative saturday off for office staff?

  • @harshdas7009
    @harshdas7009 Год назад +1

    Congratulations, love you bro.. all the very best for future

  • @tinkusharma9129
    @tinkusharma9129 Год назад +1

    Great video
    But I have some questions like if any company have 2 days off in weak then how will manage it or if in any month will extra holiday as diwali, Holi pls suggest..

    • @DeepakEduWorld
      @DeepakEduWorld  Год назад

      Don't worry… i will publish another video on attendance sheet shortly…

  • @islamnavi8409
    @islamnavi8409 Год назад

    Sir agar kisi company me job karte hai ,
    Uske liye hume apni khud ki attendance sheet banani hai,
    Or saal/saal ka data enter karke rakhna hai with salary,
    Iski video banaye sir

  • @bilalmalik728
    @bilalmalik728 Год назад +1

    Excellent

  • @poetryforthesoulwithwaseem6599
    @poetryforthesoulwithwaseem6599 Год назад +1

    You have always been a great help as far as excel is concerned.

  • @emraanrustam4623
    @emraanrustam4623 Год назад +1

    Dear sir, how are you, I hope you will be fine. I requested you to make a video on POS system for grocery.

  • @DebasmitaPradhan-q1f
    @DebasmitaPradhan-q1f Год назад

    Its brilliant. just one request can you please make the same report in Google shear sheet and publish.

  • @kartikbajaj2376
    @kartikbajaj2376 Год назад +1

    Thank you for this . I want to know ki how to add 2 week off . In my company there is 2 days fixed off .. please advise

  • @bittu25
    @bittu25 Год назад

    Thanks for teaching.

  • @manishdiwan1362
    @manishdiwan1362 Год назад +2

    Well done 👍👍👍 sir

  • @m.umairrafat3231
    @m.umairrafat3231 Год назад +1

    Many many congrats bro for 1 million subscribers

  • @siddharthsuman297
    @siddharthsuman297 Месяц назад

    Deepak sir sorry to say but is this sheet feasible because we don't just calculate attendance sheet on the basis of weakoff/half days we also consider CL, SL, PL etc.

  • @kanhucharanadas3948
    @kanhucharanadas3948 Год назад +1

    Congratulations Deepak sir
    For 1 million subscribers

  • @hobbyzmixhm784
    @hobbyzmixhm784 Год назад +1

    Very fruitful video especially for payroll concerns.

  • @goodman-it2qy
    @goodman-it2qy Год назад +1

    Yes you really said never seen before.

  • @gurudasmukherjee4524
    @gurudasmukherjee4524 Год назад +1

    Looking smart

  • @yogeshpatel5333
    @yogeshpatel5333 Год назад +1

    Festival holiday highlight ho jaye to maja aa jaye.

  • @VBASqlAccessPowerApps
    @VBASqlAccessPowerApps Год назад +2

    Big congratulations 🎉 for one million subscribers, VBA is a vast subject It requires many videos and expertise.

  • @naveedbazil6205
    @naveedbazil6205 Год назад +2

    Big congratulations 🎉 for 1 million subscribers. Sir I'm big fan of you. Your style of interpretation is awesome. Sir plz guide me if i want to set two days off like Saturday & Sunday

    • @DeepakEduWorld
      @DeepakEduWorld  Год назад

      Thanks naveed g… i will publish updated version of this sheet shortly…

  • @ashokbihari7433
    @ashokbihari7433 Год назад +1

    sandar hai sir nice sir Sir, हमेशा चिंता में आप हमारे रहते,
    कुछ भी बोले आपसे, पर आप कुछ ना कहते
    देते है अपने Students को एकदम निखार ,
    उन अध्यापकों को हमारा शत-शत नमस्कार

  • @prateekkherde
    @prateekkherde Год назад +2

    Deepakji please make video for appointments scheduler

  • @chhaviranjan5543
    @chhaviranjan5543 Год назад +1

    सर मैं आपकी वीडियो हमेशा देखता हूं आपकी वीडियो मुझे हमेशा कुछ नया सीखने की कोशिश करती है मैं आपकी वीडियो से बहुत प्रभावित होता हूं सर आपने जो अटेंडेंस शीट बनाई है इसमें मंथ चेंज करने पर शीट ब्लैंक होनी चाहिए नहीं तो मन तो और ईयर को ऑटोमेटिक करने का कोई फायदा नहीं रहा प्लीज सर इस पर विचार करें और एक नई वीडियो को प्लीज करें आपका शिष्य

  • @_aman_lx_
    @_aman_lx_ Год назад +2

    Nice video sir..❤️

  • @gunjansubba135
    @gunjansubba135 Год назад +1

    Hi sir it's a good one but I would love too see if can help me to prepare attendance when I change a month data should save automatically and go to another month but if I want to see back mont it should bee showing that save data.

  • @elsiesaavedra8560
    @elsiesaavedra8560 Год назад +1

    Hello. Mr Deepak. Your video gives a very good information. But the problem we cannot understand. Hope there is an english subtitle.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi Год назад +1

    Beautiful work. Thanks for the share.

  • @upendrarauta3749
    @upendrarauta3749 Год назад +1

    Mozilla Thunderbird ka bareme full vedio banaye

  • @rakeshnaidi9417
    @rakeshnaidi9417 Год назад +1

    Super sir ji

  • @hareshk.chodvadiya1418
    @hareshk.chodvadiya1418 Год назад +1

    Dipak sir
    मेनिफेक्सर प्रोडक्ट का विडियो। बनाए ना

  • @ttqshow9957
    @ttqshow9957 Год назад +1

    Congratulations 🎉 for 1M Subscribers❤
    Thanks for video😊

  • @ta20111996
    @ta20111996 Год назад +1

    Excellent! very unique technic. 👌

  • @akgfurniture
    @akgfurniture Год назад +1

    Over time ka atometic video banai na bhai

  • @shahidanis8838
    @shahidanis8838 Год назад +1

    Brilliant Sir

  • @ZOHAIBZEBIM.ZOHAIB
    @ZOHAIBZEBIM.ZOHAIB 3 месяца назад

    I Like your videos very much🥰😍😘💖❤💯

  • @ramkumarpaudel6024
    @ramkumarpaudel6024 Год назад +1

    wow, it's very nice. but i have a problem regarding Attendance of students. i handle a online class that need attendance of students everyday with multiple subjects in a day, i need to maintain subject wise attendance. i don't want to sit in front of computer and speak out student's name one by one, now i'm using google forms to maintain the attendance. if you have easy solution, plz let me know. thank you for your all the educational videos.

  • @arvindkmr427
    @arvindkmr427 Год назад

    Awesome trick

  • @purnimakundu1239
    @purnimakundu1239 Год назад +1

    Plz give more sir

  • @iftikharali6370
    @iftikharali6370 Год назад +4

    Well done Bro, Could you make one video on how to make "Duty Roster" with different schedule time, different off days and a rotational shift Timings.
    Thanks

  • @nitinsingh.2107
    @nitinsingh.2107 Год назад +1

    Excellent 👍

  • @highness-dg3vn
    @highness-dg3vn Год назад +1

    Good day boss
    Thanks a lot for this great tutorial but pls if you could add a subtitle in englis, will be really helpful to some of us.
    ❤❤❤

  • @ashokbihari7433
    @ashokbihari7433 Год назад +1

    sir yak bar pruches ka and sales ka bhi video banay

  • @Crazymachine_44
    @Crazymachine_44 21 день назад +1

    Sir Like your but I want add In time and out time of employee and in send calculate the total hr in month

  • @mhodqasim5616
    @mhodqasim5616 5 месяцев назад +1

    janab bahut hi jabardast magar over time kese add karean

  • @dineshdutt4653
    @dineshdutt4653 Год назад

    Very nice video

  • @pintu4420
    @pintu4420 8 месяцев назад

    Very useful

  • @deepkarmakar6276
    @deepkarmakar6276 Год назад

    Vai fully automatic stock Excel sheet ka ak video banaiye na.

  • @JASRIN1020
    @JASRIN1020 Год назад +1

    congratulation for 1 m

  • @parmarmaulik5634
    @parmarmaulik5634 Год назад +1

    thank you

  • @shahqasim8513
    @shahqasim8513 Год назад +1

    Welldone 🌺

  • @hinaali8069
    @hinaali8069 Год назад +1

    Bro isi sheet main “sat” & “sun” kaisy week off krain ap ny just 1 day explain kia hai off day k liye .please explain that method 🙏