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

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

=MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,255)

thanks for watching deepak eduworld. i hope you like the video and subscribe the channel.
have a nice day my friends

Playlists:

[DeepakEduWorld]

*dosto btaiye ye attendance sheet apko kaisi lagi ? aap is amazing 👌 video ko end tak jarur dekhiye.. bahut kuch seekhne ko milega is video main aapko 👍. full advanced lavel*

[lokkathayen]

सर आपका समझाने का तरीका सरल और परफेक्ट है आपके द्वारा दी गई जानकारी बहुत जल्दी समझ आती है सर ये फ़ाइल सेंड कर दे आपकी अति कृपा होगी

[pappukumaryadav]

Deepak bhaiya ji, Many thanks. Excellent presentation with very clear guidance. I learnt and enjoyed. Keep up the good work.
I am from Patna Bihar. Outstanding job.I am speechless...

[sureshram]

I was watching many videos on YouTube 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.
Now I think it's the best automated way to help in studies and in totalling of students attendance reports which are often time consuming. Thanks a lot Mr Deepak sir ji.

[muhammadyasin]

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

[ammarsohail]

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

[md.shamimhossai]

I am from Bangladesh. Outstanding job!!! I am speechless!!😁

[ahmeatpoint]

Hi Deepak, your explanation very good. there is one problem in the salary calculation, if a person is working 1 day also salary is being calculated 1+all the Sundays of the month.

[himanhus.unplugged]

Hi Deepak,

Thanks for sharing it, as I want to learn Advance Excel. Could you please help me on this.

[deepaksarangi]

That's good for me I am created attadance sheet for our organisation, thank you sir

[mmrameshkumar]

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.
I would like to appreciate the excellent knowledge you have on excel and the way you teach/explain. 🙏

[shyammaheshwari]

Hi, I liked ur excel tutorial but wanted to know logic about using the mid cell formula which you have used

[jiteshkadivar]

What if I have only 1 presence day, then formula shows " number of payable days 5 and also shows incorrect inhand salary." I think we still need to add more criteria to calculate number of payable days....by the way it is good presentation...thanks

[moodswinger]

dear deepak very good work and best part is that your giving it free

[syedshah]

Respected Sir,
you always teach us with your great knowledge .i shell be very thankful to you always.
i have request to you kindly include attendance report with this attendance sheet, mean in year attendance summary, present days, absent days, leave etc.
Best Regards
Muboo

[pankajsinha]

SIR YOU ARE BRILLIANT KINDLY SEND ME THIS SHEET

[kanthigp]

Sir I have low budget mobile I can't see formula can you plz give formula in description. Spl that total payable days

[sureshram]

I am also in a situation to use these new techniques in MDM reporting, Results and so on. Hope you will guide us as it is in future too. Thanks 🙏🙏 again Sir ji.

[omkaraimpex]

This video is really very useful to us.
Thank you so much for your great effort.
Please send me the link to download it.

[salmanalamodi]

Sir ji I want daily expenses sheet monthly ya yearly