🔥🔥 Fully Automated Attendance Sheet in Excel

Поделиться
HTML-код
  • Опубликовано: 1 ноя 2024

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

  • @DeepakEduWorld
    @DeepakEduWorld  3 года назад +32

    Subscribe New Channel : A to Z Excel
    ruclips.net/channel/UCs4qwt3z81ErKjUE0obmTlg

    • @pa2happiness13
      @pa2happiness13 3 года назад

      👌🏼💞

    • @Ayush7563
      @Ayush7563 3 года назад +1

      Sunday ko double attendence deni hai kaise kare?

    • @bindashbhatt4774
      @bindashbhatt4774 3 года назад

      Sir mujhe online sikha dijiye..Fee pay krunga🙏🙏

    • @PankajKumar-od6ku
      @PankajKumar-od6ku 3 года назад

      How to make broucher , any idea

    • @sandeepsingh-jf5qb
      @sandeepsingh-jf5qb 3 года назад

      Sir आपके इस चैनल पर कब से वीडियो आनी शुरू होंगी क्योंकि excel हम शुरुआत से सीखना चाहते है
      और आपकी teaching skill लाजवाब है✔️💯👍🔥

  • @ManojGupta-nl8fj
    @ManojGupta-nl8fj 2 года назад +1

    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👌👌👌

  • @ramlalkumar2279
    @ramlalkumar2279 3 года назад +2

    Bahut hi aachha laga sir

  • @KundanKumar-hk5ey
    @KundanKumar-hk5ey 3 года назад

    Aapki ye jankari mere liye bahot helpfull he sir thanku so much

  • @shivajaiswal985
    @shivajaiswal985 3 года назад

    Tera video dekh raha bhai bahot acha lag raha h.thumbs up

  • @kawmalmustafa1537
    @kawmalmustafa1537 3 года назад +1

    Thanks sir very nice vedio

  • @AmitKumar-mg9zj
    @AmitKumar-mg9zj 3 года назад +1

    Bahut hi shandaar

  • @debendrasoren1176
    @debendrasoren1176 3 года назад

    Biggest fan sir mein apka ❤️❤️❤️❤️

  • @suvendusamanta4242
    @suvendusamanta4242 2 года назад +1

    Thankyou sir this video is very helpful thankyou 🙏

  • @shamoonraza2076
    @shamoonraza2076 3 года назад +1

    Sir apki repots bht achi he in
    Kindly fully automatic recipe cost ka format tutorial b btein

  • @sagarghadge7693
    @sagarghadge7693 3 года назад

    Gajab.... Gajab kar diya bhai.

  • @sathidey837
    @sathidey837 2 года назад +1

    Nice video. I learnt two new things.tnx

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

    Thenks Guru Ji ❤

  • @AnoopKumar-tg9hj
    @AnoopKumar-tg9hj 2 года назад +1

    Your method is nice

  • @dkmusical2017
    @dkmusical2017 3 года назад

    Very gud sir bahut advance hai toh thanks sir

  • @success4624
    @success4624 3 года назад

    Badhiya hai bhai... badi mehnat lagaayi hai aapne.. bahot kuch seekhane ko mila hai aapse... koti naman aur dhanyavaad 💐💐💐

  • @rupindermishra7379
    @rupindermishra7379 2 года назад +2

    Dear Deepak your vdo is excellent and very helpful can plz guide us when we enter the data in the attendance box in the month of Jan and save the same but the data remain the same in next month (Feb) but actually, that should change.......so plz guide.

    • @Sunrise.i.c
      @Sunrise.i.c 2 года назад

      I am also getting an equal show, present or absent is not changing.

    • @shaiksameer3041
      @shaiksameer3041 2 года назад

      same complaint frnds

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

    Good job brother from Pakistan

  • @rajutallapalli3695
    @rajutallapalli3695 2 года назад +1

    Thank you very much for this video

  • @atif54989
    @atif54989 3 года назад +1

    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

  • @uttammarket2924
    @uttammarket2924 2 года назад

    your traing is a magic, bro

  • @mddaoodali7375
    @mddaoodali7375 3 года назад +3

    Sir...your video very helpful...no suspense.
    But overtime coloum also must be included.

  • @preetikumar3103
    @preetikumar3103 10 месяцев назад +1

    Thank you dear❤ it help me a lot

  • @faridahmadazami4340
    @faridahmadazami4340 2 года назад +1

    Lovely work Deepak jee

  • @amitdas2025
    @amitdas2025 3 года назад +1

    Your vedio is So much Helpfull..... and very educational
    Thank you Deepak Ji .....

  • @sanjaypatil9592
    @sanjaypatil9592 3 года назад +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?

  • @krishnamoorthy5953
    @krishnamoorthy5953 2 года назад

    Useful information video. Thanks for your valuable support and update sir

  • @beautyoftheworld9578
    @beautyoftheworld9578 3 года назад +2

    Great job Deepak Love From Pakistan

  • @nehalahmad480
    @nehalahmad480 2 года назад +1

    Zabardast.. good job Brother

  • @somisettyjaganmohanrao9451
    @somisettyjaganmohanrao9451 2 года назад

    Thankyou Deepak
    I learned some formulas and formats thru this video.
    this is very useful for everyone

  • @ShivamSingh-eq5je
    @ShivamSingh-eq5je 3 года назад +1

    Fantastic knowledge.
    Thanks

  • @sonusrivastav6915
    @sonusrivastav6915 2 года назад +2

    Thank you sir ji

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

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

  • @zahidqamar2143
    @zahidqamar2143 3 года назад +4

    Excellent, i learned something new, pls keep it up

  • @sunithap1189
    @sunithap1189 3 года назад +1

    Wonderful and very useful video sir,tq so much

  • @raghunath7405
    @raghunath7405 2 года назад +1

    Informative thank you very much 🙏

  • @qaisermukhtar8886
    @qaisermukhtar8886 3 года назад

    Usefull Info, Zqbardast....

  • @deepranaup710
    @deepranaup710 3 года назад +42

    Sir punching time ke according bnaoo attendance sheet, jisme time ho or late time deduction bhi ho

    • @jyotiperlekar639
      @jyotiperlekar639 3 года назад +4

      Late time deduction and ot calculations

    • @mayurbhatiya3990
      @mayurbhatiya3990 3 года назад

      Sir suppose if cutoff jan 23 to feb 22 so how can prepare excel sheet

    • @dr.ultrapritam1405
      @dr.ultrapritam1405 3 года назад

      Bade utable ho deduct karneme bhaya...!

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

    Thanks Deepak

  • @manjeetnandal1
    @manjeetnandal1 3 года назад +1

    Great sharing!
    Many thanks!

  • @chandankumarpanda9371
    @chandankumarpanda9371 3 года назад +1

    Excellent work sir ,thanku sir

  • @HopeAndHelp2
    @HopeAndHelp2 3 года назад

    Nice channel for learning 🖥 skills

  • @shivaprasadhn4347
    @shivaprasadhn4347 3 года назад

    Very good application thanks 👍

  • @muhammadrizwan2629
    @muhammadrizwan2629 3 года назад

    Outstanding effort , Respect from Pakistan 🇵🇰

  • @mohdmohtashim7682
    @mohdmohtashim7682 3 года назад

    आपका हार्दिक आभार सरजी।

  • @a4afreeen
    @a4afreeen 3 года назад +1

    Nice video, very helpful.
    Your new channel has nothing, no video in it....

  • @nitinsingh00
    @nitinsingh00 3 года назад

    एक बाद एक सर का ज़ोरदार प्रहार चल रहा है मेको तो बहुत फायदा हुआ जहाँ मै जॉब करता हु waha mera work flow sabhi se jyda fast ho gai है आज

  • @sushilkumar-rf4vd
    @sushilkumar-rf4vd 3 года назад

    Great video sir ji

  • @excel1173
    @excel1173 3 года назад +2

    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 😘😘😘 ❤️❤️❤️

  • @darshitchavda8264
    @darshitchavda8264 3 года назад +1

    Awesome sirjee......

  • @kuldeepsharma8747
    @kuldeepsharma8747 3 года назад +1

    Good job Deepak bhai..

  • @mehmoodkhalid109
    @mehmoodkhalid109 2 года назад

    Hi Deepak, thanks for a nice video , KEEP IT UP

  • @preetambharadwaj3182
    @preetambharadwaj3182 2 года назад

    Deepak Sir, Bahut Accha aur Knowledgeable video hai ye, But Month/Day/Year Change krna aur sunday lock krne ka matlab kya hua jab month ka data hi lock nhi reh raha, aap january me jo daale hai, wahi data month change krte hi agle me aa jata hai,

  • @anupsharma4303
    @anupsharma4303 3 года назад

    Wow! it's vedio magnificent for us 👍👍

  • @muhammadtahiramin4740
    @muhammadtahiramin4740 2 года назад +1

    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 😊

  • @AMAZ32
    @AMAZ32 3 года назад

    I m from Pakistani punjab
    So nice working for students
    May u live long

  • @krishanknhaiya12
    @krishanknhaiya12 3 года назад

    this trick is really good for me

  • @UATECHYGRAPHICS
    @UATECHYGRAPHICS 3 года назад +2

    Amazing brother
    You deserve more success

  • @justforyou4220
    @justforyou4220 3 года назад

    Very nice sir. 👍

  • @rahilgamingzone10
    @rahilgamingzone10 2 года назад +1

    Daily wages ke liye A aur P ke saath OT aur Half day per video banao pls.

  • @mrcmdnabeel
    @mrcmdnabeel 3 года назад

    Fantastic bro thanks

  • @vijayikale9366
    @vijayikale9366 2 года назад

    Thank you Sir.You helped me to upgrade my work style

  • @anilshivpujijath800
    @anilshivpujijath800 2 года назад +1

    खूप छान,,,

  • @chyarmennanda
    @chyarmennanda 3 года назад

    Superb sir 🤟🤟🤟

  • @siddheshgagangras7558
    @siddheshgagangras7558 3 года назад

    Ek number bhava

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

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

    Very good sir 👍

  • @bvenkatesh8708
    @bvenkatesh8708 3 года назад +1

    Dear sir thanks for this information...
    Nd I want same information vertical way is it possible plz advise

  • @sadafamjad7621
    @sadafamjad7621 3 года назад +1

    very goog work sir well done......actully sir ak cheez ki smj nai aa rhi jb hm ak sheet py kaam krny k bad month change krty hain to Attendance sheet wahi rhti hai presence or absence change krny pr pichly month k addandance save nai hoti kindly ye cheec smja dain

  • @NileshSuthar-bf5nx
    @NileshSuthar-bf5nx 3 года назад

    Sir khy app accounting software type journal ledger trial balance and balance sheet vale koi sheet bana sakte ho khy jisme apn sale purchase karke fir last me sub automatically balance sheet and profit and loss statement ban jaye just like jo chize ek software karsakta he accounting ka ......

  • @totalgamings.g2662
    @totalgamings.g2662 2 года назад

    Thanks for vidio
    Thanks sir
    Ase hi Excel document kora debe

  • @mln-mal
    @mln-mal 3 года назад

    I like your video, very useful..

  • @manaspalei8925
    @manaspalei8925 2 года назад

    Thank you so much sir 💕😊

  • @ragivdutta09
    @ragivdutta09 3 года назад

    Good job...quick and easy way...appreciate it and do keep up the good work

  • @chandankumarpanda9371
    @chandankumarpanda9371 3 года назад +1

    Thanku sir for this expensive class

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

    Wonderful sir

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

  • @jskcomputergyan2623
    @jskcomputergyan2623 2 года назад +1

    nice video sir

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

    Thank you sir!!

  • @umeshchandarana8415
    @umeshchandarana8415 3 года назад +1

    Best.

  • @makkimax5834
    @makkimax5834 3 года назад +1

    Very Nice Dear.. lekin agr Sat and Sun ko lock karna ho to 2 columns pr kesy formula lagega?

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

    I love you sir

  • @iproudtobeanindian5758
    @iproudtobeanindian5758 2 года назад

    After fill the sheet if change the month then sheet is already showing last month work attendance. How to showing blank new month sheet. Please reply my comment. Thanks you u are great 👍

  • @NMPSONGS
    @NMPSONGS 3 года назад +1

    Very useful tutorial.
    Thank you so much.

  • @RahulKumar-ly6ly
    @RahulKumar-ly6ly 3 года назад +1

    Thanks a lot sir

  • @trounkhalroma610
    @trounkhalroma610 3 года назад +1

    Good job

  • @Pixindesign
    @Pixindesign 3 года назад

    Aap to awesome ho

  • @im_chocco
    @im_chocco 2 года назад

    Great effort 👌

  • @hemrajgurjar7472
    @hemrajgurjar7472 3 года назад +2

    Great knowledge sir. Really useful content

  • @galaxyeventsproductionsrin9838
    @galaxyeventsproductionsrin9838 3 года назад

    Owsam video bhai

  • @sandeepsrivastav27
    @sandeepsrivastav27 3 года назад

    Very nice 👍

  • @avadhutgadekar7436
    @avadhutgadekar7436 2 года назад

    Deepak ji time in out format me overtime ke sath ek bana dejiye.... Maine banaya hai thoda error hai.. i required in out and over time as per punching record... Thank you

  • @rajeshmeghwanshi3893
    @rajeshmeghwanshi3893 3 года назад +1

    धन्यवाद दीपक, मैं छात्रों की उपस्थिति के लिए इस प्रारूप का उपयोग कर रहा हूँ। परन्तु मुझे एक समस्या है, जब हम अगले महीने आगे बढ़ते हैं, तो पिछले महीने उपस्थिति हुबहू उपलब्ध रहती है, इसलिए कृपया मुझे स्पष्ट करें।

  • @anisulhoquechowdhury7873
    @anisulhoquechowdhury7873 3 года назад +2

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

  • @satishcomputersportsedu.9440
    @satishcomputersportsedu.9440 3 года назад +1

    Mind blowing sir

  • @syedmazharhussainshah5268
    @syedmazharhussainshah5268 2 года назад +1

    Good Job

  • @paighamofficial-0
    @paighamofficial-0 3 года назад +1

    Thank you for the polite request to put a project link in all your videos

  • @TheKing-yd2st
    @TheKing-yd2st 3 года назад +3

    Very good work. When I followed your instructions I could not do only one thing. After date insertion, minimised space, 'from' to 'date' portion become blurred. If I make that clear, space of date increases. Please tell me what to do?

  • @srijanaadhikari3527
    @srijanaadhikari3527 3 года назад +1

    thank you so much from nepal🙏

  • @Pritambhatt17
    @Pritambhatt17 2 года назад

    Well explained