Daily employee attendance sheet in excel||How To Make Automated Attendance Sheet with salary Sheet
HTML-код
- Опубликовано: 5 сен 2024
- Hello Learners;
Welcome to my RUclips Channel!
How to Make Attendance sheet|| Employee Attendance sheet||Salary Sheet
In this video you will learn how to make an automated attendance sheet in excel. In this tutorial, you will also learn how to make salary sheet, with many new formulas and tips and tricks.
You can also used this template in college and School.
Hope you Will like the video. You will also Watch the latest video on Excel Beginner Tutorial.
• Excel Tutorial|| Excel...
Download File: docs.google.co...
#AttendanceSheet #SalarySheet #AutiomatedAttendancesheet
I Hope You liked my content and learned something new from this video Please like and share this video and also check out my latest video on "How to Create Marksheet in Excel."
ruclips.net/video/UgV1gDPcLFE/видео.html
I learned that you don't speak English even though the title is in English
Finally, I just saw someone from Pakistan who made such a great and much-needed tutorial. Well Done , keep it up
Thank You for admiring my Work.
Wow... thank you so much
Mam so helpful. Bohat kuch new chezen seekhi hain maine is vedio se
Thank you
Mam jese ap ne attendance sheet banai isi main agr o. T dalna ho kisi ka to kaise add kr sakty hain???
For example aik banda 2 date main present b hai aur us ne 8 hrs o. T hrs b lagaye to mam main present aur o. T kaise adjust kr sakta hun
Mashallah A complete full tutorial.
I understood very well , I like your salary knowledge so I will trying because I like this work
Thank you.
Thank you ma'am
Welcome
Thank you so much for this video
Thanks for teaching.
Superb work thanks
May Allah Almighty give you lot of courage ,thank you so much ❤️
Masha Allah Great job ♥️❤️
Very well explained! Learnt a lot 👍
Thank you so much for your feedback Ghazi Abbas
mashallah good job
Great Video, thanks
A one 👌the way you explained MashAllah
Well explained👍🏻👍🏻
Super madam
Thank you
Kin kin logo ko pasand aayi sheet like
You are amazing ma'am
Thank you
You are doing an amazing job my dear..May Allah give you more strength and courage to do much n more ameen💗
Well come
Wow it's unique
Keep it up
An informative video👍🏻
Useful information.
Thanks.
Kya ham Aisi Excel sheet bana shakte hai
Ki month change karne par usme fillup absent and present etc v change ho Jaye,
Mtlb next month ki attendance banane k liye sheet copy na karni pade, ek hi sheet me 1year ki attendance ready ho jaye
zabardasht
Proud Of U ❤️
Thank you Annie Butt
Thanks
Dear Huma
You did a Great Job but suppose I want to insert overtime during the month & overtime is in the number of hours not in (P} for Present, do you have any other Excel sheet of the concern?
Please if you can advise.
Nice 👍
Super medam
Excellent Work Sis ... Keep it up
V-good
Good morning mam
When change the month all attendance comes in the next month and year ho wcan we stop it
I created the same leave tracker after learning from your video. But the thing is if I apply leave in Jan it reflects in rest of the months. How do I solve it ?
This attendance sheet is specially designed for the creation of the same format over the next months if the previous month's attendance reflects in the current month, all you need to do is to save as the previous sheet and remove the data, in that way hope your problem will be solved
But the thing is it will erase all the formulas and we have to prepare another sheet every month ?
nice
Hi,
I stuck with a problem if i Mark the attendance for the month of say January then it itself my the mark the attendance for remaining months.
Agar mai January me attendance laga raha hu to khud hi remaining months me attendance Mark ho rahi h.
Har month ki attendance to alag honi chaye.
Kindly guide me
Thank you
Hello Khalid, thank you for your comment, first, you create a copy of the sheet, the second step is just simply remove the present, absent and leave for the next month. Then you mark the attendance as per the month requirement. Moreover you just simply remove the absence and leave when your employee is absent.
@@crazeoflearning Thank you for your reply.
Please make video on monthly and yearly leave record sheet
Sure
I don't understand conditional formatting formula plz write in coment
Same here
Make video on leave tracker
how to make index and separate data for every employee
Agar month 25 se 25 tk Hoto uski automatic attendance sheet Kaise banaen his mein doubles month ata hai
if wala last date mai kya formula laga
madam U have given a formula regarding highlight of sunday is not working
Make sure when you used the formula you have written your column and row number where you mentioned the day.
Still you faced any problem comment again I will answer.
can you provide the salary slip generate month on basis daily attandance sheet
Mam agr leave ki b Scalar bannai ho to wo kese bnay gy or Agr humer par 600 percen h to har aik kar rest lag lag h to Wo hum kese shamil kare gy
How you deleted data from every cell at once
But I have a doubt is data saving ?
Suppose if someone take leave from 20 Jan to 10 Feb so is it saving in the sheet ?
This sheet only saves the data of the particular month, for the next month, first you copy the sheet then mark the leave of the employee of that month.
For example, if someone takes leave from Jan 26 to Feb 10. First, you mark the leave-in Jan sheet, and after copy the sheet of the next month you mark the leave of Feb.
I can't go to data validation to list source and again go back to sheet 1 for select months
For data validation, you first go into the data tab, then select data validation=Select List=then source, in the source you can also write the months if there is a problem in selecting the months from different sheets.
AoA. Meriii company hy or mery pas daily wages pY log kam krty hy or un koi pay b daily wages k hisab sy deniii hotiii hy his my wooo 8 hours duti k sath sath over time b lg Jata hy agr us koo excel sheet pY manage krna giii too kindly as k bary my agr thori c information Dy Dy too plz. Sukriya
HELLO MAM APKA METHOD BAHUT ACHA BUT MAINE SAME APKO FOLLOW KIYA BUT EK Problem arahe hai .. jan and attendence same feb ko bhi dekha raha hai plz aap ye problem solve kardenge
Ap agar create a copy wala option kar rahe to wohan ap ko phele Jan ki remove karni pari gi.
Kyun k sirf drop down list sei Feb change karne per attendance remove nahi hogi.
Still problem hai to ap dobara comment kar dein I will answer.
What was the formula of conditional formating....can't get that....plz somebody tell me
Step 1: go to conditional formatting
Step 2: choose to use a new rule.
Step 3: type =or(cell numbers which you mention to height suppose it is D6 and dollar sign between like this D$6 ="Sun")
Complete formula look like
=or(D$6="sun')
Hi, I tried the same way to create a sheet. But on mine the P, A, L are not changing with the months. I started the entry with the month of October and following all the months are picking the same data for attendance. I dont know what went wrong. Can anyone help??
Send me your sheet at this email address. I will check it.
humaabubakar6919@gmail.com.
Or I think you first check that either you copy the sheet or not.
The second problem might be that you did not remove the data properly.
Am not getting dates automatically
But one query when I am changing month so the leaves or absence not getting changed that's not getting change as per the month where I am getting wrong can anyone plz help me out
Thank you for your comment, Let me clear the thing, first, you will create a copy of the sheet, then you just simply remove the present absence and leave, and mark again as per the next month attendance.
Asslamualaikum, madam huma maine aapke video ko acchi tarha se copy kiya but mera jo monthly data hain woh har woh month pe same bataraha hain..aur sunday highlight sirf first top row mein hi horaha hain..kya karun main kya meri maddad kar sakti hain aap...
Walikum as-salam thank you for your comment!
First thing when you copy the sheet, you remove your absent, present on that month.
In the second step, you add present, absent according to the particular month.
For Sunday you change the month the Sunday will highlight automatically according to that month.
@@crazeoflearning jazakallah khair, i did the same as you mentioned..its worked now..
Es me PP ko kese double count karenge
Assalam alaikum
I have monthly attendance
Of 60 employees .
For ex. Xyz = present 27 days in a month but I don't have which days he present
ABC = present 17 days in month
Etc. Etc. And I have the daily total attendance for ex. 1st day = 52 employees presents
2nd day = 45 employees present etc.
I want to fill the attendance sheet accordingly can you help me in this.. Jazak Allah
Walikum as salam, thank you for your comment, InshaAllah soon I will make a video on the leave tracker.
In this leave tracker sheet, you will easily find the data of your employee month and year-wise.
So stay tuned.
Ma'am month,date ,day change horha hai but jo inside material hai PRESENCE AND absence ka wo kaise change hoga?
Jab ap sheet ko next month k liye copy kare gi to wohan ap present and absent ko simply remove kar dein..
Is k baad us month ki attendance k hisab sei present absent lagye.
Hello madam I want learn about vlookup
Thank you for your feedback, you can learn Vlook from my mark sheet video and there is also a video on excel formulas you can learn from it.
ek esa sheet banaye jo year badalane ke bad sheet me koi badale nahi
Sharma ramesh sheet change nahi hogi, ap use copy kar k data edit kar sakte hain..
Lekin employees turnover ki waja sei sheet changes hote rahe gye.
Hope you got my point.
Mam last date wala formula ni bn raha
Which formula? Plz mention
Over time calculation nhin hai isme.
I fill "P " and "A" in one month but
Same present and absent show in all months
Whenever present and absent are different in all months
Plz mam ..
solve this problem
Deepak, when you create the copy for the next month just simply remove the present absent and fill the present and absent according to that month. And still, you face the same problem all you need to do is
"Save as" the file for the next month and start working, but due to this, you have different files for each month.
❤
Please provide download links
Please check the Description box.
Mam ye formula lag nhi rha
Kajal yadav which formula? Please mention
Gross salary formula is not currect
If someone's salary is 50k and if he was present 26 days and took 4 weekly off then he should get his full salary
Every month you need to delete the data than u will update for current month
No, you just copy the sheet and you save the previous sheet by month.
Like first you save as by month then copy the sheet. In that way, you have all the data of previous attendance.
Moreover, you can also save the data on the same sheet. Just remove the attandence when you copy the data for next month.
Your doing vba
Soon you will see Excel VBA-related content.
Sir kuchh kanfiujan hai call me
Kuch bhi ni dikh rha hai aisi koi vdo bnata h
@sheela Rathore thank you for your comment, I think there must be a setting issue. You check the video quality in your setting option
Hi mem aapka number dijiye mujhe aapse bat karna h. .excle class ke liye