Fully Automated Attendance Sheet in Excel | Attendance Sheet in Excel

Fully Automated Attendance Sheet in Excel | Attendance Sheet in Excel
Welcome to our KZbin 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.com/spreadsheets/...
==============================
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/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
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

[@shahqasim8513]

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

[@PowerExbyJitendra]

Thank you so much

[@user-hy2uq8gy3c]

thanks for this great tutorial.

[@PowerExbyJitendra]

You are welcome

[@PowerExbyJitendra]

Esa bilkul bhi nahi hai

[@logisvaarichandra4919]

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

[@PowerExbyJitendra]

Best wishes for you

[@MyChanel93]

Very useful TQ so much bhaya

[@PowerExbyJitendra]

Thanks

[@kamrulislam3238]

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

[@SubodhKumar-fb4nh]

Great Thanks

[@PowerExbyJitendra]

Thanks

[@manishchaudhary9110]

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

[@Kishankumar-ok7ic]

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

[@waqasikhlaq7424]

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

[@maria_condensada]

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

[@roshanchaurasia1899]

Excellent

[@PowerExbyJitendra]

Thanks

[@rohitshooter1005]

Wow sir tq❤🎉🎉🎉🎉

[@PowerExbyJitendra]

Welcome

[@ms.alimessages2959]

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

[@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

[@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

[@chetanchauhan_baba]

Very Great, kya old data save hoga ?

[@aniketbonatemusic87]

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

[@Resh837]

Sir how to calculate leave/hr instead of half day

[@user-ef9vb5hy8c]

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

[@adnankondkar9642]

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

[@rajeshoraon7635]

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

[@neharajput568]

Sir mere insert ke rounded rectangle pr formula aaply ni hora

[@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

[@PradumnYou]

Sir Google sheet me work krega

[@manishchaudhary9110]

Sir ye to sabhi months ka same hi aa raha hai

[@user-vg9or9ll5g]

this formula does not work in my pc,why?

[@rjacreation9165]

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

[@manishchaudhary9110]

How to see how many employees present on a particular date

[@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.

[@shekharbisht2080]

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

[@nitishtechnical3673]

sir sheet download nhi ho raha hai sir

[@dancefactory7606]

Sir kay me is Excel mein aad karke reedting karsata hu

[@gajendrarawat2258]

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

[@tanmoydas4834]

Yes

[@patelpankajhiralal9547]

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

[@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.

[@mathewmchacko9400]

well but how to holidays high light in excel pls add

[@PowerExbyJitendra]

Ok

[@bhushanjaju]

Whether every month data is saved ?

[@PowerExbyJitendra]

Create a copy for next month

[@vikasmishra3194]

Har month ka data save kaise karen

[@SArobi-ue1bm]

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

[@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

[@satpaldas3811]

Sunday highlight nhi ho raha hai

[@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

[@nagendrasharma5411]

YHA BHI WAHI SAME ISSUE SAME DATA IN EVERY MONTH

[@shemeerarazak6680]

why in my excel error alert not working for sunday

[@PowerExbyJitendra]

Please apply data validation coccectly

[@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

[@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

[@ShahidulIslam-hk6fm]

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

[@aseersolkar]

Agar National Holiday ho to ?

[@PowerExbyJitendra]

You can add one more combo box for holiday

[@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

[@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

[@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