How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi

How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi - Doston is video me maine Bataya hai ki kis tarah hum Excel me Attendance Register aur salary Maintain Kar sakte hai bilkul hi simple tarike se. Hope aap sabhi ko video pasand aayega.
Download Excel Sheet for Practice - drive.google.com/file/d/1YFEj...
Buy Our Complete MS Excel Course in Just Rs 499 Visit - www.mylivesupport.in/
❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
Please support me on
Like us on Facebook - / mylivesupport
Website - mylivesupport.in/
Follow us on Twitter - / mylivesupport
Follow us Instagram - / mylivesupport
Facebook Myself - / chandankumar926
KZbin - / mylivesupport
▶️WATCH ALL VIDEOS FROM BELOW PLAYLIST :
▶️All Video for MS Excel Magic Trick Series - goo.gl/qS296Q
▶️All Advanced Excel Video in Hindi - bit.ly/2Ej6Viy
▶️All Computer Tips and Tricks Video in Hindi - bit.ly/2Pj70Ji
▶️Top 10 Excel Video in Hindi - goo.gl/McEe53
▶️All Videos of Excel in Hindi - goo.gl/boUo8C
▶️All Videos of Technology in Hindi - goo.gl/E9VyCA
▶️All Videos of MS Excel VBA in Hindi - goo.gl/W4pb5t
▶️All Videos for Tally.ERP9 GST in Hindi - goo.gl/CbsFhr
Most Useful Videos of Our Channel - Must Watch
▶️How to Convert Handwritten Notes in MS Word using Google Drive | Hindi Tutorial • How to Convert Handwri...
▶️How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi • How to Maintain Attend...
▶️Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate • Make Fully Automatic G...
▶️🔥How to Recover Unsaved MS Office Files | Excel | Word | PowerPoint without any Software 🔥 • 🔥How to Recover Unsave...
▶️Excel में किसी भी Sheet को Print करो Expert की तरह | Become MS Excel Expert • Excel में किसी भी Shee...
Our aim behind making this channel to make you expert in Microsoft Excel, Microsoft Word, Tally.ERP9, Computer and Technology. You can easily learn Excel, Word, Tally, Internet, Computer in Hindi language. So don’t forget to Subscribe Our Channel.
maintain attendance register in ms excel, maintain salary sheet in excel, wages sheet in excel, salary sheet in excel,excel attendance register, fully automatic attendance register in excel, prepare attendance register in excel,prepare wages sheet in excel,calculate wages in excel,calculate salary in excel,salary sheet in excel,excel, excel tutorial in hindi,excel tips,excel tricks,advanced excel,ms excel for advanced,advanced excel formulas,advanced excel function,
---------------- Chandan Kumar ----------------

[@MyLiveSupport]

Main is video me bata chuka hu agar hum formule me 0.5 nahi lagate to 4 half days hote. maine formule me 0.5 isliye lagaya taki jo half days hai wo full day me convert ho jayein aur hum per day salary calculate kar payein. 4 half day matlab 2 full day second example 50 paise+50 paise+50 paise+50 paise = 2 Rupees, am i right sir,. Agar phir bhi apko meri baat nahi samajh aayi to mujhe is baat ka dukh hai. ek baar main phir se clear kar deta hu aisa maine isliye kiya taki hum per day salary easily calculate kar payein. thank you - Sheet link for practice - goo.gl/xQQPZ6

[@dartechnosolution3052]

, Nik Bakers 1 to 50 1 to 15 ok Search inter

[@vivekjhanwar04]

over time k liye provision kya ho sakta hai??

[@rakimondal575]

145360.00 how much in word????

[@muhammadumerkhan1963]

Or 5 half ho to

[@al-mamunmithun7662]

U didn't use absence cell ... Why ????

[@MyLiveSupport]

Excel Sheet attached kar diya hai taki aap log practice kar sake - goo.gl/xQQPZ6

[@childrensactivities3174]

My Live Support Thanks

[@bapunmahanta979]

Jhakas bro

[@prayagchaobey7015]

Excal

[@prayagchaobey7015]

Microsoft Excel

[@arjunbhattarai1889]

I am very thankful to you and appreciates, please guide me for keeping accounting and other records, that is very supportive that you provide excel format too.

[@MyLiveSupport]

You can do it with excel

[@AyushSital]

बहुत बढ़िया भाई इतना अच्छा से आज तक किसी ने नहीं बताया होगा भाई । सुपर

[@sunnybachpanvideo]

Sir apne bahut आसानी से समझ गया थैंक्यू

[@pivotgamer5270]

You are just awesome, the way you taught is excellent. We are very thankful that you did this amazing video. Best teaching 👌😊💐👍🏿

[@MyLiveSupport]

Thanks 😊

[@HarmanSingh-jb4ff]

