😮 Create Fantastic Fully Automated 👌Attendance Sheet in Excel | Hindi

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 พ.ย. 2024

ความคิดเห็น •

  • @mmrameshkumar2279
    @mmrameshkumar2279 3 ปีที่แล้ว +8

    Hi Deepak, Seems there is a flaw with the automatic sheet. Pls assist with the query below,
    1) If data is updated in the sheet (say P or L) of any month initially, the same would reflect in other months as well when we list down the months/change months.
    2) How can we show empty columns for the coming month's when changed, so that attendance can be tracked accordingly.
    Hope to see your response soon. Thank You!

    • @mmrameshkumar2279
      @mmrameshkumar2279 2 ปีที่แล้ว +1

      @Gauri Dhame No Sir

    • @dipakbhowmik2339
      @dipakbhowmik2339 2 ปีที่แล้ว

      Same here. Did you find the solution

    • @Learn_With_Fun.....
      @Learn_With_Fun..... 2 ปีที่แล้ว

      I am also want know how to solve it please Deepak sir give us solution

    • @masterjitoo
      @masterjitoo 2 ปีที่แล้ว

      Learn payroll from us

    • @harisp338
      @harisp338 ปีที่แล้ว

      Yes sir .even I have the same issue

  • @Shivaniverma24317
    @Shivaniverma24317 5 ปีที่แล้ว +2

    Very nice video.... very useful thank you

  • @prachandrakayastha4556
    @prachandrakayastha4556 5 ปีที่แล้ว +3

    Thank you very much, sir, for the most important tutorial you teach us. "Respect from Nepal"

  • @sunitawelekar4416
    @sunitawelekar4416 4 ปีที่แล้ว +1

    Sir namaste,
    आप बहुत अच्छे से बताते है, आसानी से समझ मे आ जाता है.
    एक प्रॉब्लम हो रही है, मैने Aug ki attendance शीट बनाई, जब इसमे month चेंज करते है तो aug का फिल किया हुआ डाटा sep मे भी आ जाता है. इसको कैसे ओके करें.pls बताये...🙏

    • @DeepakEduWorld
      @DeepakEduWorld  4 ปีที่แล้ว

      New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍👍👍

  • @rajendrakumarsinwar6719
    @rajendrakumarsinwar6719 3 ปีที่แล้ว +4

    Sir ak asi excel sheet banao jisme time In time out fir outomatic over time calculate hojaye.

  • @sudarmadimadi7826
    @sudarmadimadi7826 3 ปีที่แล้ว

    Thanks alot for education share for the worlds, GOD BLESS YOU

  • @infomipw9633
    @infomipw9633 6 ปีที่แล้ว +4

    Friend, Excellent way to transfer knowledge. learnt a lot, thanks

  • @rajeshchoudhary2520
    @rajeshchoudhary2520 5 ปีที่แล้ว +1

    Rajesh, Deepak sir ji aapne video me attendance sheet banaanaa sikhaaye vo bahut badhiya bataaye, aur aage me ye kahna chaha raha hu ki mujhe ase hi data entry excel ki job bataiye kahi bhi, aaj me excel me full expected hu lekin kahi job mil hi nahi pa rahi hai, to aap jaroor-2 data entry ki job bataiye, aur video achha hai

  • @fitnesstools123
    @fitnesstools123 6 ปีที่แล้ว +10

    NICE BRO I have one Query ki agar hum month change krte hai kya pichla data jo ki hmne pichle month attendance bhari this vo save rhega isme. ki har baar hme new sheet banaani padedi. matlab ye hai ki hmne is sheet ko bna liya hia attendance har mahina ki lagaani hoti hai agar baad me hame maan lo may ki attendance dekhni hai aur hum isi sheet se may month ko select krte hai kya hum may ki attendance jo fill ki this dekh payenge isme ki nahi

    • @chandankumar-jk5fg
      @chandankumar-jk5fg 6 ปีที่แล้ว +3

      KARAN SINGH .. it is most important question which needs to be answered. Hope Deepak ji will answer it

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว +5

      Nice question.. Please wait. I will publish another video shortly on this topic.. Regarding your very nic query...

    • @jikcomputers4889
      @jikcomputers4889 6 ปีที่แล้ว +2

      sir make a video early about this problem . We are waiting.........

    • @suvendupradhan5458
      @suvendupradhan5458 6 ปีที่แล้ว

      KARAN SINGH deepak sir same problem . The data which i prepared for may that is also coming on the month June. Pls tell us how to solve this.

    • @RailLoVeRSaHaNi
      @RailLoVeRSaHaNi 6 ปีที่แล้ว

      Deepak EduWorld when u publish new video on this

  • @bibinazia9444
    @bibinazia9444 4 ปีที่แล้ว

    Assalam u Alaikum sir. I created cash book, Day book and now I am working on attendance sheet. thank u sir from Pakistan

    • @DeepakEduWorld
      @DeepakEduWorld  4 ปีที่แล้ว +1

      New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍 Here is one More NEW Interesting video on ATTENDANCE SHEET th-cam.com/video/l6ORdfIENDY/w-d-xo.html

    • @bibinazia9444
      @bibinazia9444 4 ปีที่แล้ว

      @@DeepakEduWorld inshaa Allah I will watch it.

  • @Sachinchauhan021
    @Sachinchauhan021 4 ปีที่แล้ว +5

    Sir this is nice but when i change month then presence and absence data will not change if you can give trick so it will work otherwise this sheet is totally waste and i also waste my time 🙄

    • @dharmendrarawat2524
      @dharmendrarawat2524 4 ปีที่แล้ว +1

      Even I am also facing the same issue..do you know how to fix it?

    • @manishrahulninejun
      @manishrahulninejun 4 ปีที่แล้ว

      Hi Sir, I am also facing the same issue... Could you please provide the solution..
      I want to use this file itself

    • @Munadas93
      @Munadas93 3 ปีที่แล้ว

      Yes i am also facing same issue pls guide us asap .it will help me alot

  • @Akshaykajar
    @Akshaykajar 4 ปีที่แล้ว +1

    Thank you brother wish you all the best

  • @muhammadtalal4085
    @muhammadtalal4085 5 ปีที่แล้ว +4

    Bhai ap jab month change kar rahay hy tou sunday walay column may bhi Absent likha a raha hy is ka solution batai

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      th-cam.com/video/0Bdc1XftAwc/w-d-xo.html

  • @sandipkhanapure455
    @sandipkhanapure455 6 ปีที่แล้ว +8

    सर, हमने आपका अटेंडन्स शीट वाला व्हिडीओ देखा व्हिडिओ काफी अच्छा था । लेकिन हमे कुछ समस्या थी । अगर कर्मचारीयो की विकली ऑफ अलग अलग है तो उसको कैसे हायले किया जा सकता है ।

    • @shubhamwani3190
      @shubhamwani3190 5 ปีที่แล้ว

      play.google.com/store/apps/details?id=comm.example.takemyroll_teacher.takemyroll_ssw
      Sir, please try this app
      It will help you do all this with just few clicks.

    • @smaranamatrakeshava3762
      @smaranamatrakeshava3762 5 ปีที่แล้ว

      Please mention WK off with a new colour as they assigned a separate colour for leave & absent , then search as WK off in table you will find your results

  • @ferozmd7942
    @ferozmd7942 5 ปีที่แล้ว +1

    Very nice sir, very very useful to us, thank u very much

  • @pritam4you
    @pritam4you 5 ปีที่แล้ว +4

    how to create April 2019 to march 2020

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      th-cam.com/video/0Bdc1XftAwc/w-d-xo.html

  • @ghurahuprasadyadav3798
    @ghurahuprasadyadav3798 5 ปีที่แล้ว +1

    मेरी बहुत बडी समस्या का हल बताया है ।आपने सर जी इसके लिये दिल से आभार करते है ।

  • @VedPrakash-cb9te
    @VedPrakash-cb9te 5 ปีที่แล้ว +3

    Thanks sir but isme hamne January k month m presents fill ki to bahi presents next month m bhi fill rahati h. Aisa kyo kuchh upay sir...

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      Next part of this sheet is coming shortly

    • @lokesh686
      @lokesh686 5 ปีที่แล้ว

      @@DeepakEduWorld i am facing same problem..

    • @rishabhjain9160
      @rishabhjain9160 5 ปีที่แล้ว

      Yes same problem

    • @vikaskatiyar007
      @vikaskatiyar007 5 ปีที่แล้ว

      I have resolve this issue

    • @poojachettri2200
      @poojachettri2200 5 ปีที่แล้ว

      @@vikaskatiyar007 will provide us on the same

  • @savitripal873
    @savitripal873 5 ปีที่แล้ว +1

    Thaknyou deepak sir i just downloaded your vedio and completed too I learnt much about excel with this one vedio thanks alot

  • @mathewsenan8167
    @mathewsenan8167 5 ปีที่แล้ว +3

    how to extract only leave dates from this excel sheet using with formula.

  • @nextstepsknowledge2438
    @nextstepsknowledge2438 4 ปีที่แล้ว

    I have made from wacth your video. Working.

  • @sureshparmar1855
    @sureshparmar1855 5 ปีที่แล้ว +4

    LOWER SHEET FOR INDICATING "P" "A" NOT CHANGING MONTHWISE, ONLY SAT & SUN COLUMN IS HIGHLIGHED WITH COLOUR

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      I ll publish next part of this sheet as soon as possible

    • @shashikantbhide9185
      @shashikantbhide9185 5 ปีที่แล้ว

      @@DeepakEduWorld YOU ARE PUBLISH THIS PROBLEM?

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      th-cam.com/video/0Bdc1XftAwc/w-d-xo.html

    • @manishrahulninejun
      @manishrahulninejun 4 ปีที่แล้ว

      Hi Sir I am also facing same issue... I wanted to fix the problem in same file... Can that be done

    • @NaveenKumar-kd4ce
      @NaveenKumar-kd4ce 3 ปีที่แล้ว

      @@DeepakEduWorld सर इस प्रॉब्लम का सोल्यूशन बताओ plz

  • @akansha123.4
    @akansha123.4 3 ปีที่แล้ว +1

    U r so intelligent.... thank you for sharing the video

  • @setuanubhav8971
    @setuanubhav8971 6 ปีที่แล้ว +10

    सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में दिखाई देती है

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว +2

      Please wait.. I will publish video as soon as possible on this topic

    • @neerajchaudhary9860
      @neerajchaudhary9860 6 ปีที่แล้ว

      Sir plz give solution as soon as b. coz its very need full

    • @neerajchaudhary9860
      @neerajchaudhary9860 6 ปีที่แล้ว

      Sir plz solve the query as soon as

    • @40keshav
      @40keshav 6 ปีที่แล้ว

      Deepakji Namaste, I am facing the same problem. will be greatful if you can solve this major issue. I am also waiting for this query.

    • @ashwini_makeup_artist_07
      @ashwini_makeup_artist_07 6 ปีที่แล้ว +1

      @@DeepakEduWorld ak hi month ka data fill krte hai to sabhi me vahi fill hota sir solution to batao hame

  • @freedomnppshent.7973
    @freedomnppshent.7973 5 ปีที่แล้ว +1

    Nice job man. Learn alot from your videos. es format me jab aik month ki entries kar lyty hain phir jb next month ko select karty hain tu wohi entries dobara ajati hain. agar entries ko delete kar dain tu previous month sy be khatam ho jati hain. es ka koi hal bataye plz.

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว +1

      I ll publish next part of this video shortly

    • @freedomnppshent.7973
      @freedomnppshent.7973 5 ปีที่แล้ว

      @@DeepakEduWorld Thanks and will be waiting for the new video.

  • @Ravikumar-rd7cv
    @Ravikumar-rd7cv 5 ปีที่แล้ว +3

    Sir...when you change the month, the days and day is changing, but the details of absent and present is not changing .....what ever we enter in one month the same is being displayed for all the months?? Ravi kumar

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      th-cam.com/video/0Bdc1XftAwc/w-d-xo.html

  • @muhammadkamran8555
    @muhammadkamran8555 2 ปีที่แล้ว

    great bro, great bro,.... bro ap aik attandence sheet bna kr dikhao k jb staff apni attandence khud lagay to us ka arrival time khud ba khud lag jay k ya staff mamber is time pr offuce pohancha ha. thanks bro

  • @WipegodgamingYT
    @WipegodgamingYT 5 ปีที่แล้ว +4

    Video toh pura banao yaar absent and present toh vaise hi reh jate hain fuddu wali harkatein mat karo yaar part 2 abhi tqk banaya ni

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      th-cam.com/video/0Bdc1XftAwc/w-d-xo.html

  • @abhishekchauhan2130
    @abhishekchauhan2130 4 ปีที่แล้ว +1

    bhai thank u itna deep mein samjhane k liye

  • @DeepakEduWorld
    @DeepakEduWorld  5 ปีที่แล้ว +9

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    *Show Me ♥ By Like Share & Comment*
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

    • @AzharUddin-vg5ee
      @AzharUddin-vg5ee 5 ปีที่แล้ว +1

      Sir ap ni jo attendance sheet bena he ose m ek month ki results he next month ki results kese deki vo bate sir

    • @bikashrajak9480
      @bikashrajak9480 5 ปีที่แล้ว

      Hi Deepak, I am also facing the same issue, I have prepared the attendance sheet and I understand the procedure. But when I have filled the attendance for January, some of the data from January will get reflect to the other month. When I will change the month from January to other.
      Please help us

    • @rishabhjain9160
      @rishabhjain9160 5 ปีที่แล้ว

      And sir is there any way....which can inform us if we wrongly type any other word in the sheet except "P" and "A" ???

    • @NatureAnimallover-786
      @NatureAnimallover-786 5 ปีที่แล้ว

      Im just loving yur videos, what if I need to highlight only Sunday ,then how can I do that., because you highlight sat,Sunday for weekly holidays but I need only sunday.can u help me please how to drive this formula..

    • @anwarhossain9648
      @anwarhossain9648 5 ปีที่แล้ว

      sir, my keyboard f4 buttom if i clic dont lock my cell .how can i lock my cell plz im watting for your replay.

  • @nmjkumbla4579
    @nmjkumbla4579 5 ปีที่แล้ว +1

    Very good and easy method of using excel formulas. Thank you Mr. Deepak.

  • @bidyadharrabha4033
    @bidyadharrabha4033 5 ปีที่แล้ว +4

    Isko bananeka koi value hi nahi he kyuki date change karnese jo likha vo change hi nahi hota he to itna mehenat karne ka kya faida

  • @poojakarn2771
    @poojakarn2771 2 ปีที่แล้ว +1

    Thank you so much Sir , how much effort you do to teach us

  • @bilalshoukat7322
    @bilalshoukat7322 6 ปีที่แล้ว +1

    Your video is really valuable.
    Please further guide me how to automatically post the journal entry to relevant ledger accounts just like accounting softwares. I am managing my accounts in excel i have to post the entry indually which take a lot of time

  • @DeepakEduWorld
    @DeepakEduWorld  5 ปีที่แล้ว +5

    *New Video of Fully Advanced Attendance Sheet for 12 months* 👉 th-cam.com/video/0Bdc1XftAwc/w-d-xo.html Must Watch it 👌
    दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
    *My New Channel :* bit.ly/3qFrbl5
    *Complete Microsoft Word Tutorial :* th-cam.com/video/Xkq0-xXAj48/w-d-xo.html
    *Complete Powerpoint Tutorial :* th-cam.com/video/OekrBhNybP0/w-d-xo.html
    *Xlookup Complete Tutorial :* th-cam.com/video/0LjfRVD7srU/w-d-xo.html
    *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
    *Excel All Formulas :* th-cam.com/video/C9y53fedo04/w-d-xo.html
    *Office Work in Excel :* th-cam.com/video/PT8D1qQwe1k/w-d-xo.html

    • @---tz2ug
      @---tz2ug 5 ปีที่แล้ว

      Hi

    • @sushilyadav5805
      @sushilyadav5805 4 ปีที่แล้ว

      Sir g vba coading se related vdo bno koi jisme alg alg month ka data save ho

    • @jyotimishra5796
      @jyotimishra5796 4 ปีที่แล้ว

      Sir 2007 me work nahi horha

    • @arabindaghose2058
      @arabindaghose2058 4 ปีที่แล้ว

      Mr Deepak I am facing serious problem in setting the day and date and I am unable to go ahead in this video plz look to this and give me quick solution.

    • @rubyshah332
      @rubyshah332 4 ปีที่แล้ว

      Hello sir meri salary list me month by month present and absent change nhi ho rha h to kya krna pdega

  • @sunilkumar-cm2iw
    @sunilkumar-cm2iw 5 ปีที่แล้ว +1

    Thank you sir apke smjhane ka tarika bahut achha hai so agin than thank you

  • @SURYAPRAKASH-cm6xi
    @SURYAPRAKASH-cm6xi 5 ปีที่แล้ว +1

    VERY GOOD AND USEFUL VIDEO

  • @excelclassesmobileexcel893
    @excelclassesmobileexcel893 5 ปีที่แล้ว

    dipak ji aapke knowledge ka kmal hai

  • @fazalmaula4001
    @fazalmaula4001 2 ปีที่แล้ว

    ماشااللہ سر آپ بہت اچھی ویڈیوز بنا رہے ہیں
    سر پلیز آپ اس طرح کریں کہ VBA میں بھی اس طرح کی ویڈیوز بنائیں تو ہمیں VBA بھی سمجھ آ جائے گا Thanks a lot

  • @Pihus123
    @Pihus123 5 ปีที่แล้ว +1

    Nice bahut hi achhi jankari mili

  • @noormohammed8976
    @noormohammed8976 4 ปีที่แล้ว

    Thanks Deepak Bhai, Very knowledgeable video provided.. I learnt lot of things from this very video.

  • @leenaflower3709
    @leenaflower3709 4 ปีที่แล้ว

    Thank u Deepak for sharing the excellent knowledge.it was very useful for my career.

  • @AhsanKhan-sm8vn
    @AhsanKhan-sm8vn 3 ปีที่แล้ว

    mindblowing attendence sheet sir thank u so mauch

  • @Mahadev_Priest_
    @Mahadev_Priest_ 4 ปีที่แล้ว

    Thankyou sir very helpful video 👌👌👌👌♥️

  • @studentstoteachers2396
    @studentstoteachers2396 6 ปีที่แล้ว +1

    Thank your so much sir
    First time kisi ki video really like krne Ka mn kr rha hai

  • @zemtechnology4474
    @zemtechnology4474 5 ปีที่แล้ว +1

    very nice style of teaching thank you great information

  • @sarojanandpathak1033
    @sarojanandpathak1033 4 ปีที่แล้ว +1

    Your style to teach on line is fantastic. you describes each line very smartly that students want. Thanks a lot.Marvelous jobs. Keep it up.

  • @siddhkumar5580
    @siddhkumar5580 5 ปีที่แล้ว

    Sir humane aapaka attdence walk
    Vedio dekha baht achchha laga lekin kisi company ki salary sheet kaise banaye samjhane ka tarika achchha hai.

  • @muhammadiftikhar5856
    @muhammadiftikhar5856 5 ปีที่แล้ว +1

    Excellent Deepak sahib you have very well knowledge about Excel I have seen yours more video about excel my child says that uncle Deepak has fully command in formulas of Excel.
    ( Kamal ha bie)

  • @MaheshMahi-iy9rf
    @MaheshMahi-iy9rf 4 ปีที่แล้ว +1

    Super thanks u r for update this video

  • @watisthis
    @watisthis 4 ปีที่แล้ว

    I looked for many videos, This one is the best

    • @DeepakEduWorld
      @DeepakEduWorld  4 ปีที่แล้ว

      New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍👍👍

  • @moodkn
    @moodkn 5 ปีที่แล้ว +1

    Lot of Thanks Mr.Deepak very helpful Excel attendance sheet!

    • @bidyadharrabha4033
      @bidyadharrabha4033 5 ปีที่แล้ว

      Not helpful man its seems smart but actualy there is nothing valueable this is just waste of time you just try tum khud ko gali dene lagoge ek bar try karke dheko

  • @ganpatihardware5619
    @ganpatihardware5619 3 ปีที่แล้ว

    your work looking awesome sir

  • @routjadu
    @routjadu 4 ปีที่แล้ว

    Thanks for such video uploaded by you. Please make an user form to perform this attendance register which stores data in an excel sheet.

  • @assessmentseinserste450
    @assessmentseinserste450 5 ปีที่แล้ว +1

    WHEN WE CHANGE MONTH , ATTENDANCE NOT CHANGING , KINDLY LET US HOW CHANGE ATTENDANCE TOO . VERY GOOD VIDEO BEST PLACE TO LEARN EXCEL

  • @arifkhanitspecialist3792
    @arifkhanitspecialist3792 5 ปีที่แล้ว +1

    Thank u Broo Nice Teaching Style with Knowledge. Excellent Keep it up.

  • @rajatrana1037
    @rajatrana1037 4 ปีที่แล้ว

    Hello Sir,
    First of all thanks for sharing this wonderful tutorial. Maine July month ki entry fill kr di hai...pr ab jb main drop-down menu se koi aur month bhi open kr rha hu to dates aur days to change ho rhe hai but jo July month ki entries thi wo nhi ja rhi... Kya kru ki new month ke liye blank cells aa jaye.

  • @poojaVerma-hi3hh
    @poojaVerma-hi3hh 5 ปีที่แล้ว

    This video for me most useful thanks sir

  • @ravindrank5023
    @ravindrank5023 3 ปีที่แล้ว

    Superb, Wonderful, excellent and marvellous. Suppose I want to mark second saturday &third saturday instead of all Saturdays how to proceed?

  • @koushikmandal8311
    @koushikmandal8311 7 หลายเดือนก่อน

    Bahat acha deepak sir❤❤

  • @jackyjigs2498
    @jackyjigs2498 2 ปีที่แล้ว +1

    Good job..
    Can I use this for student attendance also... Or need to change some format

  • @MalkeetSingh-xk2yq
    @MalkeetSingh-xk2yq 5 ปีที่แล้ว +1

    its really good I made one, but when we change the month the date's changes but previous month data will remain in the next selected month I guess we need to use vcode so that the data for the selected month remain to save in that month and when we select the new month the page should be blank so that we could enter new data day wise, @ deepak please share a video on same .

    • @saikatshah4663
      @saikatshah4663 3 ปีที่แล้ว

      I have the same question but how to do it... Can you explain me...?

    • @koushikdey7427
      @koushikdey7427 2 ปีที่แล้ว

      I have the same prblm

  • @arshiyasiddiqui8086
    @arshiyasiddiqui8086 5 ปีที่แล้ว

    bht bht bht bht bht achi knowledge really helpful

  • @newsandvlogs9130
    @newsandvlogs9130 3 ปีที่แล้ว

    Bahut Dhanyavad, Jai Siyaram.

  • @santoshshelar0120
    @santoshshelar0120 5 ปีที่แล้ว +1

    Sir video bahut acha hai.
    Likin sir next year ka kise karege. Next year ka kise banayege

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      Next video on attendance sheet is coming shortly

  • @darshanlad5389
    @darshanlad5389 5 ปีที่แล้ว +1

    Great job Deepak.....👍🏻

  • @jaisingh9829515091
    @jaisingh9829515091 5 ปีที่แล้ว

    hello sir
    nice and important secession
    thanks

  • @chandrabhanu7626
    @chandrabhanu7626 5 ปีที่แล้ว +1

    Thank you, Very good teaching.

  • @chandanbhunia9759
    @chandanbhunia9759 4 ปีที่แล้ว +1

    Thank you very much
    The difficulty here is that the F4 is not being locked.Example
    =if(E5

    • @parvez666
      @parvez666 ปีที่แล้ว

      Ctrl+$, कीबोर्ड से करो

  • @happy___boy___7860
    @happy___boy___7860 6 ปีที่แล้ว

    वाह दीपक जी वाह

  • @AnilKumar-go7hj
    @AnilKumar-go7hj 4 ปีที่แล้ว

    Waw very nice video sir ji very good

  • @greeneyes4496
    @greeneyes4496 5 ปีที่แล้ว +1

    Really you Are very professional Thank you

  • @RajaThakur-ws1nh
    @RajaThakur-ws1nh 4 ปีที่แล้ว +1

    Very useful video

  • @sumbulshah8178
    @sumbulshah8178 6 ปีที่แล้ว +1

    Thank you, sir! You solve my big problem, but the same formula how we can apply on a vertical direction?

  • @pallavis7729
    @pallavis7729 4 ปีที่แล้ว +1

    Please make video on cbse result.txt file. How we can bifurcate subject code wise result of each student in excel

  • @avinashkhanna1322
    @avinashkhanna1322 5 ปีที่แล้ว

    Wonderful explanation and so much helpful, thanks for tutor

  • @srivatsavas1325
    @srivatsavas1325 ปีที่แล้ว +1

    Thank you so much. It helped me a lot

  • @mechwheelworkshop5364
    @mechwheelworkshop5364 4 ปีที่แล้ว +1

    IF ONE WORKER WITHDREW FOR EMERGENCY THAN WE NEED ONE MORE COLUMN AND CALCULATE THE SALARY IF YOU HAVE ANY IDEA HOW TO ADD THAT COLUMN PLEASE TELL US THANK YOU THIS IS VERY USE FULL THANKS A LOT

  • @anilnahar7058
    @anilnahar7058 5 ปีที่แล้ว +1

    thank you sir .... nice video next month ke liye new sheet create karni padti he kaya

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว

      Noooo.. I m publishing another video shortly on this topic

  • @riteshsrivastav6335
    @riteshsrivastav6335 5 ปีที่แล้ว +1

    Very nice videos sir

  • @Tum_Aur_Hum
    @Tum_Aur_Hum 4 ปีที่แล้ว

    Thank you so much sir🤗👍👍👍👍

  • @rheapeter9709
    @rheapeter9709 ปีที่แล้ว +1

    Thank you sir!!

  • @AnilKumar-il3es
    @AnilKumar-il3es 6 ปีที่แล้ว

    Deepak ji.. It's very gud
    Ab tk video me sbse best h ye
    So dear sir keep it up
    Thanku

  • @diveshagarwal4560
    @diveshagarwal4560 5 ปีที่แล้ว

    Excellent Deepak the way you explained the Attendance Sheet preparation was very nice and easy to understand. Thanks alot.

  • @sursajni
    @sursajni 5 ปีที่แล้ว +1

    very informative video, i learnt a lot from this, can you please help me to make an automated programmed for transfer and posting of employees of my establishment. plz reply soon.

    • @DeepakEduWorld
      @DeepakEduWorld  5 ปีที่แล้ว +1

      th-cam.com/video/8Hys7si1gBQ/w-d-xo.html

    • @sursajni
      @sursajni 5 ปีที่แล้ว

      Deepak EduWorld this one was also very informative and had learnt from it before wathing this video. but i want such programm where i can get employee’s data in the form of report from multiple fields and multiple sheets. plz help if you can help me.

  • @sachinjadhav3143
    @sachinjadhav3143 3 ปีที่แล้ว

    Hi.. Thank you very much for video..i want to know..how to lock the saturday and sunday using the data validation

  • @moinkhan4155
    @moinkhan4155 4 ปีที่แล้ว

    Thank you bro its helpful

  • @ramlilakametipandeypurdeor917
    @ramlilakametipandeypurdeor917 5 ปีที่แล้ว

    आपकी vedio काफी बेहतरीन है और इसके अनुसार मैंने भी एक अटेंडेंस शीट बनाया लेकिन इसमें एक बहुत बड़ी प्रॉब्लम है और प्रॉब्लम ये है कि मैंने 2019 के लिए बनाया है किंतु 2019 के बाद 2020 भी आएगा तो 2020 को कैसे मेंशन करे कि 20 की अटेंडेंस शीट के लिए फिर उतनी मेहनत करनी पड़ेगी अगर इसका कोई सलूशन हो तो जरूर बताएं और अपने ही vedio पे ही बताए कि किस फॉर्मूले में एडिट करे कि 2019 2020 हो जाये
    जैसे कि फर्स्ट डेट या लास्ट डेट में भी कुछ एडिट करने का ऑप्शन नही आ रहा है या
    D 6 सेल में भी एडिट करने का कोई ऑप्शन नही है कि उसे 2020 कर सके

  • @greeneyes4496
    @greeneyes4496 5 ปีที่แล้ว +1

    i am from Pakistan my name is Ali very nice it,s very Good video thank you

  • @mumtazkhoso5610
    @mumtazkhoso5610 5 ปีที่แล้ว +1

    Its put good effort no doubt it's most most effective but one thing more, for instance you are on month January you put so data however you move to February same data will be shown ? how to over come this issue ?

  • @MuhammadTahir-dm7mr
    @MuhammadTahir-dm7mr 5 ปีที่แล้ว +1

    best teacher

  • @zemtechnology4474
    @zemtechnology4474 5 ปีที่แล้ว +1

    this is very bioinformatic Love from Pakistan bro

  • @mohdsaeed244
    @mohdsaeed244 4 ปีที่แล้ว

    Hello depakji hi
    It is a wonderful presentation by you related to automatic salary sheet
    I do like & appreciate, no doubet it's a praiseable presentation but one thing I want to ask you please do clarify my doubet
    Who's is as under
    If we want to highlight only Sunday what we have to do ?
    Please guide this point.

  • @Kirankumardk
    @Kirankumardk 4 ปีที่แล้ว

    Deepak sir good morning gone through attendance sheet video and very happy to learn it only one doubt is when i change month sheet remain same only days and dates are changed filed fields are remain same. pl give solution whenever i changed month new sheet should appear

    • @DeepakEduWorld
      @DeepakEduWorld  4 ปีที่แล้ว

      New attendance sheet for 12 months... th-cam.com/video/0Bdc1XftAw/w-d-xo.html 👍👍👍

  • @BharathRajaNenavath
    @BharathRajaNenavath 5 ปีที่แล้ว +1

    Can you please create such videos using Apache Open Office....

  • @harshalisharma3709
    @harshalisharma3709 6 ปีที่แล้ว

    Deepak, koi esa page post karo jinme important features hi ho jo excel me use hote ho mostly.. Excel is a wide application so better to learn few important features that is generally used in excel and asked in interview. ...ek list prepare kr do jisme only important features hi ho

  • @sukhenkumar5330
    @sukhenkumar5330 3 ปีที่แล้ว

    Thank you,
    please ek video ye v banaye jisme Holiday list ko automatic show karwa sanke without VBA code me

  • @RahulGupta-uc8be
    @RahulGupta-uc8be 6 ปีที่แล้ว +1

    Thank you sir...
    Ek question hai...
    Hm y kaise kr skte hai...
    Jaise ek sheet p employee ka y attendence h aur dursri jgh employee kha s kitna salary uska history pta chl jaye uspe click krne k baad plz btaye...

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว

      Oky g.. I will publish video shortly..

    • @RahulGupta-uc8be
      @RahulGupta-uc8be 6 ปีที่แล้ว

      @@DeepakEduWorld is it possible??
      Then plz plz plz make video on this topic plz ..

  • @vishaldhiman746
    @vishaldhiman746 5 ปีที่แล้ว +1

    Thnkew very much it gives me a wonderful experience

  • @adilChai-WaLa
    @adilChai-WaLa 3 ปีที่แล้ว

    Bhai budget pe ek video banao plz
    Jisme full details ho