Sir mujhe attendance sheet regarding ek help chiye main aapko kai dafa massage kiye but koi responce nahi aata main janta hu sir aap bussy hote ho isliye plzz aapka koi paid whatsgrop aur channal hai to mujhe link de
Hlw sir School students je liye attandance sheet banani he class wise kese banaye Jisse sabhi bachho ka monthly avarage nikal aaye or poore saal me uske kitne working day rahe
Sir jab hm list mei month change kre to data bhi change hona chiye jaise when I will select Jan, Jan data should visible and when I click Feb then it should be blank , and when I again select Jan there should be Jan data
I learned from you a lot. Thanks for your explained videos. Maine Apni Ecommerce company ke liye 1 interactive dashboard design kiya, Jiski wajah se mai promote bhi hua. 😊 #DeepakEduWorld
Bhai apki video bht zabrdast hoti hain , love from Pakistan 🇵🇰 Bhai mery pas excel mei 6 month ka daily basis pe data hai os ko month by month analysis karna hai let suppose Feb mei kitna kam kiya march mei kiya kam kiya, wo kaisy karen gy is pe b video banao , agr pehly se mojod hai to uska link dey do kindly
On the basis of above attendance data Upload a tracker for maintaining employee weekly target working hrs , extra hours worked in a week, also staff who are woking continuously without taking any weekly day off.
your excel is amezing but mere company ko meine bola ke i am advance at excel no need to buy any software.. but they still going for it. ek din in logo ko pata chalega excel is better then software and faster then software... of course for them who knows excel better....
Pls can you tell me when I change the month the cell entry of each month doesn't change it remain the same like say i enter 8 hours for Jan first day when I change the month the cell value shows 8 only when the month is changed it should be blank or the value for feb
Hi Deepak ji It would be of great help if you could creae a video on HR analytics, i mean a dashboard if an oranganisation is having 1500 employees with 9 COmpanies under their parent company with different locations as branches, it would be a great help for us. Hope you will conisder my request which will help a lot of HR people. Thanks in Advance
Hi can you please explain how to attach a table in body to send automatic email. I watched your video for automatic email but couldn’t find how to add a table without vba. If you can explain this it would be very helpful
Sir thanks for vedio ,mere office me Sundays off nhi hai [ as it is a Showroom] ..so each staff [sales executive team ]has to take week off on different days ..koi Monday lesakta hai ,aur koi Wednesday ya Friday ese ..toh ese situations me attendance sheet kese banana hai ..week offs kese highlight karna hai ..jisse salary sheet bina confusion ya mistakes se bane
Is video me bataya to hai divya g… kaise week off highlight and lock karne hain …. Bas hrs ki jaghe aap A,P use kar saktey ho absence presence ke liye…
Agar weekoffs rotatinal hai toh better hoga ki aap Data Validation se Cells ko restrict na karen. Bas conditional formatting se OD ( Off Day) ko highlight kar den aur Countif se OD ko count kar len
Ram ram ji mujhe ek aaisi sheet chahiye jisme ek column saler ka tatha doosra column buyer ka ho agar mai saler me buyer ki entry karu to saler ke sath sath buyer me ho jay. Please
attendance make need sheet with time in and timeout and overtime and Late then you how make Present and absence. then you make how total hours, late overtime, present, absent, total working day and monthly Salary.
@deepak Bhai please provide formula for overtime where the date starts with 16th Feb 2024 and ends on 15th March 2024 and this continues every month thanks for your assistance
sir aap jab conditional formatting karke format painter use kar rahe ho mere m nhi ho pa Raha mene sheet bhi bilkul exact banae h aapke jesi same to same same coulmn row same formula use but off day par red nhi ho Raha please sir ya koi or Jo ye comment padh Raha h if know the solution pls reply
Jese ki 1000 bande he or DA 6 month me change hone par 1000 bande na change karna padta he Ta aisa koi formula boliye jise ek click me Sare set ho jaye
Isme kuch Aisa ho sakta ki jaise agar hum Jan me koi entry kar rahe hai to Feb me blank ho Jaye new entry ke liye kyuki agar Jan me entry Karo kuch wahi same Feb aur baki ke month me show hoti hai
सर आपने जो ये अटेंडेंस शीट बनाया है। अगर ड्यूटी का समय 8 घंटे है, और कोई भी बंदा 12 घंटा ड्यूटी करता है तो ओवरटाइम वाले कॉलम में 4 घंटा ओवरटाइम ऑटोमैटिक ऐड हो जाएगा। अगर मान ले की आज के दिन कोई भी फेस्टिवल है, जैसे- दिवाली, ईद इत्यादि और कंपनी का बॉस बोलता है की आज आप सभी को ड्यूटी आना है उसका ओवरटाइम मिलेगा। और सबलोग ड्यूटी किया, और अटेंडेंस शीट में 8 घंटे घंटे डाल दिया गया, मगर जो 8 घंटे attendance शीट में ऐड किया गया वह ओवरटाइम में कैलकुलेट नहीं कर रहा है, क्योंकि वह तो regular वर्क डे है इसलिए, इसको क्लीकुलेट कैसे कराएंगे। कृप्या इसपर विडियोज बनाएं। यदि आपको मेरा प्रश्न समझ नही आया होगा तो कृप्या मेरे व्हाट्सएप पर कॉन्टैक्ट कर सकते हैं। Whatsapp no- 9852469250
Dosto kaisa laga ye video 🙏
Sir mujhe attendance sheet regarding ek help chiye main aapko kai dafa massage kiye but koi responce nahi aata main janta hu sir aap bussy hote ho isliye plzz aapka koi paid whatsgrop aur channal hai to mujhe link de
Gracias amigo por compartir excelentes tips saludos desde León Guanajuato México 🇲🇽👌👌🤝
Hlw sir
School students je liye attandance sheet banani he class wise kese banaye
Jisse sabhi bachho ka monthly avarage nikal aaye or poore saal me uske kitne working day rahe
Jaldi video aayega ….
Sir jab hm list mei month change kre to data bhi change hona chiye jaise when I will select Jan, Jan data should visible and when I click Feb then it should be blank , and when I again select Jan there should be Jan data
I learned from you a lot. Thanks for your explained videos.
Maine Apni Ecommerce company ke liye 1 interactive dashboard design kiya, Jiski wajah se mai promote bhi hua. 😊 #DeepakEduWorld
Bht ache se sikhate hain Deepak ji ap
Bht sundr video
Bohat hi zabardast explained
Nice and Aaapka Logo awesome hai. ...dekhne me badhiya hai.
Bhai apki video bht zabrdast hoti hain , love from Pakistan 🇵🇰
Bhai mery pas excel mei 6 month ka daily basis pe data hai os ko month by month analysis karna hai let suppose Feb mei kitna kam kiya march mei kiya kam kiya, wo kaisy karen gy is pe b video banao , agr pehly se mojod hai to uska link dey do kindly
Thank you very very much God bless you and protect you and protect you I needed a French daily sheet
Bahot hi Sundar bhai
You are guru of excel
Nice video sir ji 👍🎉❤
Great Sir,
Excellent 👌
Fantastic video sir
Good information ❤
Sir khatarnak 😮
A very good attendance sheet video sir
You always rocking sir ji 🎉
@DeepakEduWorld Hi sir, very nice and good information ❤
First viewer after you 😂😂😂😂
Suraj Jha
wow great explanation
Very informative ❤
Thanks you so much brother.
Great ❤
খুব সুন্দর
Thank you sir
Nice❤❤❤
Very interesting,sir
Super
very nice
Plz give more different office works in advance Excel ...
Deepakji, ek aur video banaye jismein off days mein bhi kaam hota and usko kaise calculate kiya jata hai.
Hi Deepak, Really helped this video. But I have one question if want to mention hours in time mode then how can we calculate overtime.
Nice sir
Keep watching
Excellent Video❤❤
I want to get "R" in all cell value that have off day
How to do that plz show me
On the basis of above attendance data Upload a tracker for maintaining employee weekly target working hrs , extra hours worked in a week, also staff who are woking continuously without taking any weekly day off.
thanks
Deepak sir bring one video on teachers+class time table in excel
Sir (index+match) multiple criteria with multiple result ka video banaye plz... Multiple result like whole columns and rows or as needed....
deepak ji b2 cell ki jaga hum dossre cells main bhi type kar sakte hai na ?
Looking for advanced excel, pivot table uses macros, dynamic dash board course details
I would be grateful if you make a video on how to use ChatGPT with Excel...
Dear Sir i have need one Automatic shift roster can you teach me.
your excel is amezing but mere company ko meine bola ke i am advance at excel no need to buy any software.. but they still going for it. ek din in logo ko pata chalega excel is better then software and faster then software... of course for them who knows excel better....
Sir Exal Ka Full Course Video Dijiya please.....................
Sir power BI kaise seekhe ???? usko video banao please
सिर्जी आप सचमुछ जिनियस हो
Sir how to get only todays abseentees names in separate column...pls tell me sir...
Hello Sir aapse ek request hai
Money income sheet per hour, per day, or monthly and expenditure detail sigh formula in excel pls 🙏 batayyena. 🙏🙏🙏🙏👍👌
Sir excel me insert tab data tab ka video banao
Pls can you tell me when I change the month the cell entry of each month doesn't change it remain the same like say i enter 8 hours for Jan first day when I change the month the cell value shows 8 only when the month is changed it should be blank or the value for feb
Hi Deepak ji
It would be of great help if you could creae a video on HR analytics, i mean a dashboard if an oranganisation is having 1500 employees with 9 COmpanies under their parent company with different locations as branches, it would be a great help for us. Hope you will conisder my request which will help a lot of HR people.
Thanks in Advance
Project wise attendance with salary calculation kaise bnayi jaye
Hi can you please explain how to attach a table in body to send automatic email. I watched your video for automatic email but couldn’t find how to add a table without vba. If you can explain this it would be very helpful
👍
This one is good but it would be better if there was time taken instead of total Hours and make a salary slip along with hours
Sir mara ek dout haa sir agar hamara store sa alag alag location ma stock jawaga to uski entry kasa hogi
Sir hme 2016 ka ms office chahiye pllzz link discussion me de do 🙏🙏🙏🙏🙏🙏
Please tell me how to highlight other casual holiday except Sunday for all other employees together
Need stock market or investment sheet
Sir thanks for vedio ,mere office me Sundays off nhi hai [ as it is a Showroom] ..so each staff [sales executive team ]has to take week off on different days ..koi Monday lesakta hai ,aur koi Wednesday ya Friday ese ..toh ese situations me attendance sheet kese banana hai ..week offs kese highlight karna hai ..jisse salary sheet bina confusion ya mistakes se bane
Is video me bataya to hai divya g… kaise week off highlight and lock karne hain …. Bas hrs ki jaghe aap A,P use kar saktey ho absence presence ke liye…
Recently attendance sheet ka 1 video or publish kiya hai aap wo dekho or usme ye week off vala logic use kar lo
Thank you Sir
Agar weekoffs rotatinal hai toh better hoga ki aap Data Validation se Cells ko restrict na karen. Bas conditional formatting se OD ( Off Day) ko highlight kar den aur Countif se OD ko count kar len
Jb main countif used kr tha hoon to overtime show nhi kr rha q..?
Ram ram ji mujhe ek aaisi sheet chahiye jisme ek column saler ka tatha doosra column buyer ka ho agar mai saler me buyer ki entry karu to saler ke sath sath buyer me ho jay. Please
Prepare MDM EXCEL SHEET
Sir ji holiday ke liye kya karein ?
Discription mai daal do ye excle sheet
How to set week off sir plz give formula n make it clearly visible ...
Dekh k bataunga
Employee attandance off sheet taiyar kerna
एक ऐसा Drop down लिस्ट बनाना चाहते है जो की हम एक वर्क बुक में काम कर रहे हो। और नाम लिस्ट दूसरा वर्क बुक में हो।
क्या ऐसा बन सकता है क्या।
Sir agar week me ek din off day ho aur agle week me. Usi din over time ho to kya kre
Sir ishi sheet ma absent ka pross batoo plz jaldi
Deepak sir aapke paid channal ka link dijiye
Bhai ma chata hun ma uper sa month chang krn to os month k data har bndy ka samny ajay wo serf date chang kraa ha data nai kraa
Please share the dashboard for productivity of all employees on week base and collect monthly also
attendance make need sheet with time in and timeout and overtime and Late then you how make Present and absence. then you make how total hours, late overtime, present, absent, total working day and monthly Salary.
Fully automatic business management by excell and WhatsApp or Google sheet
Batao brother
What do you need ?
Sir laptop mein Microsoft MS Word kaise download Karen
What do you do when they all have different salaries ???
@deepak Bhai please provide formula for overtime where the date starts with 16th Feb 2024 and ends on 15th March 2024 and this continues every month thanks for your assistance
I using same formula but there is showing ####### not proper date 😢
Plz sir highlight all the formulas starting from Over time to last pl z I am unable to see it clearly plZ sir
sir aap jab conditional formatting karke format painter use kar rahe ho mere m nhi ho pa Raha
mene sheet bhi bilkul exact banae h aapke jesi same to same same coulmn row same formula use but off day par red nhi ho Raha
please sir ya koi or Jo ye comment padh Raha h if know the solution pls reply
When my off day is Sunday it's not getting applied to Sunday, all other weeks are getting red, but not Sunday, why????
Aree sir koi double duty karta hai usse kaise manage kare
Res bro you've shet1,2,3 when in shet3 selecting list off going data validation you opened shet2 not able to open shet2 WHY
Plz send excel sheet
Sir isme maximum present, absent or overtime dekhna h
Jese ki 1000 bande he or DA 6 month me change hone par 1000 bande na change karna padta he
Ta aisa koi formula boliye jise ek click me Sare set ho jaye
Isme kuch Aisa ho sakta ki jaise agar hum Jan me koi entry kar rahe hai to Feb me blank ho Jaye new entry ke liye kyuki agar Jan me entry Karo kuch wahi same Feb aur baki ke month me show hoti hai
Macros use karo aap. New sheet automatically save ho jayega just ek click se
Date value formula not working my laptop 2019 excel
Ishka Excel send kro na
YE LOCK KARNE KE LIYE KYA HAI FORT
Are ye not equal ka sign kaise laga koi bata sakta hi kya
less than and grater than
Full video kyun nahi banate ho sirr
April month ka 1 sales kyun khali rah Gaya...... Pura proper tarike se dikhao Na
Bhai mera if bala formulas kam nhi kr rha h
Why file is not downloadable
Sir windows 7 me overtime hour nahi bata raha hai kyo sir
i always like ur vdoa but i disliked it, banner kuch or h vdo kuch incomplete h.
Sidha hour's ki entry. Sir morning me jate hi office me 8 ghande dalde ye to saab galat h maja nahi aaya
Deepakji mujhe aapka mobile number chahiye.
सर आपने जो ये अटेंडेंस शीट बनाया है। अगर ड्यूटी का समय 8 घंटे है, और कोई भी बंदा 12 घंटा ड्यूटी करता है तो ओवरटाइम वाले कॉलम में 4 घंटा ओवरटाइम ऑटोमैटिक ऐड हो जाएगा।
अगर मान ले की आज के दिन कोई भी फेस्टिवल है, जैसे- दिवाली, ईद इत्यादि और कंपनी का बॉस बोलता है की आज आप सभी को ड्यूटी आना है उसका ओवरटाइम मिलेगा। और सबलोग ड्यूटी किया, और अटेंडेंस शीट में 8 घंटे घंटे डाल दिया गया, मगर जो 8 घंटे attendance शीट में ऐड किया गया वह ओवरटाइम में कैलकुलेट नहीं कर रहा है, क्योंकि वह तो regular वर्क डे है इसलिए, इसको क्लीकुलेट कैसे कराएंगे। कृप्या इसपर विडियोज बनाएं।
यदि आपको मेरा प्रश्न समझ नही आया होगा तो कृप्या मेरे व्हाट्सएप पर कॉन्टैक्ट कर सकते हैं।
Whatsapp no- 9852469250