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 TH-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. 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.
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.
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🙏🙏🙏
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.
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. 🙏
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
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
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 :* 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
Aap apne kisi bhi videos mein na to kuchh chhupate ho na hi video kahin par skip karte ho, Mere liye Aapke naam ki har video result oriented and trustful hoti hai. Learners /Viewers ke prati aapki imandari sarahniy kary hai.
AAP excel 2021 pe sab sikha rhe hain jab ki Aaj bhi bhot log ke pas itna advanced version nhi h is software ka..isi wjh se bhot cheez jo aap yha pe show krte Hain wo purane excel me nhi ho pati hain
To Make Attendance Sheet With Salary In Ms Excel is very very good and suparb, aswom . Would be more wonderful if linked with the detailed salary sheet and salary slip as well..!! So which formula should we use? Thanks 👍
Hello @Deepak, The way of explaining is very good and a lot of effort has been done. I appreciate your hard work. But in the case of salary, the standard days which are counted would be 30. And if the salary is made according to the days of each month as you show in this video, then it will be less and more every month in case there is a holiday deduction
Sir fantastic job.... I need yours help aap ne jaise bataya waise he follow kr k ek sheet toh bana liya sir but mujhko total payable day main se jo Sunday aap ne auto add kiya hai woh kaise remove kr sakte hai
Formula for calculating Sunday is logically incorrect, suppose a employee join mid of the month or remain absent for more than a week in that case also Sunday will be calculated for the whole month, PL and half days must be included for salary calculation and record “PL” Great effort, sheet is excellent
Deepak Bhai ek video main sheet bana kr de jis main ek delivery salesmen ki performance daily note kr saky and at the end of the month uski performance ki base pr uska incentive lagaya ja saky , e.g ek salesmen 20 shop Ka order leker gya hai aur uski sari shop delivered hai aur 100% hai to uska 1 day incentive 1200 hai Jo uski basic salary main add ho Jaye ga and agr koi shop kisi wja se return atti hai to wo 1200 incentive main se %age k hisab se subtract ho Jaye.
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.
सर आपका समझाने का तरीका सरल और परफेक्ट है आपके द्वारा दी गई जानकारी बहुत जल्दी समझ आती है सर ये फ़ाइल सेंड कर दे आपकी अति कृपा होगी
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...
Superb efforts.. Would be more wonderful if linked with the detailed salary sheet and salary slip as well..!!
I was watching many videos on TH-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.
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 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
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🙏🙏🙏
what a grate man first time I like and comment 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.
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
Hi Deepak,
Thanks for sharing it, as I want to learn Advance Excel. Could you please help me on this.
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
Very good explain
For example one person working total overs time 50 hr
I put it total over time column 50 hr
Who split daily 2 hr
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
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🙏
Sir I have low budget mobile I can't see formula can you plz give formula in description. Spl that total payable days
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.
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
Sir ji I want daily expenses sheet monthly ya yearly
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
Bahut badhiya samjhaya sir maza a gya
Good sir ji
majidhameed90@gmail.com
Attandance sheet required
SIR YOU ARE BRILLIANT KINDLY SEND ME THIS SHEET
hey sir ... how can we contact directly ??
dear deepak very good work and best part is that your giving it free
=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
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
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 :* 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
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
Sir Your explanation skill amazing and your video is most helpful for us
Thank you very much Sor
Thanku so much sir.🌼🙏. Aj hi bnai Maine ye sheet.. New join kiya h Maine ek law firm me❤
Congratulations 🎉 and good luck 👍
Sir you are great I'm watching your every video and I'm from Pakistan.
It's too interesting and informative as always sir ji from Suresh Ram Patiala Punjab India ❤❤
That's good for me I am created attadance sheet for our organisation, thank you sir
HI Mr Deepak , Many thanks. Excellent presentation with very clear guidance. I need some help
thank you give us valuable information regarding attendance sheet
Wonderful "Beforeclose function" Thanks Sir .................From Pakistan Punjab Faisalabad Dijkot
It's really very helpful for me....Thank you sir :)
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.
I am your regular subscriber I need this this format,🤲🤲
Aap apne kisi bhi videos mein na to kuchh chhupate ho na hi video kahin par skip karte ho, Mere liye Aapke naam ki har video result oriented and trustful hoti hai. Learners /Viewers ke prati aapki imandari sarahniy kary hai.
Superb sir, I really like it.. 🎉 🎉 Thank you 🙏 🙏
Bahut hi बेहतरीन vedio थी
Great work 👍
I have seen so many videos really appreciate
Thanks very use full video
I want to format of this attendance sheet excel sheet
Superb 👌
thank you sir, i made it, and the experience was awesome.
AAP excel 2021 pe sab sikha rhe hain jab ki Aaj bhi bhot log ke pas itna advanced version nhi h is software ka..isi wjh se bhot cheez jo aap yha pe show krte Hain wo purane excel me nhi ho pati hain
I'm very impressed with your videos...
Thank you so much sir for excellence 🙂explanation
Mind-blowing video.......Sir
Well explained... Thanks alot ,🙏🙏🙏
Very good video it is very helpful thankuu soo much sir
I follow your all video from Bangladesh.
Superb sir... God bless u
hi buddy ,your tutorial is good need to more about excel can u guide me more & share this attendance sheet .
Heads off to you,🙏😍 whàt an explanation and all formulas were mind blowing 🤩
This content help me very much. Thank you very much.
sir me b clrck ho attendence sheet very nice sir thank you oor b iss tara ke videos banye thank you
Awesome dear very nice work done love from Pakistan
Wawo so informative,thank you sir alot
To Make Attendance Sheet With Salary In Ms Excel is very very good and suparb, aswom . Would be more wonderful if linked with the detailed salary sheet and salary slip as well..!! So which formula should we use? Thanks 👍
Thanks for reply 💐
Thanks nice video with detail step by step.
Very grateful and knowledgeable videos thank you so much
Bahat acha dada❤
I am your biggest follower forever 🥰🥰😍💯❤
bhot achi vidio thi jo apne a p manualy bahre uske lye koi formula nahi h ki wo bhi ak bar me bhar jaye
Zabardast Deepak bhai ❤️
Every video your larnable
you are also genius
Hi Deepak, Instead of giving Sat and Sunday as week off i just want to assign week off to individual employee week off
Excellent work by Deepak sir
Hello @Deepak, The way of explaining is very good and a lot of effort has been done. I appreciate your hard work. But in the case of salary, the standard days which are counted would be 30. And if the salary is made according to the days of each month as you show in this video, then it will be less and more every month in case there is a holiday deduction
good...very informative and useful video
You are great as usual
Thanku soo much it's really useful ❤️🙏🙏🙏🙏🙏🙏😘
Bhai yaar aapane to Gajab Kar Diya
Sir fantastic job....
I need yours help aap ne jaise bataya waise he follow kr k ek sheet toh bana liya sir but mujhko total payable day main se jo Sunday aap ne auto add kiya hai woh kaise remove kr sakte hai
Reply sir plz
Namaskar .I learnt many thinks sir
Bht bht congratulations sir ahi information dene k liye sir mera bht kam ayega sir mujhe send kardijia please sir❤️❤️❤️❤️❤️ ilove u
Its very nice and very Use full
Formula for calculating Sunday is logically incorrect, suppose a employee join mid of the month or remain absent for more than a week in that case also Sunday will be calculated for the whole month, PL and half days must be included for salary calculation and record “PL”
Great effort, sheet is excellent
Superb tutorial. Thank you so much
Nice👍
Hi Deepak, great video tutorial.
Really appreciate it
Sir
Your video is too good and very helpful. Please let us know, how to make payslip in this way
I will be very thankful to you for this
Deepak Bhai, should show us this with Sat and Sun as weekend, also what about public holidays which fall on weekends too?
Deepak Bhai ek video main sheet bana kr de jis main ek delivery salesmen ki performance daily note kr saky and at the end of the month uski performance ki base pr uska incentive lagaya ja saky , e.g ek salesmen 20 shop Ka order leker gya hai aur uski sari shop delivered hai aur 100% hai to uska 1 day incentive 1200 hai Jo uski basic salary main add ho Jaye ga and agr koi shop kisi wja se return atti hai to wo 1200 incentive main se %age k hisab se subtract ho Jaye.
Mja aa gya sir ji
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.
Thank you so much from Bangladesh
Excellent efforts
love you dear
Excellent
Very good friend i am very impressed to you, i was very excited for this video
Excellent work bhai ji.
Excellent video!
Great work, thanks for your support. We can’t express in words, god bless you
Thank you so much sir 💚its really very helpful😇
Excellent job done from you sir
Really good work .. very helpful