Fully Automated Attendance Sheet in Excel | Attendance Sheet in Excel

Fully Automated Attendance Sheet in Excel | Attendance Sheet in Excel
Welcome to our TH-cam video, where we'll explore an exciting solution that will revolutionize attendance tracking in your organization. In this video, we'll demonstrate how to create a fully automated attendance sheet in Excel, eliminating the need for manual record-keeping and saving you valuable time and effort.
Watch the video till end and if you like please subscribe our channel.
✅For more videos please subscribe our channel: / powerexbyjitendra
Download out practice file:
==============================
docs.google.co...
==============================
Other Video on Attendance Sheet:
1. How to Create an Automated Attendance Sheet with Salary Calculation in Excel
• How to Create an Autom...
Related Video:
2. If Function in Excel in Hindi
• If Function in Excel i...
3. COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS formula in MS Excel in Hindi
• How to use COUNT, COUN...
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
5. Data Entry Form
• Data Entry Forms
6. Custom Number Formatting Tricks
• Custom Number Formatting
7. Recent Uploads
• Recent Uploaded Videos
8. Best Excel Shortcut Keys
• Best Shortcut Keys in ...
9. Power Query Tutorials
• Advanced Excel Power Q...
10. MIS Report in Excel
• MIS Report
------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#attendancesheet
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexby...
Contact Us:
Instagram: ...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

[@maria_condensada]

Very nice, i have a question. What if I will have the month, day and weekdays. How to do that? thank you

[@Niregarega]

Very Great, kya old data save hoga ?

[@kamrulislam3238]

Holiday two days (Friday, Saturday) rules to highlight together?

[@shahqasim8513]

You are great and best teacher , and you also have good method of teaching , Thanks 🌺

[@PowerExbyJitendra]

Thank you so much

[@logisvaarichandra4919]

tq sir im new in excel, will slowly learn more, Once again tq sir

[@PowerExbyJitendra]

Best wishes for you

[@jobdethperalta]

@@PowerExbyJitendra if i change month the Present place not changing

[@nikhilsoman674]

Very useful. But how to save month wise data

[@manishchaudhary9110]

Rounded rectangle shape me kisi ek date ke present aur absent aa sakte hai kya?

[@MyChanel93]

Very useful TQ so much bhaya

[@PowerExbyJitendra]

Thanks

[@mallikarjunkhanapure5212]

Thank you sir, class is very nice and easy to learn difficult topic's and which Book you referring this Advance Excel, please inform us sir

[@PowerExbyJitendra]

Thanks a lot

[@waqasikhlaq7424]

i love your Channel, can u please teach how to make a Roster ?

[@PowerExbyJitendra]

@@waqasikhlaq7424 ok

[@roshanchaurasia1899]

Excellent

[@PowerExbyJitendra]

Thanks

[@MarlonPepaño-b7u]

thanks for this great tutorial.

[@PowerExbyJitendra]

You are welcome

[@PowerExbyJitendra]

Esa bilkul bhi nahi hai

[@aniketbonatemusic87]

What if employee Holiday me working hai??
Aur Overtime ka bhi format add kare isme.

[@SubodhKumar-fb4nh]

Great Thanks

[@PowerExbyJitendra]

Thanks

[@ms.alimessages2959]

Hello brother thank you brother I need start from 16 to15 type attendance can you help me no problem Hindi

[@Kishankumar-ok7ic]

Sir will u help me creating rate list which can update with color coding (rate up n down)

[@PowerExbyJitendra]

@@Kishankumar-ok7ic yes you can use conditional formatting

[@safikue]

Sir. I want weekly day off base on I'd no. Could you please help that if I enter any employees id no. It should be feel automatic. Like employe I'd no 101.his day off. Monday. Then. Then should automatic fill. Please help

[@adnankondkar9642]

Sir. Is format me agar number of employees zada karna ho tho kaise kare please reply

[@vishalagrawal8717]

Sir can please make a video on how to covert numbers to words? I used vba code for this but even after saving it in macro enabled excel it doesn't work after reopening the workbook

[@PowerExbyJitendra]

VBA file should be save as Excel Macro Enabled Workbook'
Then will work continously

[@nixblossom5696]

Sir, Quesion 1- If i want to add 2 week offs ,like saturday & sunday?.....

[@PowerExbyJitendra]

You can use same technique. One more combo box will be inserted.

[@rinrovin6054]

Hello. Is there a formula that can make a total number of person per day(at the end of the number of person per day) will become blank, if it falls saturday, sunday, or holiday or breaks, or no class?
Additional information Sir, if it falls on the day that is not a holiday, sunday, or saturday, the result is the number of persons present on that day.

[@PradumnYou]

Sir Google sheet me work krega

[@rohitshooter1005]

Wow sir tq❤🎉🎉🎉🎉

[@PowerExbyJitendra]

Welcome

[@rajeshoraon7635]

How to fix data means present and absent with month wise when change the month data will also change month wise

[@ramanvarma8526]

Sir ek problem hai attendance fill karte hai to all month me same entry hoti hai why

[@zissu.1]

Same Problem

[@modiabhinav1]

same

[@Ahmadali-zk1bh]

Same

[@rajeevr9441]

Same

[@gajendrarawat2258]

Sir if we are changing month in January sheet than automatically changing month in all sheets

[@tanmoydas4834]

Yes

[@bhushanjaju]

Whether every month data is saved ?

[@PowerExbyJitendra]

Create a copy for next month

[@Bharath-j1d]

When changed month present and absent also entering same as previous month how to solve

[@Vivek-yd6yk]

Sir month change kiya to har sheet me Same Data dikata hai blank nahi hota ?

[@PowerExbyJitendra]

