How to Create Leave Tracker in Excel

In this video, I'll guide you through multiple steps to create a leave tracker in Excel. You'll learn about
creating a summary layout, building a tracker list for each month, generating the final leave tracker, and verifying the leave tracker with data. By creating a leave tracker, you can track different types of leave and ensure compliance with leave laws and regulations. With practical examples and step-by-step instructions, you can make a leave tracker in your own Excel spreadsheets effortlessly.

👨‍🏫 Instructor: Eshrak Kader
🎥 Editor: Md. Riajul Islam

✨ ⯆ Resources:
Ctrl+B - To make text bold
Alt + = - To apply the SUM function
Ctrl + 1 - To open the format cells dialog box

▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
0:57 - Creating a summary layout
5:07 - Building a tracker list for each month
21:34 - Generating final leave tracker
23:34 - Verifying leave tracker with data

📚 ⯆ DOWNLOAD the workbook here:

🌍 ⯆ Checkout the article here:

💻 ⯆ Similar Videos:

🚩 Stay connected with us on social media for more Excel tips and tricks!

🙋‍♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.
👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!

🔔 ⯆ Subscribe on YouTube:

#excel #exceltutorial #exceltips #exceltricks

[SiklistangWaray]

I've done it perfectly without error! thanks man!

[mandarTube]

Thanks a ton Eshrak ! thanks for the hardwork

[thandonyaba]

No worries I've just managed to provide myself with the answer, thank you very much for providing such information in a simplistic manner.

[sarojapatra]

Finally it's done now🎉. Thank you Sir for your valuable teachings 🙏 ❤❤🙏

[gideonedeche]

Thank you sir for this amazing explanation. It is really a helpful one.

[sunnychabria]

Thank you, can you please show steps if I want to be able to appply and approve leaves by managers?

[Forthnigt]

Thank you, great video...everything is working perfectly. I have subscribed, for more videos.

[sunnychabria]

Hi tried this and its great, but can you kindly advice if we want to add like a total number of leaves a person is entitled to for a year, yearly entitlement and then when they take the day it should come off that total.

[ravinryandomaoal]

Thank you so much, I followed all steps and have created my leave form.do you have a video tutorial on how to create and send salary slips using gsheets?

[joashemmanuel]

Very helpful. Thank you so much for providing this information, it is very vital.
How about those companies that the annual leaves are based on the contract date? For example, if Peter signs his contract on March 2024, then his annual leaves will start on March 2024 and ends on March 2025. The same applies to other staff who signs their annual contract on different dates and months.
The leaves for each staff starts from different dates and ends on different dates and months. Will this excel works fine to that?

[azazkhan]

Just subscribing because you have replied to each cmt and solve their issue👍👍👍

[inokaranathunga]

Thank you for this. If someone taken half a day leave how to incorporate that to this template. Assume he/she take half day leave from Casual Leave and or No-pay leave

[DenvarMulwale]

This is helpful. What if you don't want leave days counted not to include holidays and weekends?

[ShawneePolchisLanteigne]

This video has helped me so much. I've made many modifications so easily to help with my organization.
Is there a possibility to have ONLY Sick Time and Personal Time count hourly?
Like if they only used 1 hour of sick time, we can calculate it on the same table?

[JuanCamacho-lsz]

Cannot copy and paste the formula for the final tracker "Microsoft office has identified a potential security concern"

[stephenfamiyesin]

very good teaching and really explanatory. I followed all the steps but I found out my summary is not updating even after copying the formular. kindly advice

[Shaks]

Thank you so much, this is very helpful... just a quick question... in case of year change.. do I just change it from 2023 to 2024, and so on?

[Teesh]

Thank you so much for this video. I followed all steps and have created my leave form.
Is there a way to make the leave year match the financial year? April to March? This is the period that my employee's leave runs across.
I would be so grateful if you have a solution.
Thank you :)

[TlhalefoMosoeu-ptfx]

Thank so much for this video.I have one question. I can see the dates and days change depending on the selected year. But how to we handle the leaves taken in different years? For example, if Mary takes 2 Unpaid leaves in January 2024 and 1 sick leave in Jan 2024, I need to see exactly that when I select 2024 and 2025 respectively. currently the data stays the same for different years

[ejss]

at 7:55 my excel doesnt recognise the month from that and after downloading your version it also breaks without even touching anything