How To Create An Employee Training Application In Excel [FREE DOWNLOAD]
ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 2024
- 😎 BUILD YOUR DREAM CAREER: LEARN FREELANCING, BE YOUR OWN BOSS - UP TO 65% OFF! 👉 rebrand.ly/FreelancersAcademy...
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🔥GET 300 OF MY BEST TEMPLATES HERE► rebrand.ly/300Wkbks_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN TH-cam MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create a complete training management application in Excel, including unlimited employees and training, and scheduling with a month-view scheduler and navigation.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/EmplyTrningMgr_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 300 Templates In 1 Zip File: rebrand.ly/300Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:44 - Overview
5:05 - Worksheets Design
51:16 - List Trainings
59:04 - Selection Change Event
1:00:26 - Load Training
1:02:53 - New Training
1:03:49 - Save and Update Training
1:11:19 - Delete Training
1:19:50 - Refresh Schedule
1:34:54 - Training Select Schedule
1:36:27 - This Month Schedule
1:38:57 - Previous Month Schedule
1:39:38 - Next Month Schedule
1:42:44 - Add Attachment
1:49:26 - Refresh Attachment
1:54:07 - Selection Change Event
1:55:47 - Display Thumbnail Attachment
1:59:02 - Open Attachment
1:59:42 - Delete Attachment
2:02:22 - Change Event Worksheet
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/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 this 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:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#excel #vba #employees #employeetraining
![อาจารย์ยอด : พระเตะผี [ผี]](http://i.ytimg.com/vi/zusDOIFasaE/mqdefault.jpg)
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
thumbs up from the beginning of class for the most passionate VBA teacher on youtube, the kindest, quickest customer service. Thank you for all your hard work, valuable time Randy for helping our lives much easier
Thanks so much Tammy. I appreciate and love each and every one of your comments. Thanks always for the continued support
Happy to be here! Congratulations again on your win 🏆
Thank you so very much, I really appreciate that Naomi :) :)
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed and thanks for your continued support.
As always, you're the best of the best. Excellent.
Thank you so very much, I really appreciate that Tom
Great Tutorial as always. Thank you
Thanks so much. I am really glad you enjoyed this
This is super impressive. Thanks for sharing!
Thank you so very much, I really appreciate that and so glad you enjoyed it
God bless you. You really teach us in very detail manner. Really appreciate it. Thank you so much~
Thank you so very much, I really appreciate that and I am glad that I can help
Now this is magic!
Thank you so very much. I am really glad you like it.
The way you work with excel is brilliant, you do an excellent job, thanks for sharing so many examples.👌
Thanks so much. Very kind of you Rod. I am glad you enjoy it
We'll be waiting
Great, thanks so very much. I appreciate that
THIS IS VERY USEFUL
Great, and thanks so much. I am glad to share it.
Thanks 🙏 a lot for sharing knowledge, experience, it has been very helpful for me to improve my excel skills...
Great thanks so much. I am happy to help and share
Really appreciate it.
God bless you
👍💐
Thank you so very much, I really appreciate that and you are welcome
you are amazing Sir....
Thank you so very much, I really appreciate that
Good work
Thank you so very much :)
I love your intellectual
Thank you so very much, I really do appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
Thanks!!! for great explanation, please always keep explaining detailed and extended step by step , if something is to easy for someone they can always skip ahead.
Thanks for the comment and it is a great point. If someone has watched many of my videos, they may see similar formulas and features, however for those who have watched less, it is important for the detailed and slow explanation. Thank you for your Likes, Shares & Comments. It really helps.
Iwork for a non-profit and have been asked to create a Training Manager for the upcoming year. I found this video and it seems perfect for our needs. I was wondering if you had a template I could download. I've been trying to create this from the video, but it's been challenging cuz I'm somewhat of a novice and you speak really fast. Anything you can provide will be helpful.
Hi, you can download this file for free using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
good work
Thanks so much. I am glad you enjoyed it.
your vedio is so good. 😃
Thank you so very much, I really appreciate that
You a bad Excel mama jama! 🎉
:D :D Thank you for your Likes, Shares & Comments. It really helps.
I love all that you created but i wish you advanced search combobox upon string changing..... Thank you
HI and thanks so much Dr. Hamza, I will try to get this added on our Patreon update next week here: www.patreon.com/ExcelForFreelancers
Thank you for your Likes, Shares & Comments. It really helps.
thats great...would you please create a playlist...for vba basic to advanced for those vba code😊
Hi and thanks so much. I do not to too much basic VBA, however I will be reorganizing my playlist in the near future to help with that . Thank you for your Likes, Shares & Comments. It really helps.
Thanks so much for this tutorial its great! Lets say I wanted to add a training matrix tab to this, what would you recommend? By training matrix I mean a sheet to show all required training and each employee's training status (incomplete, in progress & complete) basically to show what training is complete or still required for each employee
Hi and thanks for your message. You can incorporate a dynamic skills matrix or similar for your application. I have a training on that here: th-cam.com/video/rVQUNZ_zW9Q/w-d-xo.html
Great lesson! How did you build the custom color picker to change the cell background color?
Hi and thanks for your comment. The custom color picker is just a bunch of rectangle shapes grouped together, then named and hidden. It is just displayed when i select on specific cells.
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you!!
The way you work with excel is brilliant, you do an excellent job, thanks for sharing, but you talk very fast
Thank you so very much, I really appreciate that and happy to help and share
good greeting
I want you, if you please, to complete a program on Excel for literacy and adult education.
I would be grateful to you. Your work impressed me.
HI and thanks for your comment. This would be a custom application, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
Hey from AUS, I love your videos and specially this one being able to use it in my new role at work. I have tried to edit and mold your training manager then import it at work, the problem is that when i open the spread sheet non of the macros work because of the level of internet security we have. Is there anything I can do to work around this to have all the macros and coding to work ??
Thanks
Hi and thanks very much for your message. My trainings and workbooks almost always include macros so you may want to request your work allow these types of workbooks or use them at home. These workbooks are safe and are used by millions around the world.
It would be interesting to create a spreadsheet to make for clients of accounting firms with management of accounting processes and tax and other obligations, schedule of obligations, summary tables....
Hi and thanks so much. I do have a full-scale accounting application here excel-books.com/
I hope this helps and thanks so much.
I wonder if those Gantt shapes are drag-and-drop....that would be epic
Hi and thanks for your comment. I show you how to do that in this training:
th-cam.com/video/VrwFrfJWNOM/w-d-xo.html
I hope this helps and thanks so much.
Great video and downloaded the file and reworked it to use in my job. Really so handy. But wouldn't there be a possibility that if an employee starts 2 trainings at the same date, that it is visualised in the schedule separately instead that it is only visible for 1 training? If they have both same begin and end-date you lose the overview. That would make it even better for my application.
Hi and thanks so much. Yes certainly it is possible with one of my hourly or task schedulers. Please check this playlist for one that fits your requirements: th-cam.com/play/PLIBeRriXvKzD3jWDnf36RZ4AfhWFONTy5.html
I hope this helps and thanks so much.
Thanks a lot sir, i m following you from long period of time. i learned a lot from you. i have created a work managment system in excel, with less VBA but more excel formula. i wana share with you if you can create more better application for our work. it will me a lot. can you please tell me how can i send it to u.
For sure, you are very welcome. I have a Work Order Management coming in 2 days here: th-cam.com/video/PCkoUgXGJQ0/w-d-xo.htmlsi=o6Mg2k9GVoRhb3nO
I am sure you will enjoy it. Thank you for your Likes, Shares & Comments. It really helps.
So I've been following this as best as I'm able and while there were hiccups I've been able to make it all work the way you've shown it. However you've got several spreadsheets that weren't shown on how they were made. Do you have the other spreadsheet how to's somewhere on your channel or are the supporting worksheets left to be figured out by us?
Hi and thanks for your comment Kyle. I am glad you liked the video. Someitmes I am unable to show everything, otherwise the training would be several hours. Which particular sheets did you have in mind, as I have over 400 training videos on my channel?
Thank you for your Likes, Shares & Comments. It really helps.
I was wondering if there was a template for a simplified version of this? I have about 14 topics I train throughout the year. Sometimes I repeat them if needed. I’m trying to come up with something that I can show each training for the year and the most current date.
Hi Kelly, Thanks for your comment. When it comes to Employee training, this is the only one I have. You are welcome to download this template using the links in the description and customize it however you like. I hope this helps and thanks so much.
Please sir, making transport management system
Hi and thanks so much. I will try to create this in the near future
I love your tutorials, but was wondering why when you made tables you don’t use the excel table function.
Hi and thanks very much. I do use tables when i create dashboard and use pivot tables and pivot charts, however I find tables a bit limiting and constraining and I like to define my own specific ranges. Its more of a personal choice and there is nothing wrong with using tables. Certain instances it can save a lot of time for sure.
Thank you for your Likes, Shares & Comments. It really helps.
can you prepare a bakery raw material for the finished goods product For example if I What to prepare an icecream i should type 100 pack of icecream it should give the total amount of ingredients to prepare
Hi yes, please check the Work Order screen of this training. I have shared that already on the update here on our Patreon platform www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Hello. Are there additional videos that go hand in hand with this one? I'm trying to create the additional sheets going off of what you briefly show while collecting data from the other sheets, but I do not feel this is the easiest way of doing so. I would like to get the names of the other videos that go with this one, if applicable. Thank you in advance.
Hi and thanks so much. You can check out my Employee Manager series here: th-cam.com/play/PLIBeRriXvKzD6v9jJ3OPrIymavpIsLVLL.html
I hope this helps and thanks so much.
Amazing database template how do I activate the recurring training button ?
Hi and thanks so much for your comment. I have added the recurring feature for our Patreon members update. You can join us here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
HI RANDY! GOOD JOB, PLEASE DON'T FORGET TO PUT A CODE THAT CAN SHOW A LIST THAT APPEARS IN A POPUP WINDOW CONTAINING THE NAMES OF WORKERS WHOSE CERTIFICATES EXPIRE SOON
Thanks so much. That's a great idea. I will try to get that added on the Patreon update next week. Much appreciated
Yes, expiring soon would be excellent addition.
Pop up of expiring soon as well as send email reminder. Great work.
Thank you for this amazing tutorial... Im looking for an employees archieving software. Can You add this tutorial to your channel please?
Hi and thanks for your idea. Can you explain what an 'Employee Archiving Software would do? I am not familiar with this.
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Im looking for a software could help me to archiving employees documents (contracts, sick leaves, salary statements, courses .. etc) in a main folder and each one has a sub folder with details sub folders (contracts, health, Financial, evaluation, training courses) sub folders as a tree structure. I can send you a flowchart for more explanation (if necessary)
Hi and thanks very much. This would be custom-built solution based on your requirements. oIf you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
Nice feature to consider on my version of this application. I will check if I can add this
1:08:47 the code will not work for me, I just get
run-time error ‘1004’:
Method ‘Range’ of object ‘_Worksheet’ failed
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hello Randy, i have found a problem in the code. The application works fine as long as the user behaves as predicted but if he or she does something weird there is going to be an error. For instance, delete an attachment row where you have only introduced a random letter ( using the bin icon shape button).
Hi Juan, Thanks so much for your comment and feedback. I create these templates in just a few days, as I have to create a new one each week, and they are used for training purposes so I am sure there are lot of small bugs and issues. I have not tested them in every scenario or condition.
If you need help fixing any issue, please post screenshots of the issue, along with all of the details, in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
hi, can someone have a template that can be downloaded and edited to suite my company employee training
Hi and thanks for your comment. You can download the template for free and then email me with any customization requests and I can forward it to a qualified developer Randy@ExcelForFreelancers.com
I hope this helps and thanks so much.
sir, how can i get this Employee Training Application in Excel workbook.
Hi and thanks so much. There is a temporary issue with our automation (normally you can download it by clicking the link in the description) however, you can download this workbook by clicking on the following link
freeworkbookdownloads.s3.us-east-2.amazonaws.com/Employee_Training_Manager.xlsm
Also, as an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Would this work as an employee leave tracker🤔
Perhaps it can be converted, however I have a complete Employee Manager series, 21 parts, that includes Employee Leave in this training : th-cam.com/video/0Xbpz134YRs/w-d-xo.html
I hope this helps and thanks so much.
Sorry but how did you do the data from the "Named Manager"? I missed something.
Hi and thanks very much. I created the named ranges beforehand, however you can see how I did it in this recent video in which I create all named ranges during the training th-cam.com/video/p1c3uTR-N6Q/w-d-xo.html
I hope this helps and thanks so much.
@ExcelForFreelancers thank you very much. My first time working with excel and loving it
Great to hear that. Thanks so much
i cant speak english.
kenapa ketika klik visual basic moduls tidak muncul apa², semoga dijawab🙏🏽
Hi and thanks make sure you have macros enabled in your Excel. I hope this helps and thanks so much.
Where do you add new employees? Is that done on the employee tab, in column B? I tried this but nothing else updated. No update on the Empl.ID, or the sorted columns. I am clearly doing something wrong and dont quite understand the process. I also tried to add more training types in the admin tab, but the list didnt grow once I pushed past the last space as expected. Any help with this would be appreciated. Thanks
HI and thanks, I discuss this during the video so please make sure to watch the full video. You are welcome to update the Employee Database and make sure each employee has a unique ID.
I hope this helps and thanks so much.
Ok. I will watch again to see if I missed something. Thanks
@@ExcelForFreelancers I have rewatched the video 6 times and no where does it mention how to add or subtract employees and have the sorted columns be auto updated. You copied the links from the sorted column on Employees Tab to the Employee column on the schedule. But dont reference how to add or remove employees. When I add new training, the employees that I add manually to the master list are not in the drop down, as the sorted column isnt updated. If I manyally add a name to the sorted column, it will show up but not sorted. And I have to add the name manually to the schedule to have it show up there as well. I am sure I am doing something wrong and there is an easy fix. Sorry to be so out to lunch on this.
Thanks
HI and thanks for your comment. I discussed the employee database. so named would have to be added manually and then you can run the sort employees at any point you want. Due to time restraints there were limited features on this template. You can add and remove employees manually. If i was selling this as an application, instead of a free template and training, I would be adding a lot more features such as ways to add and remove employees and auto-sort on addition or subtraction of Employees. I hope this helps and thanks so much. Feel free to download this template and add any features you like. If you need help with this feel free to post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers Thank you for your quick responses. You have been very helpful. I have also joined your facebook group. Love all the videos, and products your group offers!
Keep up the great work.
Hi, is there a code to automatically filter the employees
Hi and thanks for your message. I did add an Employee Filter feature on the updated Patreon post here: www.patreon.com/posts/employee-manager-85140478
I hope this helps and thanks so much.
Hi, first of all, it's a good update to the program, but I was thinking more about a filter like the one you made for the training database, so that the sorted list of the workers was automatically created, so that it always fit if there was a change in the workforce@@ExcelForFreelancers
Hi Peter, you can try using a named range based on the filtered and sorted results of an advanced filter. I believe this would help in that type of a situation. Thank you for your Likes, Shares & Comments. It really helps.
😱 Promo sm
Thank you for your Likes, Shares & Comments. It really helps.
Hey friends, he is a cheater, nothing is free downloaded... He needs only information in forms, then asks to purchase the plan... Cheater...
Hi, and sorry you had an issue with the download. Make sure you click the link under the word 'DOWNLOAD' . There may have been a temporary issue with downloads, that lasted for a short time, however if you try again it should be just fine. If you have any issues with the download please email my assistant so she can get you the download shane@ExcelForFreelancers.com
I hope this helps and thanks so much.
EXCELLENT WORK! I love how you explain what the code is doing. I would second @PmxQhse's request for a "CERTIFICATES EXPIRE SOON" feature. A lot of companies require retraining after a set period of time has expired. In our facility our production schedule changes constantly. A feature to create a production schedule around associates who are trained to do the scheduled processes would be invaluable.
Hi and thanks so much. Yes, I will be adding Recurring training in which you can set training to automatically recur at any interval. I will make sure to add it onto my Patreon platform here www.patreon.com/ExcelForFreelancers
Thank you for your Likes, Shares & Comments. It really helps.
Happy to be here! Congratulations again on your win 🏆
Thank you so very much, I really appreciate that