I need to create a matrix/grid with the following info:
Roles/positions (titles) that my company on boards (hires) such as: RSM, RDMA, MIM, etc.
For each of these roles a series of tasks must be performed in a particular sequence.
Approx 80% of these tasks are universal and apply to ALL roles such as: create network accounts, initiate computer build, schedule product training, etc.
The remaining 20% are role-specific such as assigning access to certain unique software applications/programs, etc.
It would also be great if I could color coordinate tasks to their functional areas such as administration, training, IS, etc.
I have the roles and tasks captured, but don't know how to construct the spreadsheet so that the appropriate tasks fall under the correct roles. I was thinking pivot chart/table but have not been successful in my attempts.
Thanks for any help!
Bookmarks