Leave Management in Excel | Important for Payroll |

This video is the 2nd part of Attendance and Leave Management, i have explained about the process of leave management and how to create an automated dashboard in excel to manage leaves.
Download Link of Excel - tinyurl.com/ys...
Leave Management
Earned Leave
Casual Leave
Maternity Leave
Paternity Leave
Sick leave
Link for last video:
Attendance Management - • Attendance Management ...

[@prashantdhavale813]

Most valuable knowledge I have received today... Will request you don't stop making such type of videos....I really admire your efforts and the way you elaborating all these things....Keep going buddy 🙏🥰🤘

[@quantumopgaming440]

I have a suggestion, jaha par aapne minimum lagaya h us jahar conditional formatting k use kre agar opening se jyada Sl,Cl,El ho rha h to red background kr dega jisse clear ho jayega ki yaha wrong h, aise me EL,SL,CL kitna bhi likh de waha Taken leave me to minimum hi count ho jitna jitna opening tha.

[@shahbaz2w]

Hi, Thank you for the useful video for leave management syncing with attendance. I understood all things except dashboard kindly brief dashboard making for more than 10 employees like 15 employees. I have added 5 more employees in your sheet but dashboard not picking up that employees.

[@MukeshKumar-zp1ru]

Sir bahot achha laga Dash bord kaise banaye iska video share kariye sir

[@siddharthsuman297]

ये आपसे humble request hai ki please apne dashboard pe vlookup ka formulae kaise implement kiya hai.Wo bas ek dafa bata dijiye sir

[@inspiredmate]

Aap is niche diye gaye video link par click kar ke V-Lookup seekh sakte hain. kzbin.info/www/bejne/jXKlpmyJbbGXqKssi=vmNf1HM1-B5hXkib

[@sakshamcubesolution5904]

Sir if yuh rest not counted it means there is 3days ruled applied which is called ( Sandwich rule you should count rest according to 3dys rule) not as Absent mrk.

[@sourav007ism]

You r doing good job Continue this HR series Bahut jald subscribers or views bhi badhne lagenge.... Bs continue rakhna brother...

[@inspiredmate]

Thanks for your comment, surely i'll keep posting..

[@jaggudada8629]

Very clear explanation

[@subbiahrajendran933]

Very useful video. I am from Chennai. Please teach me how to create dashboard for leave balance. I am beginner

[@ebenzershroff5354]

Very good.. Subscriber❤👏👏👏👏

[@Vindhyakashyap]

If an employee is joining on 10th how the attendance for him will be calculated for entire month?? Can u pls explain which formula to be used in such case

[@subbiahrajendran933]

When will you provide leave balance using vlookup sir. I am eager to learn & use it in my new center.

[@learningsoul8292]

Sir plz clear my one more doubt...........Aap previous attendance sheet me PAID LEAVE ke bare me bataya tha, than in this sheet you taught us how to udjust EL, CL,SL in Absent. Pr agar Employee ki Leave hai to wahan to El Cl, sl ki likhenge na. Absent me to EL, CL, SL adjust karenge but agr kahin LEAVE hai to wahan kya likhenge

[@powertechenterprises1847]

Very informative video. Keep it up.

[@HiteshSharma-ti1km]

Valueable info Thank you

[@anmoldubey5187]

Please make video on this vlookup dashboard 🙏🙏 and thank you so much for ths most helpful videos. Please please I really need this vlookup dashboard please make a video on that

[@inspiredmate]

Will upload the video soon..

[@farzanamengal7754]

Sir mjy earned leave or casual leave cal karne karna ha or balance be jesy agr employee k total casualleave 24 hs to agr ma ak employee k lay leave add karo to mjy batahy k remaning balance itna ha availed itna keua ha mjy formula chehy is ka

[@bharathinaveenachandra3849]

Sir the format is great. Can the same be done with linking biometric attendance.

[@sanjeevfernandes8280]

Bro, I want to make an annual leave plan for our employees. Most of them will go for 3 to 4 months. I want to make it the starting date, month and end, and total days.

[@babitaverma3868]

Can leaves be clubbed with Sunday. My organisation deducts salary if clubbed withe declared holidays

