𝗪𝗜𝗟𝗗𝗘𝗦𝗧 𝗗𝗜𝗦𝗖𝗢𝗨𝗡𝗧 𝗢𝗙 𝗧𝗛𝗘 𝗬𝗘𝗔𝗥 - 𝟲𝟱% 𝗦𝗔𝗩𝗜𝗡𝗚𝗦 𝗙𝗢𝗥 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬 https://www.excelforfreelancers.com/BFSale2024_YTDesc


In this week’s training, I will show you how to create your own dynamic skills matrix in Excel.


𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:
USING YOUR EMAIL: http://bit.ly/SkillsMatrix_WkbkDl


GET AN UPDATED TRAINING AND TEMPLATE WITH THE FOLLOWING FEATURES:
• How to check for duplicate employees when adding teams
• Setting hours on a per-project and per-employee basis
• How to save before generating staff

FIND THIS UPDATE ON PATREON HERE: https://www.patreon.com/posts/dynamic-skills-58717996


TIMESTAMPS:
0:00 – Introduction
0:39 – Overview
18:15 – Named Ranges Detail
38:01 – Selection Change Worksheet
55:51 – Load Project List
58:01 – Change Worksheet
59:08 – New Project
1:01:03 – Save and Update Project
1:18:16 – Load Project
1:40:08 – Delete Project
1:41:49 – Skill Level Up
1:45:09 – Skill Level Down
1:46:23 – Add Skill Project
1:50:39 – Delete Skill Project
1:54:18 – Get Unique Teams
1:55:15 – Add Employee or Team
2:04:58 – Remove Employee
2:10:51 – Generate Optimal Staff
2:14:28 – Save As Team


#SkillsMatrix #employeemanagement #employeetraining #ExcelVBA