How To Make Attendance Sheet With Salary In Ms Excel || How to Make Attendance Sheet in Excel Hindi

Поділитися
Вставка
  • Опубліковано 2 лис 2019
  • attendance sheet kaise banaye ? Doston is video mai maine banayi hai ak aisi attendance sheet jo fully automatic hai or 12 months ki attendance aap aasani se maintain kae sakte ho isme. or is attendance register mai salary calculation bhi apko sath mai milne vali hai. umeed karta hun yeh video aap sabke 2023 me bahut kaam aayega dosto.
    How To Create Fully Automatic Attendance Sheet with Salary Sheet in MS Excel in Hindi. learn how we can easily Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi. Creating fully automated attendance sheet with salary for 12 months [ complete year ]. #attendance_sheet #ms_excel #salary_sheet
    New Date to Date Attendance Sheet video : • How To Maintain Attend...
    Plz Also Subscribe My New Channel DEEPAK TECHWORLD : / @deepaktechworld
    =MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,255)
    Download This Attendance Sheet : deepakeduworld.com/attendance...
    1. How to Maintain Attendance Sheet in MS excel in Hindi | How to Make Attendance Sheet In Excel • How to Maintain Attend...
    2. Create Fantastic Fully Automated 👌Attendance Sheet in Excel | Hindi • 😮 Create Fantastic Ful...
    3. COUNTIF formula in excel In HINDI - Super Easy Tutorial • COUNTIF formula in exc...
    4. IF FORMULA • IF Logical Function in...
    thanks for watching deepak eduworld. i hope you like the video and subscribe the channel.
    have a nice day my friends
    Playlists:
    Advanced Excel : ► goo.gl/A6LdZA
    Advanced Excel Formulas : ► goo.gl/bbHYu2
    Excel Tips & Tricks : ► goo.gl/wAj1jh
    MS Word Tutorial : ► goo.gl/B4TeSA
    HTML5 and CSS3 : ► goo.gl/2PFgs8
    Computer Technology : ► goo.gl/paZmpn
    Automatic Invoices in excel : ► goo.gl/dFhg54
    Subscribe DEEPAK EDUWORLD : ► / deepakeduworld
    Follow On Instagram : ► / deepakeduworld
    Facebook Page : ► / deepakeduworld
    Facebook Group : ► / deepakeduworld

КОМЕНТАРІ • 10 тис.

  • @rupam6746
    @rupam6746 4 роки тому +59

    =MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,255), kam nahi kar raha, value aa raha us jagah pe

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

    But why absent days remove nai

  • @knowledgekey..
    @knowledgekey.. 2 роки тому +1

    Hm apna excel file open kar rahe hain to pahle (Hindi.xlam could not be found) dikha raha hai kya karen, plz help me sir.

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

    Please Zoom.........

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

    Or ye kis version m kiya h apne

  • @anjudhaman8261
    @anjudhaman8261 2 роки тому +1

    Humhare yaha per present,absent,el,cl, training, half day add hone ke bad total paid days h...ab usme mujhe 4 late ek din deduction ke bad total paid days kiytana hina cahiye wo formula nhi aaraha h

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

    Windows 7 me hoga tha easily but windows 10 me VALUE show kar raha he

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

    Home hyperlink didn't work in excel 2007

  • @rashmidwivedi9383
    @rashmidwivedi9383 14 днів тому +1

    Kya koi bata sakta hai kisi kaa if function work kr raha hi bcz mujhe koi code nhi found ho raha ise apply krne ke baad

  • @rajendrakumarrajbhar

    Is per Bhejiye sir attendance sheet

  • @ammarsohail376
    @ammarsohail376 3 роки тому +12

    Superb efforts.. Would be more wonderful if linked with the detailed salary sheet and salary slip as well..!!

  • @pappukumaryadav6344
    @pappukumaryadav6344 2 роки тому +4

    Deepak bhaiya ji, Many thanks. Excellent presentation with very clear guidance. I learnt and enjoyed. Keep up the good work.

  • @sureshram6907

    I was watching many videos on UA-cam including your videos sir.I was planning and doing practice nearly daily on my laptop to make use of the automated students attendance sheet in my Government Primary School Randhawa and Sassi Brahmna of Patiala Punjab.

  • @vijayaenterprises4118
    @vijayaenterprises4118 2 роки тому +1

    HI SIR, Many thanks. Excellent presentation with very clear guidance. I learnt and enjoyed. Keep up the good work.

  • @DeepakEduWorld
    @DeepakEduWorld  4 роки тому +343

    Attendance Sheet Download Link

  • @muhammadyasin2174
    @muhammadyasin2174 3 роки тому +4

    what a grate man first time I like and comment you.

  • @IrshadAhmad-zm8ug
    @IrshadAhmad-zm8ug 2 роки тому +2

    Hi deepak, you’re simply super duper..I applied your formula in my work and really it’s very practical and helpful. Thank you very much.

  • @vedantkumarminecraftpro8226
    @vedantkumarminecraftpro8226 3 роки тому +1

    well described. Thank you so much!

  • @himanhus.unplugged3043
    @himanhus.unplugged3043 4 роки тому +5

    Hi Deepak,

  • @mmrameshkumar2279
    @mmrameshkumar2279 2 роки тому +6

    Hi Deepak, This is almost the same sheet just like your previous videos.Only addition you have given is hyperlinks,which actually is not required & make no sense as all the months are just a click of tabs. Help us understand the automatic sheet with the help of list down using data validation of months, which changes the date and week days automatically and we don't get the first sheet which is saved initially& reflects the same under all months when we change the month, instead when use list down option of months and update data (P or L) get saved for that particular month only and data shouldn't reflect the same in other months until we key in manually. This type of sheet would be magnificent instead of using multiple tabs and keeping the sheet large.