NEW 🔥 Automated ATTENDANCE SHEET With Check Boxes in Excel | Attendance Sheet in Excel
Vložit
- čas přidán 14. 01. 2024
- Revolutionize your attendance tracking with this step-by-step tutorial on creating an automated Attendance Sheet with checkboxes in Excel! Whether you're managing a classroom, workshop, or any event, this guide simplifies the process with easy-to-follow instructions. Learn how to set up an efficient system that allows you to mark attendance with just a click. The use of checkboxes makes the process intuitive and reduces the likelihood of errors. Watch the video to discover time-saving techniques, and download the provided Excel template to implement an automated attendance solution seamlessly. Say goodbye to manual tracking and hello to a more organized and streamlined approach with Excel! This attendance sheet is created using excel new check box feature which is still available in office 365 desktop and web versions. - Automated ATTENDANCE SHEET With Check boxes in Excel | Attendance Sheet in Excel #attendancesheet #excel #deepakeduworld
Download Template : bit.ly/3U5myC7
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld
excel for analysts
excel for beginners
One problem sir, when I change month or year check boxes at sundays not change
आपके ट्यूटोरियल बड़े गजब के होते है । आपकी आवाज आपकी शक्ल से भी खूबसूरत है। खुश रहो दीपक भाई।
❤️😊
कृपया इसका उर्दू में अनुवाद करें
very nice and simple, super attendence sheet. ❤
सर आप बहुत अच्छा पढ़ाते हैं आपका पढ़ाने का तरीका एकदम बेस्ट हे आपके सारे सपने पूरे हो आपका जो भी सपना हे वो पूरा हो जाए आपकी वजह से मैने एक्सेल में बहुत कुछ सीखा हे एक ही बार में समझ में आ जाता है सर आपकी जितनी तारीफ करू उतनी कम हे सर बहुत बहुत धन्यवाद
Sir really your way of explaining is so effective and understanding.
Can you explain how remove and calculate attendance. If employees left job inbetween?
Sir aap bhot ache se padate ho thank you soo much
Thank you so much sir dhanyavad bahut accha topic tha
Thanks you sir big fan
Awesome your mind voice and your looks like magic and magic bhaiya
Boht badhiya
Sir, I have been trying to form a screener for shares with function of Min & Max at Chartink but can't do that. Can you please help me for the same?
😊😊😊 good sir मजा आ जाता है आप का viedo देख कर
good sir thanks
You are mind blowing brother could you help us to prepare an attendance sheet with a leave tracker as well.
Thank u sir
Aap video bahut achha banate he
Sir data validation main w 2007 main kia validation list dosri sheet se nahi uta sakte?
Iam also your Fan to get Learn And Share Into CZcams❤
brother checkbox ko insert tab m kesay add karna h aur ye kam kesay karay ga, m ny is ko insert tab m add kia h lakin hab m kuch cells ko select karta hon aur check box ky button par click karta hon tu check box nai atay in sab cells m
Sir love from pak
GOOG JOB
sir handwriting s likhe hue data excel m convert krk bataye jo youtube m mojud h us hisab s google lens m ho to jata h mgr data ek sath niche m aa jata h ise tabel m kese convert kre
Very nice sir.... Sir aap excel work se income kaise kamaye ispe koi video bannaona sir please
For ex_ Hum jab bhi kisi ek particular month k sheet mai kaam kr rahe hai aur usme kuch data enter kr rahe hai,
woh baki k har mahine, k cell mai, woh same data show ho rha hai.
Hum woh data sirf uss particular mahine k sheet mai show krwana chahte hai jispe hum kaam kr rahe ho,
Par woh baki k har mahine Wale cell ko effect kr raha hai.
Ispe kuch bataiye
AGAR ISS ATTENDANCE SHEET MAIN HOLIDAYS SHOW KARNE HAIN TOH KAISE KARENGE LIKE HOLI, YA DIWALI
Creating a database to determine the budget in manufacturing companies with a dashboard in Excel
cell is not locked while pressing F4 key. please help me what to do?
It's simple
Just hold down the Fn key before you press F4 and it'll work.
Sir es me present oe absent bhi month valyij change hogi na
First like & first views
If we need to save total records month wise in one sheet. how ?
please quartile,decile and percentile par bhi koi tutorial banae
Sar ek per day collection Lene wali seat banaaiye jismein with penalty daily payment receive kar sake 6 mahine se lekar 1 sal 2 sal 3 sal Tak
if any employee leaves in a month, if you delete his name from the attendance all his previous data also get deleted please solve this problem
sir jaise ms office me data ko table format me karte he waise hi google sheet me data ko table format me kaise kare our google sheet me 2 se jyada critearea filter kaise kare sir please ispar ek video banaiye
I'd number scan karke fully automatic attendence lag jaye including weakly off with In and Out process. video lao.
Sir muje ek sheet chahiye jisme
30 days present hai or extra hours (ot) present days ek niche aana chahiye..
No leave rahega 30 to 31 present dikhana hai
On Sunday also it's showing present in other months
सर मैं एक कंपनी में काम कार्य करता हु Hr Assistant के पद पर तो हमने डेली क्या काम किया है अपने सीनियर को रिपोर्ट देनी होती है और हमें डेली एक्सेल पर या तो डायरी में लिखकर उनके पास भेजना पढ़ता है कृपया सर कुछ ऐसा बताओ जिससे हम सब अपने सिस्टम में डेली वर्क अपडेट करें और वो हमारे सीनियर के सिस्टम में शो हो जाए डेट वाइस सर अगर आप इस टॉपिक पर वीडियो बनाओगे तो plz कमेंट को लाइक कर देना धन्यवाद सर 🙏
Daily work screen shot mail ke thru send kr diya karen
Sir apka proper kaam kya hai
Attendance ya phir kuch aur
Bhai google sheet use kro aur unko share krdo jo usme tm dikhaoge wo unko dikhega
network k thr share kr sakte h
Google sheet use karo
Uper 8:30 ghnte ka present or niche colum me over time for labour employer's
Sir muje ek macro record krana h excel mein apne data ke according
Jo chrge lgega mein pay kr dunga sir
Pls help sir
Sir mai google sheet me kam kr rha hu lekin Column manual adjust krna pad rha h 😢
If you change the month or year data will not change thats the issue here.
If we want to add half day attendance ...how to add
Hello deepak ji humhe yeh attendance sheet chaiye hai
Jis year ka attendance fill karte hain wo sabhi years me aajata hai or jab kisi ek year ka change krte hain to sabhi me change ho jata hai
जब गव्हर्नमेंट छुट्टी मिलती है या फिर त्यौहार की छुट्टी मिलती है तब attendance sheet मे कौनसा फॉर्म्युला लगाना हैं वह बताओ.
Ishi me 1 dihaadi and over hours over time btao add krna jaise ki 1 day and 3 hour 2 hour 1 hour half hour etc.
Deepak sir how i can download Microsoft 365
i want to know today employee present & Absent
सर मैंने attendance sheet bna li
Sheet1 pr
Sheet 2 pr employee ki salary ka calculation kr liye
Ab koi yesa फार्मूला btaye जिसमें
Hm sheet1 pe month change kre to or calculation sheet 3 pr poori year ka save ho jaye months wise plz sir
Check box 2016 me kesa ayega
Sunday v counta Krna he,Sunday ka v ek column add karna h
Fir aap sunday vale columns lock mat karna..
not working.... first month ka data savi month me ar every year ek hi aaraha hai....
Duplicate sheet me work kro bhai tb ho gay shayad
Agar kisiko Sunday of hai or kisiko Saturday of hai to attandance kaise fill karna hai
Ye lo video.. isme ye bhi sikhaya hai czcams.com/video/FXgQ3LC17-0/video.htmlsi=oKNYxq4aVm0rzZ3z
Hello sir, month change krne pr cell blank ho Jana chahiye n lekin blank nhi hota hai, plz bataiye
Is format me apko checkbox add karne se pahele month year select karna padega…
@@DeepakEduWorld to kya Jo month ka attendance fill rhega wah dusre month year select karne pe blank ho jayega
@@DeepakEduWorld sir ek question aur hai sir, mere pas office 10 hai aur main aapke video ke anusar attendance banaya tha lekin Jo page ko attendance fill kr lete hain aur fir month change krte hain to fill wase hi rah jata hai, aapse request hai ki ek video Aisa banaiye jisme month change karne ke bad page blank ho jaye
@@DeepakEduWorld aapka bahut jyada video main dekh chuka hun achha lagta hai kuchh new learn krna aapse
kindly replay kar dain
Off day work
sirji check box nahi aa raha hai, insert select karne ke bad
Ye new feature hai g.. aapko office 365 desktop and web version me hi milega
check box Windows 7,10,11 kaise kare.