I have been struggling with creating a Training Matrix for our facility that will encompass every Department, Employee and training that is annually given. I have completed formatting that allows notification of the need to retrain or certify as well as set up the sheet to filter between Employee Names and Departments.
But, a big need in the sheet is to filter between Category's, Types of Training, Schedule, and Specification which are inserted into the table Horizontally. I have searched forums for an answer to this and come up short.
Any help on formatting Horizontally will be greatly appreciated.
2014-11-18 15_04_57-Microsoft Excel - Copy of Camarillo Training Matrix (3).xlsx.jpg
I would like to Filter between the different Types of Training. If I want LOTO I want to filter to just LOTO. Same for JSA Camarillo and Others.
I have attached a copy of the Initial Training Matrix if this will help. Copy of Camarillo Training Matrix (3).xlsx