[@pritamghosh5334]

Sir . I wat to know how cal i count leave balance in next sheet. I mean to say that i want to copy leave balance in next month. Please give your suggestion

[@khushimishramishra4948]

Very nice sir❤

[@shitalswarup1222]

Sir I want To extract only dates of leaves like EL, CL SL employee wise , how can I do that

[@PARMINDERSINGH-gt3ug]

श्रीमान जी अगली वेडिओ इ पी एफ पर बनाने की कृपा करें ई पी एफ रेतुर्न कैसे फ़ाइल होती है चालान कैसे बनता है कौन कौन से एकाउंट में पैसे जमा होते है।

[@siddharthsuman297]

It's a request if you could explain in Zoomin mode words r not clearly visible.

[@BuddhaMayaTAMANG-yp1rk]

Thanks sir

[@amitkumardutta4122]

Great Sir 👌

[@vipulpatel9425]

when El more what is the reflect? for ex EL 6 OR TOTAL A 12 ?

[@urtaghalkhan6624]

Sir Narendra khurana ka CL adjust nahi hua. Jbhi loss of pay araha hai jub ka Waha Apne CL feed kia tha. Min formula mere pas kam nahi karha.

[@SoniDixit-oz4ib]

Sir very nice bt banega kaisa wid formulla bata beginners samjh nai pate

[@SurenderKumar-pl1ty]

वेरी नाइस

[@tnpanda27]

Brother opening balance leave adjust or closing balance ye kaise nikale

[@deependra008]

Sir....please make video in different payroll report

[@thankmol5669]

Good brother

[@sarthaksamal2412]

Kindly share this link format

[@MAFIA_gaming850]

Private company ka leave apne mobile se kaise check kare

[@rahuls024]

i want to count the words like {"PL","HOL","CFL"} as 1 and {"HD","CFL-HD" } as .5 appearing in a row if the date on the other row is greater than today() also if the date is less than today()

[@mimikumari7754]

Paid leaves kya hota hai

[@navyakrishna3315]

I want this excel format andi

[@learningsoul8292]

Share the formula for closing balance of leave mgmt

[@inspiredmate]

Opening Balance - Leave Adjusted = Closing Balance

[@learningsoul8292]

@@inspiredmate I did the same, before receiving your reply ......😀😀 Thanks again

[@makwanasadevant2218]

ANY PH HR COMPLIANCE SOFTWARE AVAILABLE

[@ameerkhan2310]

Next video on this dasboard

[@ameerkhan2310]

Pls Provide Vlookup Video link

[@learningsoul8292]

Why you have not showed the formulas clearly. U defined it but your sheet is very small as well not showed the formula ..........

[@inspiredmate]

Try increasing the resolution 720p, formula's are visible clearly, i will keep in mind to zoom in at formulas..

[@learningsoul8292]

@@inspiredmate thanks alot , i learnt many things from you . Thanks for your efforts

[@inspiredmate]

Ur welcome..

[@ameerkhan2310]

Sir kindly provide next video

[@beerakumar6987]

But leave adjustment don't approved HR🤣

[@bikashnath3633]

Can you please share format

[@inspiredmate]

added the download link in description

[@somyakantibs]

Why HD divided/ 2?

[@inspiredmate]

To count it as 0.5

[@Rani_singh161]

Payroll kaise banate

[@dontrimp1664]

U have not explain hownu integrated the balance amt with the leave data.. Not a very good vdo

[@learningsoul8292]

Sir , IF CONVINIENT can you plz share your mail id , i want to share sheet prepared attendance as well payroll..........Just want you check it , so that i will be confirm with my practice. Thanks

[@inspiredmate]

Please share it on [e-mail]

[@RiktaRakhit]

BEKAR si video bs kya kara ye batya , kaise kya wo nahi , Formula batana hota h . Next time is chiz ka dhyan rakhe

[@inspiredmate]

Ji Malik Dhyan Rakhunga..🙏 maaf kar dijiye..🫡

[@aap9098]

🙏🙏🙏

[@pawanpathak9598]

Sir good morning Ye sheet aap maill kar dijiye [e-mail]