Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

PTO Tracker: Review & Feature, Fix or Focus Request [Gold & Silver] (Patreon)

Published:
2022-08-24 12:16:00
Imported:
2026-06

Content

Hello Members,

The training we have for this week that I have shared with you was about the PTO Tracker. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

I am looking forward to hearing from you and thanks so much for your support.

Files

How To Create A Paid Time Off (PTO) Tracker In Excel [FREE DOWNLOAD]

🔥GET 250 OF MY BEST TEMPLATES HERE► https://bit.ly/250WKBK-Desc 📢GET YOUR FEATURE ADDED ON PATREON ► https://bit.ly/PatreonDesc 👉SELL YOUR OWN EXCEL-BASED SOFTWARE► http://bit.ly/MentorProgram_YTDesc 👨‍💼JOIN MY INCREDIBLE DASHBOARD MASTERCLASS HERE► http://bit.ly/Dashboard_YTDesc 📣LEARN VBA FROM THE GROUND UP ► https://bit.ly/VBACourse_Discount In this week’s training, I will show you how to how to create this incredible Paid Time Off Tracker in Excel 📣30-HOUR VBA COURSE► https://bit.ly/VBACourse_Discount ⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: 📩 USING YOUR EMAIL: http://bit.ly/PTOTrack_WkbkDl 💬 FACEBOOK MESSENGER: http://bit.ly/PTOTrack_FbDld EXCEL COURSES: ►DASHBOARD MASTERCLASS: http://bit.ly/Dashboard_YTDesc ►MENTORSHIP PROGRAM: http://bit.ly/MentorProgram_YTDesc ►BEGINNERS VBA COURSE: https://bit.ly/FreeVBACourse EXCEL PRODUCTS: ►The Ultimate Excel Resource Guide: http://bit.ly/UERG_YTDesc ►250 Excel Workbooks: https://bit.ly/250WKBK-Desc ►Convert Excel Into A Secure EXE File: http://bit.ly/SecureExcel ►Automate Your VBA Programming: https://bit.ly/AutoMacroAddIn ►Create Dashboards & Charts in Seconds: https://bit.ly/Pine-Bi ►Find the Best Excel Products & Courses Here: http://bit.ly/ExcelProducts Timestamps: 0:00 - Introduction 0:31 - Overview 10:30 - Add New PTO 13:47 - Save and Update PTO 21:38 - Change Event 23:06 - Save and Update PTO 28:17 - Delete PTO 34:19 - Conditional Formatting 40:48 - Employee Detail View 48:53 - Summary View 49:53 - Select Year 54:43 - Select Month 58:50 - Previous Year 1:01:01 - Next Year 1:03:34 - Refresh PTO Summary 1:27:00 - Select PTO 1:28:03 - Load PTO 1:29:49 - Selection Change Event 1:30:56 - Refresh Employee Detail 1:36:09 - Named Ranges Explanation JOIN OUR COMMUNITY: ►Facebook Group: http://bit.ly/groupexcel ►Facebook Fan Page: https://bit.ly/EFF_FanPage Follow me on my Social Media Accounts: 🐦Twitter: https://twitter.com/Excel4Freelance 🌏Website: https://www.ExcelForFreelancers.com 🔗LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ 👤Facebook: https://www.facebook.com/ExcelForFreelancers/ 📸 Instagram: https://www.instagram.com/excelforfreelancers/ 🎥Rumble: https://rumble.com/c/ExcelForFreelancers 👤Locals: https://locals.com/member/ExcelFreelancers ✉Telegram: https://t.me/ExcelForFreelancers 📲Gab: https://gab.com/ExcelForFreelancers About Us: I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money. I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams. Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here: 👉 https://www.youtube.com/c/ExcelForFreelancers/ New Training Video Uploaded every Tuesday! Thank you very much for your continued support, Randy Austin

Comments

Saisulie Sandy

This question has more to do with data analysis. Would it be possible to add more info for each employee? example: total leaves taken on certain days. This way you can track if certain employees are alway taking leaves on certain days.

Saisulie Sandy

Also unrelated question: Can you share macro enabled workbooks? ie having multiple people making edits to it.

Excel For Freelancers

Yes, absolutely that is possible. The leave days are already kept in a database, however you can then analyze the data based on weekdays and any other type of info. I have something very special for this update coming next Monday on this, right here on Patreon, so you won't want to miss it. thanks again

Gary Marden

Hi Randy, currently it is based on fixed working days and days off, would it be possible to add flexible working, that may be 4 shifts on and 4 shifts off or any other roster pattern, also having different shifts during the day e.g. Early, Late and Night shifts. I appreciate this could be done manually but that would be time consuming. It could then be used to approve vacation leave based on staff coverage.

Excel For Freelancers

Hi Gary, thanks for the great ideas, Certainly that is possible. It would take a good amount of work and time to be customize however Excel is fully capable of that. If this is something you would like help with, I would be glad to refer a qualified developer. I hope this helps and thanks so much.

Saisulie Sandy

Hi Randy, Thanks for the Tutorial. It has come in very handy as I am currently building this application for my workplace. I have a question regarding the formula for counting the percentage of people who have taken a leave on a certain day. At my workplace, we have multiple departments. How do I change the formula to output the percentage of people who have taken a leave from a department instead of all departments?

Saisulie Sandy

This is the formula I've come up with so far but I just get a 0. =IF($G143="","",SUMPRODUCT(AND((PTO_StartDate<=K$11),AreaOfWork="Outer Packing")*AND((PTO_Days>=K$11-PTO_StartDate+1),AreaOfWork = "Outer Packing"))/COUNTIF(AreaOfWork,"Outer Packing"))

Excel For Freelancers

Hi and thanks you can use SumIf based on the the department name, so that you can first total how many people are in a specific department, then divided that again by sumif, the total people in a specific department AND who have a specific day off. I hope this helps and thanks so much.