Attendance vala data delete kar lijiye

[@Vivek-yd6yk]

@@PowerExbyJitendra attendance ka Data delete kiya to har ek month ka Data delete hota hai

[@PowerExbyJitendra]

@@Vivek-yd6yk it means apne sabhi sheets ko select kiya hua hai. Please select only only one sheet from which you want to delete data

[@patelpankajhiralal9547]

Sir
Your work is Good But it is not Fully Automatic because we have to manually fill P or L

[@Resh837]

Sir how to calculate leave/hr instead of half day

[@manishchaudhary9110]

How to see how many employees present on a particular date

[@Snmahaur]

Sir, isme 1 day ki jagah half day 0.5 value add nahi ho rahi hai.

[@neharajput568]

Sir mere insert ke rounded rectangle pr formula aaply ni hora

[@shekharbisht2080]

Sir ji Esme month change krne pr new present or absent nhi aa rha h kya kru

[@rjacreation9165]

sir mujhe attendance me konsi konsi date me present or absent he bo kese niklu please help

[@nitishtechnical3673]

sir sheet download nhi ho raha hai sir

[@dancefactory7606]

Sir kay me is Excel mein aad karke reedting karsata hu

[@HaftayGebrehiwet-e9l]

this formula does not work in my pc,why?

[@SArobi-ue1bm]

Amr off day gula highlight hossey na kno?... Formula disse tar por o hossey na...ata kno hossey...?

[@ShahidulIslam-hk6fm]

স্যার,
এই সিট পূরণ করে যদি মাস পরিবর্তন করা হবে তাহলে ঐ একই পূরণ করা তথ্য থাকে, মাস অনুযায়ী সেভ করার কোন উপায় আছে নাকি, একটা মাসের তথ্য পূরণ করার পর যদি অন্য মাস সিলেক্ট করি তাহলে নতুন করে হবে, আগের মাসের টা চলে আসে। এটার কোন সমাধান আছে নাকি। প্রত্যেক মাসে তথ্য প্রত্যেক মাসে আলাদা আলাদা থাকবে এবং যখন যে মাস সিলেক্ট করবো তখন শুধু সেই মাসের তথ্যই দেখাবে, এমন ভাবে কি করার কোন উপায় আছে। থাকলে একটু জানাবেন প্লিজ।

[@manishchaudhary9110]

Sir ye to sabhi months ka same hi aa raha hai

[@PowerExbyJitendra]

@@manishchaudhary9110 please create a copy for new month

[@aseersolkar]

Agar National Holiday ho to ?

[@PowerExbyJitendra]

You can add one more combo box for holiday

[@mathewmchacko9400]

well but how to holidays high light in excel pls add

[@PowerExbyJitendra]

Ok

[@mr.maurya59]

If any employee is resigned than previously monthly data aslo deleted please solution dene

[@PowerExbyJitendra]

No need to delete previous month sheet you have to create a copy of this sheet

[@mr.maurya59]

Sir please send your mail id I can tell talk to you or any mobile number contact with you

[@vikasmishra3194]

Har month ka data save kaise karen

[@manoranjanTiwari94]

P or ot me chahiye

[@rohitparihaar4367]

Sir Ya Format Contral Ka option kassa att hn Contral ku ka mara Excel ma to nhi aai rha hn

[@PowerExbyJitendra]

Select combo box and right click

[@shemeerarazak6680]

why in my excel error alert not working for sunday

[@PowerExbyJitendra]

Please apply data validation coccectly

[@satpaldas3811]

Sunday highlight nhi ho raha hai

[@SKumarOfficial_]

Month change karne par attendance change nahin hota hai. Same attendance rahta hai. Kyu?

[@PowerExbyJitendra]

Clear your attendance first

[@SKumarOfficial_]

@@PowerExbyJitendra lekin phir pichle month me Jane par current month ka attendance AA jata hai. Koi upay kijiye sir 🙏

[@PowerExbyJitendra]

Sahi tarika hai ki aap is sheet ka ek aur copy create kar lo to ye bhi safe rahegi

[@SKumarOfficial_]

@@PowerExbyJitendra matlab har ek month ka alag alag copy save kar len?

[@Waseem.916]

Then Wt is the need to make drop down list of months

[@kabushkids6749]

HOW TO SAVE THE DATA BEFORE MOVING INTO NEXT MONTH

[@PowerExbyJitendra]

Creat a one more copy of this sheet. Right click on sheet name and creat a copy

[@kabushkids6749]

THANK YOU FOR THE INFORMATION IT WAS REALLY HELPFUL
@@PowerExbyJitendra

[@nagendrasharma5411]

YHA BHI WAHI SAME ISSUE SAME DATA IN EVERY MONTH

[@RKhdMedia]

please Download link

[@PowerExbyJitendra]

Link is in description

[@RKhdMedia]

@@PowerExbyJitendra Link is not work, Download option not showing

[@RKhdMedia]

@@PowerExbyJitendra please good drive link

[@rajeevr9441]

Never follow this video it’s having the same entry’s on every month he is not replaying also how to rectify it

[@PowerExbyJitendra]

@@rajeevr9441hello I have already cleared that if you want to create it for new month please create a copy of this sheet.

[@musondapeter3441]

WhatsApp line please

[@Vicky-tn7sl]

Week off function not working and showing message You cannot use referencees to other worksheet or workbook for conditional formatting criteria

[@avfulltimemasti1944]

कुछ ऑप्शन को आप छुपा रहे हैं आप नहीं बताना चाहते

[@PowerExbyJitendra]

ऐसा बिल्कुल नहीं है

[@nitishtechnical3673]

Please sir apna whatsapp number dijiye n