So nice, Sir Aapke sabhi video me naya sikhne ko milta hai jo bahut hi upyogi hota hai. Mai video me di gai tips ka upyog karke apne office work ko smart tarike se kar pata hu. Thank you so much👌👌👌
Dear Deepak your vdo is excellent and very helpful can plz guide us when we enter the data in the attendance box in the month of Jan and save the same but the data remain the same in next month (Feb) but actually, that should change.......so plz guide.
Sir bhot khob .kindly daybook b banay .jis mein yeh b bty ga k jo log aj pasy ly kr gy h.but bill kal ya hafty baad dy gy us ko kasy apni daybook mein rkh
बहुत ही काम है यह वीडियो। काफी मेहनत करते हो भाई, धयाबाद। भाई थोड़ी मदद चाहिए आपकी और आप से हो भी जायेगी। मेरे पास दो कॉलम A और B है। A में 100,200 और 300 लिखा। B मैं मैंने 0,1 और 1 लिखा। A4 में Sum है। मैं चाहता हूं कि B में 1 की जगह 0 लिखूं तो उसी Row की B कॉलम की राशि A4 से घट जाए। मेरा विश्वास है आप जवाब जरूर देंगे। एक बार फिर से धन्यवाद।
VERY NEEDFULL & HELPFULL THANKS....ONE MORE QTN... SIR IF WE GO TO FILL P OR A AFTER FILL I WANT THAT COLUMN IS LOCKED NO ANYBUDY CHANGE THAT COLUMN FOR SECU.PURPOSE CAN THIS POSIBLE SIR.....
Deepak Sir, Bahut Accha aur Knowledgeable video hai ye, But Month/Day/Year Change krna aur sunday lock krne ka matlab kya hua jab month ka data hi lock nhi reh raha, aap january me jo daale hai, wahi data month change krte hi agle me aa jata hai,
Hi, too smart work, but i have one question please, i two days off in a company than data validation formula how for block cell entry... Please let me know. Waiting 😊
धन्यवाद दीपक, मैं छात्रों की उपस्थिति के लिए इस प्रारूप का उपयोग कर रहा हूँ। परन्तु मुझे एक समस्या है, जब हम अगले महीने आगे बढ़ते हैं, तो पिछले महीने उपस्थिति हुबहू उपलब्ध रहती है, इसलिए कृपया मुझे स्पष्ट करें।
very goog work sir well done......actully sir ak cheez ki smj nai aa rhi jb hm ak sheet py kaam krny k bad month change krty hain to Attendance sheet wahi rhti hai presence or absence change krny pr pichly month k addandance save nai hoti kindly ye cheec smja dain
Great video. Jb mein aik month ke attendance bnata hun or drop-down sy month change kirta hun to wo attendance is month mein b show hoti hy. Is ko kis trha solve kiryen gey?
Informative video bro 1 swal hy mera agr classes 1 ki bjae 2 hoti hen college me same date pe 2 attendance kese add krien gy? Ya agr kisi din koi class ni hy to us ko manually eliminate krna pre ga? Ya agr koi public holiday ajata to us ko kese highlight krien gy , waiting for your response thanks in advance
After fill the sheet if change the month then sheet is already showing last month work attendance. How to showing blank new month sheet. Please reply my comment. Thanks you u are great 👍
Deepak ji time in out format me overtime ke sath ek bana dejiye.... Maine banaya hai thoda error hai.. i required in out and over time as per punching record... Thank you
Excellent! I haven't done any formal computer course but you have explained the topic very easily. I am running a RO water buisness and keeping records manually can you make video on this?
Subscribe New Channel : A to Z Excel
th-cam.com/channels/s4qwt3z81ErKjUE0obmTlg.html
👌🏼💞
Sunday ko double attendence deni hai kaise kare?
Sir mujhe online sikha dijiye..Fee pay krunga🙏🙏
How to make broucher , any idea
Sir आपके इस चैनल पर कब से वीडियो आनी शुरू होंगी क्योंकि excel हम शुरुआत से सीखना चाहते है
और आपकी teaching skill लाजवाब है✔️💯👍🔥
So nice, Sir Aapke sabhi video me naya sikhne ko milta hai jo bahut hi upyogi hota hai. Mai video me di gai tips ka upyog karke apne office work ko smart tarike se kar pata hu. Thank you so much👌👌👌
Sir apki repots bht achi he in
Kindly fully automatic recipe cost ka format tutorial b btein
Aapki ye jankari mere liye bahot helpfull he sir thanku so much
Thankyou sir this video is very helpful thankyou 🙏
Nice video. I learnt two new things.tnx
Bahut hi aachha laga sir
Dear Deepak your vdo is excellent and very helpful can plz guide us when we enter the data in the attendance box in the month of Jan and save the same but the data remain the same in next month (Feb) but actually, that should change.......so plz guide.
I am also getting an equal show, present or absent is not changing.
same complaint frnds
Thanks sir very nice vedio
Tera video dekh raha bhai bahot acha lag raha h.thumbs up
Useful information video. Thanks for your valuable support and update sir
Sir bhot khob .kindly daybook b banay .jis mein yeh b bty ga k jo log aj pasy ly kr gy h.but bill kal ya hafty baad dy gy us ko kasy apni daybook mein rkh
Your method is nice
Thank you very much for this video
Fantastic knowledge.
Thanks
👍
Very good application thanks 👍
Nice video, very helpful.
Your new channel has nothing, no video in it....
Thanks for vidio
Thanks sir
Ase hi Excel document kora debe
Your vedio is So much Helpfull..... and very educational
Thank you Deepak Ji .....
Hi Deepak, thanks for a nice video , KEEP IT UP
Wonderful and very useful video sir,tq so much
Daily wages ke liye A aur P ke saath OT aur Half day per video banao pls.
Thank you dear❤ it help me a lot
Bahut hi shandaar
बहुत ही काम है यह वीडियो। काफी मेहनत करते हो भाई, धयाबाद।
भाई थोड़ी मदद चाहिए आपकी और आप से हो भी जायेगी।
मेरे पास दो कॉलम A और B है। A में 100,200 और 300 लिखा। B मैं मैंने 0,1 और 1 लिखा। A4 में Sum है।
मैं चाहता हूं कि B में 1 की जगह 0 लिखूं तो उसी Row की B कॉलम की राशि A4 से घट जाए।
मेरा विश्वास है आप जवाब जरूर देंगे।
एक बार फिर से धन्यवाद।
Sir...your video very helpful...no suspense.
But overtime coloum also must be included.
एक बाद एक सर का ज़ोरदार प्रहार चल रहा है मेको तो बहुत फायदा हुआ जहाँ मै जॉब करता हु waha mera work flow sabhi se jyda fast ho gai है आज
Badhiya hai bhai... badi mehnat lagaayi hai aapne.. bahot kuch seekhane ko mila hai aapse... koti naman aur dhanyavaad 💐💐💐
Informative thank you very much 🙏
Sir iske alva new practical project jo company and business me use hota vo bhi batao please sir
Really you are superb master in excel 😘😘😘 ❤️❤️❤️
Biggest fan sir mein apka ❤️❤️❤️❤️
your traing is a magic, bro
Zabardast.. good job Brother
Good job brother from Pakistan
Thenks Guru Ji ❤
Great job Deepak Love From Pakistan
Yes, good tutorial 👍
Very gud sir bahut advance hai toh thanks sir
Wow! it's vedio magnificent for us 👍👍
Lovely work Deepak jee
Usefull Info, Zqbardast....
VERY NEEDFULL & HELPFULL THANKS....ONE MORE QTN... SIR IF WE GO TO FILL P OR A AFTER FILL I WANT THAT COLUMN IS LOCKED NO ANYBUDY CHANGE THAT COLUMN FOR SECU.PURPOSE CAN THIS POSIBLE SIR.....
Gajab.... Gajab kar diya bhai.
Good job...quick and easy way...appreciate it and do keep up the good work
Excellent, i learned something new, pls keep it up
Excellent work sir ,thanku sir
Deepak Sir, Bahut Accha aur Knowledgeable video hai ye, But Month/Day/Year Change krna aur sunday lock krne ka matlab kya hua jab month ka data hi lock nhi reh raha, aap january me jo daale hai, wahi data month change krte hi agle me aa jata hai,
Hi, too smart work, but i have one question please, i two days off in a company than data validation formula how for block cell entry... Please let me know. Waiting 😊
Nice channel for learning 🖥 skills
Great sharing!
Many thanks!
Thankyou Deepak
I learned some formulas and formats thru this video.
this is very useful for everyone
Thanks Deepak
Outstanding effort , Respect from Pakistan 🇵🇰
Sir punching time ke according bnaoo attendance sheet, jisme time ho or late time deduction bhi ho
Late time deduction and ot calculations
Sir suppose if cutoff jan 23 to feb 22 so how can prepare excel sheet
Bade utable ho deduct karneme bhaya...!
Thank you Sir.You helped me to upgrade my work style
खूप छान,,,
धन्यवाद दीपक, मैं छात्रों की उपस्थिति के लिए इस प्रारूप का उपयोग कर रहा हूँ। परन्तु मुझे एक समस्या है, जब हम अगले महीने आगे बढ़ते हैं, तो पिछले महीने उपस्थिति हुबहू उपलब्ध रहती है, इसलिए कृपया मुझे स्पष्ट करें।
very goog work sir well done......actully sir ak cheez ki smj nai aa rhi jb hm ak sheet py kaam krny k bad month change krty hain to Attendance sheet wahi rhti hai presence or absence change krny pr pichly month k addandance save nai hoti kindly ye cheec smja dain
this trick is really good for me
Great video sir ji
Very nice sir. 👍
Fantastic bro thanks
Dear sir thanks for this information...
Nd I want same information vertical way is it possible plz advise
Great video.
Jb mein aik month ke attendance bnata hun or drop-down sy month change kirta hun to wo attendance is month mein b show hoti hy. Is ko kis trha solve kiryen gey?
Good job Deepak bhai..
Very Nice Dear.. lekin agr Sat and Sun ko lock karna ho to 2 columns pr kesy formula lagega?
Ek number bhava
I like your video, very useful..
I m from Pakistani punjab
So nice working for students
May u live long
Amazing brother
You deserve more success
Great knowledge sir. Really useful content
Informative video bro 1 swal hy mera agr classes 1 ki bjae 2 hoti hen college me same date pe 2 attendance kese add krien gy? Ya agr kisi din koi class ni hy to us ko manually eliminate krna pre ga? Ya agr koi public holiday ajata to us ko kese highlight krien gy , waiting for your response thanks in advance
Awesome sirjee......
Can be available manufacturing inventory management?
nice video sir
आपका हार्दिक आभार सरजी।
Very good sir 👍
Superb sir 🤟🤟🤟
Amazing 🤩
Plz y koi bata din kh E4 sell ko kon si key push kr ky lok krin mujhy samjh ni a rhi🥺
F4 key se lock honge cells
@@DeepakEduWorld okay sir
Thanku sir for this expensive class
Thank you, this video helped me a lot. Keep up the good work
Sir Month change krte hai to p or A vhi rehta hai vesa hi January ki attendance February me hi rehti hai vo change kesa hoga
Very useful tutorial.
Thank you so much.
Good job
Thank you sir!!
Very nice.. outstanding
You are simply amazing 👌👌👌
After fill the sheet if change the month then sheet is already showing last month work attendance. How to showing blank new month sheet. Please reply my comment. Thanks you u are great 👍
Month ke sath name phone wali table bhi change hone chahiye because agar koi employee chor ke chala chahiye toh but uski jaga attendance show karega
Thank you so much sir 💕😊
Very useful, u hv very good knowledge.
Sir ek tailoring shop k liye data entry software video banayee plz
Wonderful sir
Deepak ji time in out format me overtime ke sath ek bana dejiye.... Maine banaya hai thoda error hai.. i required in out and over time as per punching record... Thank you
Deepak ji autometic admition form par vedio banaye jo autometic PDF me save bhi ho jaye
Good Job
Sir please t separate week off ke bare me bhi batayen
thank you so much from nepal🙏
Thank you for the polite request to put a project link in all your videos
Great effort 👌
Excellent! I haven't done any formal computer course but you have explained the topic very easily.
I am running a RO water buisness and keeping records manually can you make video on this?
please make video for water inventory, water delivery system please