very knowledgeable

[@sureshchandrajena9134]

Thank you so much.Excellent tutorial.

[@ayeshabegum6345]

You explanation is very clear.Its help me a lot , thnx.

[@satpalbishnoi7043]

Great trick told sir. साल के End में 10 लाख allowance बांटना है कम्पनी मे दिनों के आधार पर लास्ट में कर्मचारी नाम, पे-स्केल, कुल हाजिरी तथा अन्त मे इन्सेन्टिव राशि show only. साथ मे फाईनल शीट मे एक लेवल के कर्मचारी अलग अलग show हो जैसे बेसिक पे. Attandence Days. भत्ता(6%of बेसिक पे) 10 GM 5 DGM 50 Sr Engineer 100 Engineer 40 Junior Enginerr 70 Technician 5

[@baljeetkumar3586]

Ap sort kar le us column ko jisme apne designations dali ha

[@vishalsrivastava8539]

@@baljeetkumar3586 you and that

[@mukeshkumaryadav6546]

Thanks for learning me Bro..

[@learningschool2315]

kzbin.info/door/6qz5RjzNKRRzrpVAF46bFg?view_as=subscriber please subs back

[@dipendrasingh745]

Thank you So much sir.. Bahut jankari mili aapki Iss Video se..

[@sumankushwaha9927]

Thank you so much. Excellent tutorial video.

[@AMAZ32]

Great Effort from Pakistan

[@munishsingh5837]

OK bhai thanks

[@hemareddy8376]

Very useful vedio bhayya

[@omranjit3350]

very Useful Video, Thanks from Kathmandu, Nepal

[@rupalisingh3822]

Thanku you so much!! Very informative....easy to understand Keep it up....good job

[@MyLiveSupport]

Thanks bro 😀😀😀

[@shivanirajput1692]

Sir pls add pf deduction cell

[@krmotion1522]

