How To Make Attendance Sheet With Salary In Ms Excel || How to Make Attendance Sheet in Excel Hindi
Vložit
- čas přidán 2. 11. 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
Attendance Sheet Download Link deepakeduworld.com/attendance-sheet-in-excel/
*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*
Download This Attendance Templete : deepakeduworld.com/attendance-sheet-in-excel/
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* czcams.com/video/Xkq0-xXAj48/video.html
*Complete Powerpoint Tutorial :* czcams.com/video/OekrBhNybP0/video.html
*Xlookup Complete Tutorial :* czcams.com/video/0LjfRVD7srU/video.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* czcams.com/video/C9y53fedo04/video.html
Please send this file to me at sumer.singh89@gmail.com
Thanks in advance
Please send me the sheet
neerajkumarsingh090@gmail.com
Bhai please send this file. juttn809@gmail.com
Please send a file at runkund@gmail.com
👍Great Sir for amazing video 👌. Kindly provided me the file at meenakshimaggo85@gmail.com
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...
I was watching many videos on CZcams 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.
I have made successfully the fully automated students' attendance sheet sir ji, Thanks 🙏🙏 again.
HI SIR, Many thanks. Excellent presentation with very clear guidance. I learnt and enjoyed. Keep up the good work.
what a grate man first time I like and comment you.
Superb efforts.. Would be more wonderful if linked with the detailed salary sheet and salary slip as well..!!
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.
dear deepak very good work and best part is that your giving it free
I am from Bangladesh. Outstanding job!!! I am speechless!!😁
India ki talent hai bhai
.
Attendance
I'm also from Bangladesh, Our office rules is date start from 26 January 2022 to 25 January 2022 like this, So how to do this, I think I have to add different formulas. Anyone expert here i want to your attention🙏🙏🙏
Dear Sir, Our office rules is date start from 26 January 2022 to 25 January 2022 like this, So how to do this, I think I have to add different formulas. Anyone expert here i want to your attention🙏🙏🙏
Hi Deepak,
Thanks for sharing it, as I want to learn Advance Excel. Could you please help me on this.
Hi Deepak bhaiya ji, Many thanks. Excellent presentation with very clear guidance. I learnt and enjoyed. Keep up the good work.
Thanks Deepak. Just created the workbook with you on teh video. Great.
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. 🙏
Sir pls share me
सर आपका समझाने का तरीका सरल और परफेक्ट है आपके द्वारा दी गई जानकारी बहुत जल्दी समझ आती है सर ये फ़ाइल सेंड कर दे आपकी अति कृपा होगी
Great work, thanks for your support. We can’t express in words, god bless you
well described. Thank you so much!
Good sir ji
majidhameed90@gmail.com
Attandance sheet required
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
sir please send me links
dear syed are you make this sheet your self if you make kindly guide meplease
Plz sir link me🙏
Excellent work bhai ji.
Bahut hi बेहतरीन vedio थी
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.
Sir ji, your explanation very helpful and problem solving how to calculate in month for half days in excel sheets
SIR YOU ARE BRILLIANT KINDLY SEND ME THIS SHEET
Bhai send me also yr victor_benhur@yahoo.co.in
Zabardast Deepak bhai ❤️
Bahut badhiya samjhaya sir maza a gya
This video is really very useful to us.
Thank you so much for your great effort.
Please send me the link to download it.
ghanshyamkumar37667@gmail.com
Gg
Fygffg
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
It's really very helpful for me....Thank you sir :)
Heads off to you,🙏😍 whàt an explanation and all formulas were mind blowing 🤩
Hi, I liked ur excel tutorial but wanted to know logic about using the mid cell formula which you have used
Nilparmar85@gmail.com
dinoneena@gmail.com
What i do ?
Keya karna hoga
You are great as usual
Superb tutorial. Thank you so much
Sir ji I want daily expenses sheet monthly ya yearly
Hii, i like it , but i want to know that agar isme koi unpaid leave ho to usko kaise manage krenge or paid leaves ko bhi ?? Plz reply with video
By countif and manually
thank you sir, i made it, and the experience was awesome.
Superb sir... God bless u
Sir I have low budget mobile I can't see formula can you plz give formula in description. Spl that total payable days
Will you please difine this formula " =mid(cell)"filename",B2,)find("]",cell("filename",b2))&" "&2019
Wait for video 😊
@@DeepakEduWorld sir mera bhi yahi puchna hai.
Can you share your contact number
My WhatsApp & Calling number is 9955334078
Sir plz share u r suggestions regarding formula=mid
sohittailor94@gmail.com
Excellent work by Deepak sir
great effort by an expert
=MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,255) not use formula
Not use formula
Sir ye formula use nhi ho raha me 2020 ka sheet prepare kr rahi hu
@@DhinchakPihu first save ur workbook
@@DhinchakPihu hello,were you able to sort the formula "MID"
just save the excel file and see , it will definitely work
=MID(CELL("filename",B2),FIND("]",CELL("filename",B2))+1,255), kam nahi kar raha, value aa raha us jagah pe
Hlo
It works. but not by copying from the link. you have to put manually.
@@bkan5840 after that I had tried n succeeded also
Yes it does not work
It's not working sir.
Great information 😊😊
I'm very impressed with your videos...
Very useful information video. Thanks for your valuable support and update sir.
Thanks nice video with detail step by step.
Such a awesome tutor you are ,
Wawo so informative,thank you sir alot
Hi Deepak, great video tutorial.
Excellent efforts
love you dear
Superb sir, I really like it.. 🎉 🎉 Thank you 🙏 🙏
Well explained... Thanks alot ,🙏🙏🙏
That's good for me I am created attadance sheet for our organisation, thank you sir
Really good work .. very helpful
Thanku so much sir.🌼🙏. Aj hi bnai Maine ye sheet.. New join kiya h Maine ek law firm me❤
Congratulations 🎉 and good luck 👍
Its very nice and very Use full
Mind-blowing video.......Sir
u are great .... amazingg
Thank you .. super..
Thank you so much sir 💚its really very helpful😇
Very useful. Thanks a lot
Excellent job dear. Beat of luck ✊
Thanku soo much it's really useful ❤️🙏🙏🙏🙏🙏🙏😘
Great video on automatic attendance system using excel sheet. It would be very grateful if you share the link with the detail salary sheet format as well.
Very good friend i am very impressed to you, i was very excited for this video
Sir Your explanation skill amazing and your video is most helpful for us
Thank you very much Sor
I like it superb.
good...very informative and useful video
Greatjob 👍 thanks a lot
This content help me very much. Thank you very much.
Excellent video!
Nice Sir, Thank You..
Deepak bhai, thank you 👍
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.
Very grateful and knowledgeable videos thank you so much
Excellent job done from you sir
I am your biggest follower forever 🥰🥰😍💯❤
GREAT WORK
THANK YOU SIR
Awesome dear very nice work done love from Pakistan
I have seen so many videos really appreciate
Bahat acha dada❤
informative video... thanks
Superb 👌
Mast Laga sir Ji
Excellent Work
Sir you are great I'm watching your every video and I'm from Pakistan.
Graet depak bhi
Bhai yaar aapane to Gajab Kar Diya
Awesome 👍
EXCELLENT ZABARDUST
thank you give us valuable information regarding attendance sheet
Excellent Sir 👍🙏
Very good video it is very helpful thankuu soo much sir
Thank you so much sir for excellence 🙂explanation
Very good work sir
excellent sir..
Thanks for solutions and trics ❤️🙏
So wandrful ♥️♥️
Every video your larnable
you are also genius
Very well explained
Really appreciate it