NEW 🔥 Automated ATTENDANCE SHEET With Check Boxes in Excel | Attendance Sheet in Excel
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 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
सर आप बहुत अच्छा पढ़ाते हैं आपका पढ़ाने का तरीका एकदम बेस्ट हे आपके सारे सपने पूरे हो आपका जो भी सपना हे वो पूरा हो जाए आपकी वजह से मैने एक्सेल में बहुत कुछ सीखा हे एक ही बार में समझ में आ जाता है सर आपकी जितनी तारीफ करू उतनी कम हे सर बहुत बहुत धन्यवाद
Sir really your way of explaining is so effective and understanding.
Can you explain how remove and calculate attendance. If employees left job inbetween?
😊😊😊 good sir मजा आ जाता है आप का viedo देख कर
One problem sir, when I change month or year check boxes at sundays not change
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
Aap video bahut achha banate he
very nice and simple, super attendence sheet. ❤
good sir thanks
Sir love from pak
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
सर मैं एक कंपनी में काम कार्य करता हु 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
Sir data validation main w 2007 main kia validation list dosri sheet se nahi uta sakte?
If you change the month or year data will not change thats the issue here.
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
I'd number scan karke fully automatic attendence lag jaye including weakly off with In and Out process. video lao.
जब गव्हर्नमेंट छुट्टी मिलती है या फिर त्यौहार की छुट्टी मिलती है तब attendance sheet मे कौनसा फॉर्म्युला लगाना हैं वह बताओ.
AGAR ISS ATTENDANCE SHEET MAIN HOLIDAYS SHOW KARNE HAIN TOH KAISE KARENGE LIKE HOLI, YA DIWALI
Check box 2016 me kesa ayega
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
Creating a database to determine the budget in manufacturing companies with a dashboard in Excel
Hello deepak ji humhe yeh attendance sheet chaiye hai
Iam also your Fan to get Learn And Share Into TH-cam❤
Sir pr month ka attend. Kaise save kre
Uper 8:30 ghnte ka present or niche colum me over time for labour employer's
आपके ट्यूटोरियल बड़े गजब के होते है । आपकी आवाज आपकी शक्ल से भी खूबसूरत है। खुश रहो दीपक भाई।
❤️😊
कृपया इसका उर्दू में अनुवाद करें
Sir mai google sheet me kam kr rha hu lekin Column manual adjust krna pad rha h 😢
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
Thanks you sir big fan
Very nice sir.... Sir aap excel work se income kaise kamaye ispe koi video bannaona sir please
If we need to save total records month wise in one sheet. how ?
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
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
sir
kindly mjy guide kry
mery sy IF wala formula ni apply hota
please quartile,decile and percentile par bhi koi tutorial banae
On Sunday also it's showing present in other months
सर मैंने 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
Thank u sir
GOOG JOB
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, 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?
Thank you so much sir dhanyavad bahut accha topic tha
i want to know today employee present & Absent
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
Deepak sir how i can download Microsoft 365
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.
Sir mere pass 365 nahi hai to excel 2016 hai to aisa banane ke liye kaise hoga
Off day work
Agar kisiko Sunday of hai or kisiko Saturday of hai to attandance kaise fill karna hai
Ye lo video.. isme ye bhi sikhaya hai th-cam.com/video/FXgQ3LC17-0/w-d-xo.htmlsi=oKNYxq4aVm0rzZ3z
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
If we want to add half day attendance ...how to add
Awesome your mind voice and your looks like magic and magic bhaiya
You are mind blowing brother could you help us to prepare an attendance sheet with a leave tracker as well.
Sunday v counta Krna he,Sunday ka v ek column add karna h
Fir aap sunday vale columns lock mat karna..
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 es me present oe absent bhi month valyij change hogi na
kindly replay kar dain
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
Boht badhiya
Sir aap bhot ache se padate ho thank you soo much
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.
What is your number?