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

Поділитися
Вставка
  • Опубліковано 25 сер 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

КОМЕНТАРІ • 359

  • @DeepakEduWorld
    @DeepakEduWorld  Рік тому +66

    Dosto Kaisa Laga Video 🙏

    • @shivanikashyap8592
      @shivanikashyap8592 Рік тому +2

      Osam video & congratulations 1 million subscription.

    • @nafisalam3937
      @nafisalam3937 Рік тому +1

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

    • @user-ew7ue2fe8c
      @user-ew7ue2fe8c Рік тому +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

  • @user-ew7ue2fe8c
    @user-ew7ue2fe8c Рік тому +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... 🙏

  • @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.....

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Рік тому

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

  • @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.

  • @childrensgyan8123
    @childrensgyan8123 Рік тому +2

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

  • @muhamadfareedsaeed4153
    @muhamadfareedsaeed4153 Рік тому

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

  • @muhammadiftikhar5856
    @muhammadiftikhar5856 Рік тому +1

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

  • @Vanshushorts778
    @Vanshushorts778 Рік тому

    ❤❤❤ maine apke jaise samjane wala UA-camr poori UA-cam pr nahi Mila thank you Bhai 👍👍👍

  • @zahirbabar8055
    @zahirbabar8055 Рік тому +3

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

  • @thedebapriyakar
    @thedebapriyakar 3 місяці тому

    Bohot hi khatarnaak and beautiful tutorial. Well done!

  • @Moizfoodi
    @Moizfoodi 10 місяців тому +1

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

  • @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, UA-cam me bohut channel hay lakin o sab nahi link share karte hay, app ki teaching techniques mind-blowing, thank you sir ❤️❤️❤️

  • @darshitchavda8264
    @darshitchavda8264 Рік тому +1

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

  • @narendrasaini6264
    @narendrasaini6264 Рік тому +1

    Sir aap bhut acha explain karte ho

  • @khiladichunky3673
    @khiladichunky3673 Рік тому +1

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

  • @dafdaanil1979
    @dafdaanil1979 Рік тому

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

  • @mohdshuaib1914
    @mohdshuaib1914 Рік тому +1

    Aap ki videos bhut aachi aati hai

  • @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

  • @VBASqlAccessPowerApps
    @VBASqlAccessPowerApps Рік тому +2

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

  • @angadpandit7077
    @angadpandit7077 Рік тому +2

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

  • @rajantech3572
    @rajantech3572 Рік тому +2

    Sir bahut hi badiya and best ❤

  • @intzar_Express
    @intzar_Express Рік тому

    No1 excel expert on youtube

  • @umarshafi3815
    @umarshafi3815 Рік тому

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

  • @rajurock1532
    @rajurock1532 Рік тому

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

  • @akm6370
    @akm6370 Рік тому

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

  • @nitendramishra1680
    @nitendramishra1680 10 місяців тому +1

    mind blowing sir very use full for me

  • @umairzahid3743
    @umairzahid3743 Рік тому +1

    Sir congratulations you are so sweet and hardworker

  • @tarakpopat2150
    @tarakpopat2150 Рік тому +1

    Very Good facilitator and great

  • @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.
    .

  • @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…

  • @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

  • @harshdas7009
    @harshdas7009 Рік тому +1

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

  • @poetryforthesoulwithwaseem6599

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

  • @parvezrajani4930
    @parvezrajani4930 Рік тому +1

    congratulation for 1m supporters

  • @ashokbihari7433
    @ashokbihari7433 Рік тому +1

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

  • @m.umairrafat3231
    @m.umairrafat3231 Рік тому +1

    Many many congrats bro for 1 million subscribers

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Рік тому

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

  • @manishdiwan1362
    @manishdiwan1362 Рік тому +2

    Well done 👍👍👍 sir

  • @shaileshsolanki7763
    @shaileshsolanki7763 Рік тому +1

    Bahut hi badhiya hai sir..

  • @jodharawat4744
    @jodharawat4744 Рік тому +1

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

  • @LiaqatAli-qk8yp
    @LiaqatAli-qk8yp 24 дні тому

    Really good for students as well as office staff

  • @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

  • @kishorpanara4191
    @kishorpanara4191 Рік тому +1

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

  • @ttqshow9957
    @ttqshow9957 Рік тому +1

    Congratulations 🎉 for 1M Subscribers❤
    Thanks for video😊

  • @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

  • @jmotsara
    @jmotsara Рік тому

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

  • @shajar_A0A
    @shajar_A0A Рік тому +1

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

  • @TheHimanshushah37
    @TheHimanshushah37 Рік тому +1

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

  • @preetamsingh1761
    @preetamsingh1761 Рік тому +2

    Excellent ! Many many congratulations Sir for 1 M subscribers 🎉🎉

  • @kanhucharanadas3948
    @kanhucharanadas3948 Рік тому +1

    Congratulations Deepak sir
    For 1 million subscribers

  • @_aman_lx_
    @_aman_lx_ Рік тому +2

    Nice video sir..❤️

  • @suryaanil6173
    @suryaanil6173 11 місяців тому +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

  • @hobbyzmixhm784
    @hobbyzmixhm784 Рік тому +1

    Very fruitful video especially for payroll concerns.

  • @santoshhulenawar8519
    @santoshhulenawar8519 8 місяців тому

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

  • @khanzahid2003
    @khanzahid2003 Рік тому +2

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

  • @goodman-it2qy
    @goodman-it2qy Рік тому +1

    Yes you really said never seen before.

  • @sainathshinde6765
    @sainathshinde6765 Рік тому +1

    Great sir 😊always helpful

  • @arabianseagull
    @arabianseagull Рік тому +1

    Congratulation on your first 1Million subscriber's brother Deepak 🙏

  • @user-ev7yb4yq5q
    @user-ev7yb4yq5q 2 місяці тому

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

  • @ta20111996
    @ta20111996 Рік тому +1

    Excellent! very unique technic. 👌

  • @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.
    ❤❤❤

  • @arvindkmr427
    @arvindkmr427 Рік тому

    Awesome trick

  • @rakeshnaidi9417
    @rakeshnaidi9417 Рік тому +1

    Super sir ji

  • @pintu4420
    @pintu4420 6 місяців тому

    Very useful

  • @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

  • @shahidanis8838
    @shahidanis8838 Рік тому +1

    Brilliant Sir

  • @nitinsingh.2107
    @nitinsingh.2107 Рік тому +1

    Excellent 👍

  • @yogeshpatel5333
    @yogeshpatel5333 Рік тому +1

    Festival holiday highlight ho jaye to maja aa jaye.

  • @dineshdutt4653
    @dineshdutt4653 Рік тому

    Very nice video

  • @chhaviranjan5543
    @chhaviranjan5543 Рік тому +1

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

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi Рік тому +1

    Beautiful work. Thanks for the share.

  • @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.

  • @jamilbalakarzai847
    @jamilbalakarzai847 Рік тому +1

    So Much Helpful, and congratulations for 1 M Subscribers

  • @purnimakundu1239
    @purnimakundu1239 Рік тому +1

    Plz give more sir

  • @mohammadilyas2260
    @mohammadilyas2260 Рік тому

    Excellent زبردست

  • @shahqasim8513
    @shahqasim8513 Рік тому +1

    Welldone 🌺

  • @SarikaSharma-st7fu
    @SarikaSharma-st7fu Рік тому

    Superb...

  • @JASRIN1020
    @JASRIN1020 Рік тому +1

    congratulation for 1 m

  • @parmarmaulik5634
    @parmarmaulik5634 Рік тому +1

    thank you

  • @prateekkherde
    @prateekkherde Рік тому +2

    Deepakji please make video for appointments scheduler

  • @bilalmalik728
    @bilalmalik728 Рік тому +1

    Excellent

  • @bittu25
    @bittu25 11 місяців тому

    Thanks for teaching.

  • @mhodqasim5616
    @mhodqasim5616 4 місяці тому +1

    janab bahut hi jabardast magar over time kese add karean

  • @Office-Monk
    @Office-Monk Рік тому +1

    Good one Deepak

  • @user-ko7iz3wv3k
    @user-ko7iz3wv3k Рік тому +1

    it was nice video

  • @sachin19789
    @sachin19789 6 місяців тому

    Very nice

  • @qasikhan
    @qasikhan Рік тому

    Well done

  • @LawSchool1947
    @LawSchool1947 Рік тому

    Good Job

  • @upendrarauta3749
    @upendrarauta3749 Рік тому +1

    Mozilla Thunderbird ka bareme full vedio banaye

  • @Abrar.saeed_official
    @Abrar.saeed_official Рік тому +1

    ❤superb Work ❤

  • @damodardas9363
    @damodardas9363 Рік тому +1

    Sir kuch stock market trading templet ke bare main video banaye

  • @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…

  • @SkyofficialTrader
    @SkyofficialTrader Рік тому +1

    Thank you sir❤

  • @JibbyMajid
    @JibbyMajid Місяць тому

    love frm Karachi

  • @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

  • @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.

  • @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 🙏

  • @gurudasmukherjee4524
    @gurudasmukherjee4524 Рік тому +1

    Looking smart

  • @naveensaini1301
    @naveensaini1301 Рік тому +1

    Sir apne Excel ka full course kra rkha h ky apne Channel pe