Best video in excel..... I Like a master file in Excel but I m not make it........ please can you make it master file this sub 👉 like product order list . ( Hint :- sheet 1(master sheet) all products details or rate / tax value Sheet 2 is order sheet......... Sir is the amazing trick....... Plz make it

[@MyLiveSupport]

Ok brother i will make video on thia topic very soon

[@lathakumar8288]

Super easy and simple thakyou

[@gagantyagi2167]

Bohot Bohot badhiya bhai thanks so much

[@rupasonam9988]

Bahut Acha samjhaya sir aapne thanks for this.

[@technicalbusiness8312]

Hr excel se releted video banao sir

[@PRADEEPkumar-bn6jf]

Sir, pf ka bataya nhi

[@magbulmansuri4636]

very nice information

[@MyLiveSupport]

Thank you sir for your valuable comment.

[@SunilKumar-jm2ec]

Pf option skipped but under stood it will same deduct from gross as per norms of pf deduction 12.5℅

[@abhishekchouhan7908]

Thanks you sir bhot hi ahccha video banaya hai aap ne 🤟

[@amandeepgambhir6556]

THANKU SIR AAP SE BHUT KUCH ACCHA SEEKHNE KO MILA HAIN.....

[@DileepKumar-wx1dv]

Dear sir How can menassion of over time labour Exm.4 hrs per day over time

[@itsyourfriendgaurav8056]

Kindly mention EPF deduction in salary sheet

[@chittu7764]

Bhot achha btaye sir ... thank you so much

[@vishnuseth784]

Bahut sahi samjhaya Bhai.🙂🙂🙂🙂

[@sonia7361]

Hello Sir , i liked your video, but in video your forget to deduct of employee EPF contribution of 12 %

[@sunilsharma-up8lh]

Excel me formula kaise banate hai

[@ajaygangwar4071]

Ek dum bindass sir g🙏🙏🙏

[@mohdnawaz2388]

MashaAllah superb bhai

[@shivanipal7875]

Sir data entry ka complete course kra do plz sir excel me

[@hemantraj8792]

Over time ko kaise maintain kre

[@kareenamawase890]

Superb sir maind blowing 🥰

[@Shyampilot]

Thanks bhai aapki video achhi lgi Attenden sheet Banana A gya mujhe

[@deepasunith137]

Very good explanation . why not calculate pf and employer contribution in esi also.Please show this also

[@Itsdipu97]

Sr pls provide all excell videos in sequence starting from 0 level .... In playlist i m confused that which video i have to watch first. Because i have just started to learn excell..

[@ajaybhagat4855]

Pleae also show Epf &Eps calculation

[@prashantkamar9209]

GZB. HAI BHAI BAHUT ACCHA BATAYA HAI 👏👏❤️❤️

[@kailashtiwari985]

Great... Knowledgeful ... With the comprehensively....

[@saurabh...6693]

Sir aapne bina conditional format use krke sunday colum highlight kiya .lekin har month sunday alag date ko aayega to vo automatic nhi hoga so please sir condiational format ka use krke ek video upload kijiye

[@AbhiSharma-wp1xx]

U are right bro but ye to sirf samjhaane ko banaya hai shayad usne ye wala video.

[@lavkendrakushwaha7224]

@@AbhiSharma-wp1xx ijnn nnnnnnnnnnnnnnnnmñmmm.,.mm.mnnnnñnnnnnnnm...mm..mmm. .. . M.m .mm Mmm.mmmmmmm.o .mm..m nnn.m.mmmmmmm.mmm,mmm ..,.mmm.m.mmmm.mm..m...m.m.m..mmm.mmmmmm.mmmm..m.mm..m..mmm..mm.m.mmmm.mm.m.mmmmmm.m.mmmmmmm.mmmmmmmm.mmmm.m.mmmmm.mmm.mm.mm..m.mmmmmmm.,mmmnmmnn.m ...........? .. . .m..m.mmm................ .............................. .......

[@mubasharyaseen2693]

Sir agr jin ko salary pay kr di ho onko alag kesy karna ha

[@statusitem]

Es par video banao

[@Shivshankar-ie4ku]

Thanks sir bahut achha lga msg video

[@arshsingh2577]

Sir Thank you so much very helpful 👍🏻👍🏻

[@satishkumarsonu3936]

SIR G FORMULA THODA ARAM SE BATAYENGE TO ACHHI TARAH SE HAM LOG KO SAMAJH ME AJAYEGA THANK YOU.

[@debrajmondal472]

R a year kisi ko v sir bol deti ho.

[@debrajmondal472]

Tum khud kar nahi sakte ho.dimak lagao.help option mai sob dia hua hai.pc ka matla bi hota hai.tool k use ko sikho bas dimak lagao or aage baro.kya karte ho year

[@debrajmondal472]

Kya kar rahe ho.dusre ko pysa deti ho.khud kamao dimak laga k

[@debrajmondal472]

Mai vdo ki tle dekh k cmnt dekhta hoo.bas ghum jata hai dimak.r a year so cho.15.sal pehe har hat mai ph ya pc na the.tab lok kyse excel word sikh k aaj high high cmpny pe job karte hai.r a yea log budfhu banate hai.mera ek chanel tha.band kar dia.yea sob dekh ke.mai grphc dsng hoo.yea sob sikha tha pehele.in logo se v achhi tarha.mehenat karo sikho.khud ki dima k se kuchh nahi hai

[@debrajmondal472]

Math ki book pe sir ak math dokh k boltha tha baki kar k aana.kyse kate the usko.

[@azabgazab3020]

Sir mujhe per day attendance ke shaat ot bhi calculation krna pdta h Aise me kya formula aur kaise use kre Plz help me soon as well as possible. Thank you lot.......

[@shayamsunder318]

Sir ap ka whtsp nmbr mil jayegA

[@mohmmadmaqbool2646]

@@shayamsunder318 .9906438736

[@durgeshwarisen6789]

Superb knowledge sir

[@kunalprabha1980]

Superb...sir... Thanks

[@Manishkumar-fc5hb]

Sir agar hour ke hisab se salary nikal ni ho to kaise krenge

[@MyLiveSupport]

Very soon i will make video on this topic

[@deepg1552]

I m waiting

[@swingtrader6118]

Devide the answer by working hours eg 6 or 8hours

[@rohitmane8347]

Convert it into 100's to do calculations

[@ajazmir1739]

Basic salary /total days of month /total hours

[@djsantoshsanjeet2686]

formulla ko banana parata hai yadav bana banaya aata hai sir

[@learnearn4949]

Excel me already formula rahta hai

[@omkarshende2557]

Bahut accha laga aapaka ye video

[@manjeet4572]

Thankiuuuuuuuu very much sir bhott ache se samj aa gyaaa

[@mithastudiobyshiva4027]

wt abt pf

[@wanizahoor3161]

@@agrawalboy6288 total salary*%\100

[@mkjacktechnical6811]

U don't know sir, how many important for me ....

[@MyLiveSupport]

I know it😀😀😀

[@v.nageswarrao8518]

Excellent sir your teaching

[@pradeepkumre5015]

Bahut hi best tricks sir ji

[@ghurahuprasadyadav3798]

आदरणीय सर, आपसे मैने पूछा था कि , यदि कर्मचारी की ड्यूटी १०:०० से १८:००शाम तक है । और बायोमेट्रिक अटेंडेंस लगता है । तो किस प्रकार हम अटेंडेंस को करकुलेट करेंगे । क्या फार्मूला लगायेंगे ।बाकी सभी बातें समझ आई और प्रयोग भी किया ।हाफडे , उपस्थित, अनुपस्थिति, साप्ताहिक छुट्टी या हांलीडे। किस प्रकार निकालेंगे। अहम समस्या जैसे , टाइमिंग का है ।१०:००से १८:०० शाम तक। यदि कोई १०:३०,१०४५ या १०:५०को आया तो । सर जी कृपया इस विषय पर मदद करें।

[@MyLiveSupport]

Sir aap ye video dekh lo kzbin.info/www/bejne/oZSWh4eZeKmgmsk Aur main apse bahut chhota hu isliye आदरणीय शब्द का प्रयोग न करें

[@Physicalacademy585]

bhai age se koi chhota bada nahi hoto aapne kaam se hota h

[@chanderdiwan3685]

Wrong calculation of days. Total number of presence, absence, half day, off has to be equal to total number of days in a month which is 31. But in maximum cases it is not equal to 31.

[@nancygupta355]

Thanku.....so much for making this video

[@keilyanisanasam8824]

Tq, Its made me very useful and makes me understand easily.. Thanks alot

[@Zain_ul_abideen1214]

*ESI* --- ???? Abbriviation ?

[@MyLiveSupport]

Employees State Insurance

[@razibalom5355]

DADA How can I print this document. It needs 2 or pages to print. is it possible to print it in one page? or is there any other way. Please help. Thanks

[@Abhishekkumar-wf3mi]

Bhai mere tumhaari baat sahi hai par pf to necessary hota hai aur muzhe pata nahi kis company mein hra milta hai par mein to jaha tak dekha hai lagbhag sabhi companiyon mein pf kat ta hai aur sarkar bhi pf mein yogdan deti hai but sawal yaha ye hai ki jab aapko hra aur pf dono method pata tha to apne logo pura method kyon nahi bataya inlogo ko to pf ka formula nahi pata unko to adhura gyan de rahe ho aap

[@akram7890]

2

[@sejalstudiocybercafe1758]

Sahi bole bhai aap

[@akashsabat4093]

Pf mention nahi kiya ha??

[@fitterkijankari7405]

Lovely video### very powerful video

[@rheajobin06]

Thank you sir for help!!

[@mantoshkumaryadav8604]

GST project

[@shraddha.1131]

Bahut acha samjaya aapne thx

[@rahulkumarsah9925]

Dost sahi hai important video hai

[@dineshtirkey7851]

bahut hi acha explain kartey ho ap

[@EXPLORINGPIPING]

Simple and awesome bro

[@jahangirshekh4801]

best sir ji I am very satisfied

[@rajpanwar11]

बहुत अच्छा वर्णन।

[@savipatel3777]

Thank you brother aapane bahut acche se samjhaya padhte time yah point mujhse chhut gaya tha

[@ranjeetkumarmahato1176]

बहुत ही अच्छी तरीक़े से समझाया गया है।। देखकर अच्छा लगा।।।

[@MyLiveSupport]

Thanks 😊

[@KD_Singh566]

superb video.

[@dilare11]

What a fantastic video brother

[@farooqsheikh7371]

Very help full thanks for info bro from Pakistan 🇵🇰

[@rajeshchoudhary2520]

Thank you so much Sir, nice video

[@pogogaming5037]

Thank you sir i am new for excel your video is good

[@parvezmiah4706]

SO MANY THANKS FOR THIS VIDEO

[@varunhaldar7052]

Very helpful video... Thank u #Chandan bhaiya🤘

[@vinodsharma-91]

Mere priya sir aap ne bhut hi accha formula btaya hai

[@RajeshBhangara-bq1ti]

Very nice video Bhai Jaan Ase hi video banaye or shikhaye Thank you so much sir

[@EuropeTravel_305]

Very good video sr Thanku

[@sanskari287]

Bauth acha video tha thanks

[@nitingupta5732]

Very informative video.

[@chouhansatish6276]

Nice information sir ji 🎉

[@GauravSharma-bd1ig]

Very helpful 👍

[@chetnayadav7519]

Very nice. Bahut accha explanation

[@MyLiveSupport]

Thanks 😊

[@rich.bakers5587]

very nice information awesome formula ......

[@syedfirdaos1552]

Thank you sr, I was looking for the simple format. It helped me alot.

[@dailypdo]

Thanku sir ji 👍👍👍👍👍

[@Aryanpandey1230]

Thank you so much sir🙏🏻🙏🏻🙏🏻

[@aforaaru2903]

Very helpful 👌

[@kuldeepactor6526]

Bahut badiya sir

[@KashiKhan]

Superb Bro...nice vedio love U

[@sugdamandi7285]

Thanks sir👌👌👌

[@sanjaynegi1805]

Superb!!!!

[@satabdiroy5339]

Excellent video

[@iffuwrites6290]

Absolutely true!

[@reenasharma7748]

Sir aapki video bahut jada osm thi