How To Make Attendance Sheet With Salary In Ms Excel | How to Make Attendance Sheet in Excel Hindi
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- 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...
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
what a grate man first time I like and comment you.
Sir I have low budget mobile I can't see formula can you plz give formula in description. Spl that total payable days
सर आपका समझाने का तरीका सरल और परफेक्ट है आपके द्वारा दी गई जानकारी बहुत जल्दी समझ आती है सर ये फ़ाइल सेंड कर दे आपकी अति कृपा होगी
It's too interesting and informative as always sir ji from Suresh Ram Patiala Punjab India ❤❤
Superb efforts.. Would be more wonderful if linked with the detailed salary sheet and salary slip as well..!!
SIR YOU ARE BRILLIANT KINDLY SEND ME THIS SHEET
hey sir ... how can we contact directly ??
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...
That's good for me I am created attadance sheet for our organisation, thank you sir
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
Hi Deepak,
Thanks for sharing it, as I want to learn Advance Excel. Could you please help me on this.
Sir ji I want daily expenses sheet monthly ya yearly
HI Mr Deepak , Many thanks. Excellent presentation with very clear guidance. I need some help
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
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
It's really very helpful for me....Thank you sir :)
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🙏🙏🙏
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
Good sir ji
majidhameed90@gmail.com
Attandance sheet required
thank you sir, i made it, and the experience was awesome.
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
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🙏
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
Bahut hi बेहतरीन vedio थी
=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
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
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
sir me b clrck ho attendence sheet very nice sir thank you oor b iss tara ke videos banye thank you
Namaskar .I learnt many thinks sir
GREAT WORK
THANK YOU SIR
Hi Deepak, Instead of giving Sat and Sunday as week off i just want to assign week off to individual employee week off
Thank you so much sir for excellence 🙂explanation
Sir
Your video is too good and very helpful. Please let us know, how to make payslip in this way
Mja aa gya sir ji
Very well explained
Deepak Ji its a great effort from your end but i feel something is missing while copying the attendance. I just want to know how did you restrict attendance on saturday & sunday Please suggest
Thanks very use full video
I want to format of this attendance sheet excel sheet
Bht bht congratulations sir ahi information dene k liye sir mera bht kam ayega sir mujhe send kardijia please sir❤️❤️❤️❤️❤️ ilove u
great effort by an expert
Wawo so informative,thank you sir alot
Nice bhai
Thank you so much from Bangladesh
Thanks Sir 👌
I will be very thankful to you for this
HI SIR, Many thanks. Excellent presentation with very clear guidance. I learnt and enjoyed. Keep up the good work.
Excellent video!
Deepak Bhai, should show us this with Sat and Sun as weekend, also what about public holidays which fall on weekends too?
Great work, thanks for your support. We can’t express in words, god bless you
Superb tutorial. Thank you so much
Great information 😊😊
Sir very good work
Hii...sir
Please send current year worksheet with pf esic also
Subscribe kar liye hai
Hello sir mene aapki ye video dekhi achi lagi lekin ekk baat batao salary sheet to hum financial accounting ke hisaab se banate hai to yaha aapne year ka formula bataya hai usme 2022 ke baad last ke 3 month 2023 kaise aayega please bataye
Brilliant Sir
good...very informative and useful video
Graet depak bhi
Nice
Hy
Sir mae is sheet mae according to time entry krna chahta hn wo kaesy ho gi
phir usi timr k mutabik Salary b calculate ho jy
Tell me as soon as
Greatjob 👍 thanks a lot
agar her worker ki weekly rest sunday ki bajaey different ho tu kesy sheet Baney gi ?
VERY NIC PLEASE EXPLAIN MID FORMULA
Thanks bhai 👌👌👌👌
well designed excel attendance sheet
Great work please send me also Inventory control ,Petty cash, Bank records, Party lager Thanks
Very Nice dear
Hi Deepak ji thanks for your hardware
But pls explain some doubts
1. If we put only one present than it will count with Sunday which is wrong
2. In salary calculation it's counting full HRA and PF also with Sunday
sir!
present date se phle ki date me entry na ho aesa ho jaega kya?
Good Evening sir
Video me Apne sheet name bananre k liye Mid formula ka istemal hua hai usme sir is formula same maine apne excel me kiya tha to #value! Likh kar aa raha hai
Hey,
How can we calculate the total absent or present in the sheet? Can we apply any formula or manually we have to calculate?
Thank you sir!!
A lot of thank For sharing
I want a tutorial on how I can get automatic highlight for the increment months of any employee every year....
Hi Deepak
Nice sir
what if the month is starting from 21st may to 20th june how to calculate the end of the month?
Thanks you so much sir
Good sheet
make a video in English which is centralized because most of the people cant understand
sir your very grate
Great effort send this
Is per Bhejiye sir attendance sheet
Sir aap jo information de rahe ho mobile phone me kaise add kare...
Exal me
Sir I have a query sir jab m year change kar rha hu to value error show ho rha hn kya galti kr rha hu btao sir
I want to see a video regarding vloockup
Sir, could you make video for Pareto chart?
Nice
Respected Sir,
Total Payable Days k column mein ager hum Saturday & Sunday dono count karwana ho to wo kese hoga, please reply mein very early because I am working on attendance sheet, please please please.
How to change year in this datavalue formula
MID formula not working......if you do not use this formula then.....process will be same or not
Sir please send me the formula of when I will change sheet name. Automatic name change in Excel. ( For example - if I will change sheet name Jan then automatic name change in Excel in attendance sheet
Sir ,if we put value as "P" when there is Sunday,then it count it along with regular Sundays,,,and salary of extra days paid up,,,,sort out this problem
SIR NEED THIS FORMAT BUT WITHOUT SALARY CALCULATON TAB
deepak bhaiyya, mujhay formula daalna nhe araha means isequalto(''1''&... iskay baad month add kaisay krna hai ??
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
Sir aapka telegraph group ka link de do description me taake me aapka group join kar pau
It's great
Kindly let me inform how to use of Mid function in details at the earliest.
Superb
Dear Deepak sir
Copy formula not working,what will I do
Manually type but not working......