Corporate Attendance Sheet, Fully Automated Corporate Attendance Sheet / Sheet never seen before
Vložit
- čas přidán 26. 10. 2022
- Corporate Attendance Sheet, Fully Automated Corporate Attendance Sheet / Sheet never seen before
If you need an easy and perfect way to track your employees’ working hours while ensuring that they get paid correctly - you need an employee attendance sheet. An attendance sheet template will save your time and money when tracking the hours of your team
Maintaining attendance sheet is the easiest way to do but it needs certain things to be changed every month. In today’s video you will learn how to make a fully automated attendance sheet which will be fully controlled of managed by drop downs and will not need any update if month or year changes.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join the Channel Membership to download the file:
👇🏼 Click here 👇🏼
/ @office-monk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 File Link: Only for Channel Members
docs.google.com/spreadsheets/...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
#attendance #dailyattendance #employeeattendance #attendanceregister #attendancesheet #attendancetracker #studentattendance #attendence #automaticattendancesheet #automatedattendancesheet #automaticattendence #automaticattendance #corporateattendancesheet #attendanceinexcel #dailyattendanceinexcel #employeeattendanceinexcel #attendanceregisterinexcel #attendancesheetinexcel #attendancetrackerinexcel #studentattendance #automaticattendancesheetinexcel #automatedattendancesheet #automaticattendenceinexcel #automaticattendanceinexcel #corporateattendancesheetinexcel #OfficeMonk #Excel #AdvancedExcel #advancedexceltraining
Topics Covered
Attendance
Daily Attendance
Daily Attendance in Excel
Employee Attendance in Excel
Attendance Register in Excel
Attendance Sheet in Excel
Attendance Tracker in Excel
Student Attendance in Excel
Corporate Attendance Sheet in Excel
Attendance in Excel
Automatic Attendance Sheet in Excel
Automated Attendance sheet in Excel
Automatic Attendance in Excel
How to make attendance sheet in Excel
How to make attendance sheet in Excel
How to make automatic attendance sheet
How to make corporate attendance sheet
How to make automated attendance sheet
Thanks for this. Created something similar for my organisation and got some tips for improvement.
Thanks a lot for loving the video and getting connected with the Channel. Stay connected for more such topics 😊😊😊
Hi, posted a new video on Attendance Sheet today with restricted weekends and holidays. Must watch
Hey Office Monk! truly your works are amazing and helpful. and look at that your subs are growing!! was here when you had only 50, congrats!!
I still remember your very first comment which was on Attendance Sheet and you requested for Leave Tracker.
Thanks a lot for the Compliment. It all got possible coz of your faith in my Tutorials 😊😊😊
@@Office-Monk till this day i am using the tutorials you have shared!!! it made our lives easier. thanks and more power again.
Thanks a lot 😊😊😊
WOOOOOW, YOUR TUTORIAL IS TRULY AMAZING, THANK UUUUUUUU VERY MUCH
My pleasure 😊.
Thanks for loving the video and getting connected with the Channel
too good thank you for sharing very helpful
Most welcome. I have got more advanced formats of Attendance Sheet on my channel. Please don't forget to check those videos too
Thanks for teaching me.
Most welcome 😊.
Please stay connected for such interesting topics
Helpful information 👍
Thank you so much 😊
i discover this video today, great explanation and easy to follow the steps. I love it that is why i click the subscribe button and all notification. GOD BLESS FROM pH
Thank you so much for such appreciation 😊
@@Office-Monk YOU DESERVED it sir. GOd will bless those who shared their knowledge.
Thank you sir, really very helpful
Most welcome. Today I posted a new attendance sheet with Holidays. Must watch and thanks a lot for loving the video and getting connected with the Channel 😊
Posted a new Video today of High importace follow up sheet. You are certainly going to love it
Thank you brother
My Pleasure 😊.
Please don't forget to Subscribe the Channel and get connected for such interesting videos 😊
Super ❤
Thank you so much. I have got many more formats on my Channel. Must check 😊😊😊
Very useful for office goer's💙💙❤️💙
Thanks a lot Kalai ❤
Thanks for sharign this
Most welcome. Thank you for loving the video and getting connected with the Channel 😊. Stay connected for such interesting formats
Thankyou sir...........
My pleasure 😊😊😊
This is wonderful thank you for sharing... I have a question do you know of a formula that can calculate 3 or more consecutive absent days of a student in a given month... I have been struggling with this for a while... any help is much appreciated.
=Countif(A4:J4,"A")
A4:J4 is Range
"A" is for Absent
In case your issue doesn't get resolved after this formula, you can share your Excel file and I will do the required changes and will mail back.
Hi,
Hope your issue got resolved
Hi, I loved the video, thank you for this! I just had one doubt, how can I automatically update the sheet when any employee quits. How to remove the employee from the tracker and still maintain everything the same way. And also similarly, how can I add an employee?
Thanks for loving the video and getting connected with the Channel. I would recommend you to watch my latest videos on Attendance Sheet. All your queries will be resolved
Thanks for this informative video.
How we can mention half day(P/2)? I will type P/2 in a cell and it will reflect in total working days.
Thanks a lot for loving the video and getting connected with the Channel. Just by doing P/2, it's not going to count half day. We will have to do changes in the formula. Providing link of a Video of another Attendance Sheet on my Channel. Whenever you have time, please watch the video and all your queries will be solved. 😊😊😊
czcams.com/video/fB86LIs019g/video.html
Thank you so much sir. 🙂
Thanks a lot Vikas for loving the video and getting connected with the Channel. 😊
Posted a new Video today of High importace follow up sheet. You are certainly going to love it
👍
Great Work, One question I have made a similar timetable but I want to have a filter of total absentees on the day. How would this be possible. Thank you
Let me see, what can be done. I got your mail too. Give me couple of days. In case something comes up, I will surely revert 😊😊😊
Just let me know one thing, you just want Count of Present and Absent totals on daily basis, Right?
@@Office-Monk Yes sir. Like list of the absent students etc per day whilst the live timetable gets filled. Thank you, Much Appreciated!
Most Powerful and Advanced Attendance Sheet
czcams.com/video/fB86LIs019g/video.html
Leave Tracker. You can use this as your Attendance Sheet as you have very less data.
czcams.com/video/UkL7lt6OSsM/video.html
Great work...
i tried creating one using your steps but got stuck along the way.. Reason is we have off days from monday through sunday... how do i format it such that off days do not fall only on weekends?
Thank you so much for loving the video and getting connected with the Channel. Just wait for couple of days. I am coming with a new Video on Attendance Sheet in which you can select individuals Week offs and you can select any day / Days of your choice
Btw you can watch this Tutorial of Attendance Sheet. I think your issue will be resolved with this
czcams.com/video/fB86LIs019g/video.html
Ok if when I change month the data which is entered in date's like P,A and so on will it will be change.? Or it will not.?
If it will change what will be the conduction how we do it, Can you help me with this.
This format is for 1 month. For 12 months you will have to create 12 sheets. So if you will change the month in one sheet, data will still be sitting there and it will not change
hey office monk how about the percentage of present, absent and late instead of count? I'll wait for you to create a video for that pls. thank you!
Just for Percentage, I can't create a new video but can do 1 thing for you. I can create the format and mail you across. In that case you will have to provide your mail id. Thanks 😊
Thank you for this, a quick one though, i have realized if i insert the items ie Leave and change the Month from the drop down, it still appears in the second month, how do i correct the error?
Thank you for loving the video and getting connected with the Channel 😊.
We will have to remove it manually before changing the month or we will have to create blank sheets in advance as per our requirement.
Sharing a link with you. Please check this video. This will help you to jump from one file to another in a single click, when you will insert multiple files of Attendance sheet
You can create macro button to clear data
Please check my latest video on Attendance sheet. I covered all the things you want.
@@successmantra4525 Last evening I posted a video of Attendance sheet with Macros.
Excuse me! Could we use vlookup to show the data in each month if we use this file (only one sheet)?
I have got few more attendance sheet formats on my Video. Please check once.
@Office Monk
I have followed your video on corporate attendance sheet
I have tried to create same in the google sheets and it has worked
But only 1 challenge when I am selecting a month from the drop down the previous selected data month is not cleared and is displayed
How to fix this
Hi Sunish, first of all thanks a lot for loving the video and getting connected with the Channel.
This was the 2nd video of Attendance Sheet which I had posted on my channel. After that I had created nearly 10 more Attendance Sheets and with time all the formats got more advanced. I will suggest you to check my most recent Attendance Sheet. Recently I posted an Attendance Sheet on Google Sheets too and I bet that one is more advanced than this.
Coming to your issue now: This format is just for one month and just by changing the month from the dropdown will have no impact on the data filled. The data will still keep on sitting over there. You will have to create 12 sheets for 12 months and 1 sheet for Annual in advance.
Hope you are not facing any more challenges with the format
How can I make the days change with the months if I put a p on feb it shows on every other month
This Attendance sheet is just for one month. If the months will be changed from the dropdown, the data will still keep sitting and it will not be blank.
You have got 2 options. Either create 12 sheets for 12 months or use macros. After using Macros, the data will be blank once the month will complete. The data of past month will be saved and a new sheet will be created automatically. Providing the link of video, through which you can use Macros in most simplest way.
czcams.com/video/fB86LIs019g/video.htmlsi=MSp1FWnIEhhAOTgF
Super 👌 👍
Thank you so much 😊
Can I have production tracking excel for corporate.
@@harisp338 As I am able to understand, you need Percentage of Present, Absent & Leaves. Correct me if I am wrong
No, I work for MNC , we're we do transactions, to know the individual productivity and to track they data daily .
Msg me in Insta @OfficeMonk27
Hi, can you please let me know how I will do a cumulative for the year with this type of attendance
Hi Sanjay,
Please watch this Video. This is much advanced format and your query will also be resolved after watching this video
czcams.com/video/O-XFYCO7I7A/video.html
Hi, the step you did at the end of 12:16 timing , thats not working with me… please if you can help?
Your Weekends are not getting highlighted or EOM is not getting highlighted?
Sir, I have 1 question. I tried this format, and it's helpful, but there's a confusing What if I change the employees' names in every month? It's replaced, same as what we have mentioned from the beginning
This format is just for one month. For 12 months you will have to create 12 sheets. In case you don't want to creare 12 sheets in advance, you can use Macros.
If you want to pick-up the names automatically, you will have to create a Setting Sheet, where you can put all the details of employees and can connect the Setting Sheet with Attendance Sheet through VLOOKUP
Hello there, im trying to format the date cells with =datevalue("1"&A1&B1) and it appears other names rather than the date
Is the another way to format this?
What have you kept in A1 & B1 ?
What are you getting after inserting the formula ?
Thank you sir, can you send the formula for prsent % and leave %.
docs.google.com/spreadsheets/d/1t0yVLDTapleJxQ2OePTVYJeMUO_HpviQ/edit?usp=sharing&ouid=109065873300131166242&rtpof=true&sd=true
Please Check this file. Inserted formulas in the end
Please let me know if you got the new link which I shared right now. Many times CZcamss sends link in Spam
Hi.. ilove the she sheet but when i fill in the detail (H,P) for Janury in example , then i change the month the cell with contain P or H is still there. How to make it blank once i change the month ?? Please help me
This format is for one month. For 12 months you will have to create 12 sheets. Just by changing the months and year, data will not be blank
Hey I like your video Im facing some issues When I change my month data is always there if I delete data from February ist also deleted from January kindly give me the solution
waiting for your reply
Data will not be deleted automatically once the month will be changed. We will have to do it manually. It would be better to create 12 sheets in advance, keeping the master sheet blank for future use.
In case you are facing some other challenges, Please mail me your sheet, I would love to resolve the issue. Stay connected for interesting topics 🙂🙂🙂
@@Office-Monk hey can you make a part tutorial to better understand us
@@sadaqatkhan-xn3dy Exactly for which part you want
Sir ji what if week offs are rotational.. can you please helps us with that.
Thank you for loving the video and getting connected with the Channel 😊😊😊.
In case the week offs will be rotational, we can't restrict days. In that case we will have to restrict only EOM. I have got 2 more Attendance sheet videos on my channel and both has different formats.
I will appreciate if you can give more clearity on the requirement of your Attendance Sheet, I will try to find a way to create
@Office Monk.. Nice Video but there is an issue. When you input the data for Jan, and when you select February, the data of January appears.
Can you show it again.. thanks
Hi Kevin,
This Attendance Sheet format is just for 1 month. If the months will be changed, data will be still sitting. I have got nearly 5 different formats of Attendance sheet on my channel. I would love if you check them once. Attaching link of one Attendance Sheet which is quite advanced and the data will be blank once the month will change
czcams.com/video/fB86LIs019g/video.html
@@Office-Monk thks
My pleasure 😊
Hi I tried as u instructed. But if I update fr Jan it is reflecting in Feb month.and if I delete for Feb it is deleting data in Jan.
Could you pls assist me with this
You can download the file from the link provided in the description and can crosscheck the formulas
Hi sir I have a small doubt.... Every month we need to prepare the fresh sheet or just we can change the month and enter data.????
Please reply anyone
You will need 12 sheets for 12 months
hi sir, i have question. please guide me. when one month attendence filled in the sheet and i change next month, previous month data carried in the next month. previous month data must be saved and when month changed sheet must b blank.
Muhammad, this sheet is just for one month. For 12 months, you will have to create 12 sheets. Just by changing the months from the dropdown, data is not going to change or vanish. In case you don't want to create multiple sheets, please watch my new video of Attendance Sheet. In the new format, there is only one entry sheet for 12 months.
@@Office-Monk can you please share the link of the video where there is only one entry sheet for 12 months? Additionally, i would like to include the logic of multiple departments attendance. Please reply with your valuable inputs here along with the link of the video.
@hiteshsatapathy7032 you will get the video on my Channel
Can we do it in spreadsheet as well?
Hi Gaurav,
to be very frank, I never tried in Google Spreadsheet. To my knowledge, few features in Excel and Google spreadsheets are different. So exact format in spreadsheet may not be possible
Can you pls also add weekly Data creation as well
Or Pls add week in this data
I have got more Attendance Sheet on my Channel. Please check once. In case you want something different, please share a raw format
show how to create toll free leave register and app base leave require
I haven't understood
Sir, how about half day leave formula ?
If half day, we can put working hours or HF, instead of Present but for that, we will have to insert a column in the end to count sum total or hours or half day
After u put the attendance, when u change the month, the attendance still follow previous month. No change
This Attendance sheet is for just one month, so the data will not be blank when the month will be changed. Please check this Video
czcams.com/video/fB86LIs019g/video.html
In this Video you will find a way blank the data once the month will be changed and the last month data will be saved automatically
Hi
I have prepared the excel accordingly... entered the presence data in March'23 month and when i change the month to April... march presence data not going off ... could you assist me what to do
Hi Anish, thanks a lot for loving the video and I am happy to see you created your format too.
This format is just for one month and it will not get blank when the month will be changed. There is one video on my Channel by the name of, Most Powerful and Advanced Attendance Sheet. Just check that video once and you will get an idea on How to make the sheet blank with just a single click. You don't need to create new format again. Just watch the video and use Macros and your work will be done.
In case you face challenges after that too, please message me on Instagram. I would love to resolve the issues.
@@Office-Monk could you ping the video link here which you asked me to watch so I can follow..
Side note..really really appreciate your efforts to prepare the videos like this
@@karlapatianish czcams.com/video/fB86LIs019g/video.html
@@karlapatianish Thank you so much for the appreciation 😊😊😊
how can we save all monthssheet,without duplicating individual sheet
You have 2 options:
1) Create 12 sheets for 12 months
2) Use Macros. When you will use Macros, sheet of new month will be create with a single click, once the month changes and data of old month will be saved automatically.
Providing link of a video, through which you can create Macros enabled sheet/format.
czcams.com/video/fB86LIs019g/video.htmlsi=aNe2RxSzUNwxyiqv
Every thing is okay but after changing month same filled data from last mnth show...please tell me how to fix this
Now I got what you meant to say. I thought you are dragging the dates and the data is not getting filled up.
This Attendance Sheet is for just one month. So the data will keep sitting in case the month will be changed.
Now you have got 2 options. Either create 12 Sheets for 12 months or use Macros to get the Current sheet blank. Sending you link of 2 Videos. Both these videos are more advanced thn the current one. After watching these videos, decide which one will be better to use
czcams.com/video/2kIIdJfGeEc/video.html
czcams.com/video/fB86LIs019g/video.html
Any one help me. I create list for april,may , month and 2024 , once i deleted any data inth current month other month also change. put data also all data store in the all month
This format is just for 1 month. For 12 months you will have to create 12 sheets.
Just by changing the months from the dropdown, data will not be changed or erased.
@@Office-Monk its not erased .that is my problem sir
For 12 months, please create 12 sheets
❤️
😊
There is a problem, if you can help me, when we change the month, the old data remains. How can I make the data (P, A etc.) adapt to the selected month?
This format is just for 1 month. For 12 months you will have to create 12 sheets. This is not a Macro enabled sheet, so just by changing the month from the dropdown, data is not going to change, deleted or vanish
@@Office-Monk can we do the above task using macros in google sheet? If so, then please guide me how to do that?
I have created an Attendance Sheet in Google Sheets where you can do the entry of 12 months in a single sheet. Please watch that video once. Your issues will be resolved and Macros will not be required for that
Hi can you help me create this type of bi weekly report?
Hi, what's your basic requirement ? You want only 7 days instead of 30 / 31 ?
Please tell me in detail for my better understanding and for sure I can come up with such a format which will be useful for you
@Office Monk hello I need bi weekly time sheet sir. Tha k you much appreciated. 🙏
It can be created. I will come up with a video on this topic very soon. Please subscribe the channel and stay connected
@Office Monk may I ask if how can I separate the content from each month since when you do the work in January then do the work in February, it affect in January also, content from February will be the same as January. What should I do to have separate content of work each month thank you
czcams.com/video/UkL7lt6OSsM/video.html
I will suggest you to see this video. You can create Weekly Attendance Sheet based on this format. All the entries will be done in a single sheet and in next sheet you can check Attendance as per months. In last or final sheet there will be total entries from where you can Check Daily, Weekly, Monthly, Quarterly or Yearly Attendance
How to make this format
You will find the file link in description. You can download and practice
SIR IAM A NEW SUBSCRIBER I HAVE SMALL DOUBT SIR, PREPARE A ATTENDANCE SHEET IN EXCEL , HOW TO FILL MORNING DUTY AND OFTERNOON DUTY ATTENDENCE IN SINGLE DAY IT MEANS " OT" DOUBLE PRESENT BOTH TWO DUTYS IN SINGLE DAY TOTAL COUNT ,,,,,, IS IT POSSIBLE SIR... SIR PLEASE ANSWER ME SIR ........ IAM WAITING OUR ANSWER SIR PLEASE
Any queries are most welcome and I reply all the comments.
I have got a video on Time Tracker on my channel. Just watch it once. I think your issue will be resolved
There's an error, If we put "P, A, H, PL" in Jan 2023 then we jumb on Feb 2023 , attendance showing in the same column.
This format is just for 1 month. So data will keep sitting regardless you change the month or not. Providing the link of another Video on Attendance Sheet. In this format the Data will be blank and the old data will be saved in new sheet.
czcams.com/video/fB86LIs019g/video.html
Hi Sir,
Unable to save the data, If we change the month from Dropbox. No data saved
This Format is just for 1 month. You will have to create 12 Sheets for 12 months. Just by changing the month the format will neither get blank nor the data of other months will be featured. In case of any confusion please message me on my Instagram @OfficeMonk27
What you need basically ? When you change the month, data should be saved and new file should be created automatically ? Suppose you entered Data of Feb and you refreshed the Sheet and Feb data got saved automatically and a new blank file got created ?
@@Office-Monk yes sir
Got your point. Will come up with a video of Attendance Sheet which will surely cover above points
@@Office-Monk I will be waiting for it, thank you 😊
if you change the month after putting some marking on the day. marking like "A", "P" etc... still be there bro ahaha
It will be there. You will have to blank the sheet/cells before entering anything. There's no reset button that the data will be blank automatically.
Can i get production tracking report
Production tracking report of what ? Please tell me in detail for better understanding
Can I have E-mail ID.
@harisp338 vijaymukh@outlook.com
Let me know on which criterias you want to track the production
Good Morning, I have sent a email to you.Tq
@@harisp338 I got your email. Let me see how I can add some value to it.
When the data for January 2024 for example is filled up already, February was supposed to be blank but with this, the January data is still there. How can we retain the each months data and start a new one for the next month?
For 12 months, you will have to create 12 sheets in advance. Just by changing the months from the drop down, data will not be blank. If you want the data to be blank, retained and a new sheet gets inserted, you will have to create Macros
@@Office-Monkwhen the data for january 2024 for example is filled up already, February was supposed to be blank but with this,the data is still there. How can we retain the each month data and start the new one for next month...can we make same scaniro in excal?
Hi dude, Did you find any solution for this ??
To blank the data once the month changes, we will have to use Macros. In case you don't want to use Macros, create 12 sheets for 12 months in advance
@@Office-Monk can you please post video for that..
Sir kindly hindi me bhi samjhaye.misam hussain.
Aap chahen mera Hindi Channel subscribe kar sakte hain. Mere Hindi Channel ka naam hai @OfficeFreak
Ye Hindi Attendance Sheet video ka link hai
czcams.com/video/YpylHQ6qraQ/video.html
Sir month change karne par data sheet change nahi hota h Woh kaise change hoga month ke sath
Hello Osman.
Ye Attendance sheet sirf 1 month ka hai. 12 months ke liye aapko 12 Sheets create karne honge. Ya phir aapko Macros use karna hoga. Main aapko ek video ka link bhej raha hun. Aap uss video ko aaram se dekhiye, aapka issue solve ho jayega.
czcams.com/video/fB86LIs019g/video.htmlsi=zDoAsRjfnbxHvWWi
Shukrya Bhai
Most welcome 😊
Hai sir now am sending mail kindly clear my request
Plz reply anybody
Message karne ke baad thoda time diya karen Shriman. Main bhi kuch kaam me busy rehta hun. Free ho kar hi reply kar paunga 😊
Even if we are changing the month data is not auto changed. You waste our time bro. Do not do this
Thank you for the feedback Mr. Mayuresh. Just checked the file again and it's working perfectly on my system. I have already provided the link of the Excel Sheet in Description Box.
Providing link once again. In case you still face challenges, Please drop me a line. I would love to resolve it. Thank you once again.
docs.google.com/spreadsheets/d/14pkYLwE3v3PHUhhCvxXDh1vCOoAexg3i/edit?usp=share_link&ouid=109065873300131166242&rtpof=true&sd=true
WhatsApp line please
Any issues ?