🔥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
Дата на публикация: 26 август, 2022
Категория:
Друго