Training Record Matrix Macros in Excel .xls spreadsheet

B

biggierob

#1
I am developing a traing matrix to keep track of my employees training. I have the basic design but I wanted to incoporate macros and other add-ins such as one that will change the color of the revision number of the employee after the revision number of the document is changed. This would help me keep my employees up to date on the training because after a document has gone up two revisions the employee needs to be fully retrained. So any guidance about formatting or add-ins would be greatly appreciated.


:topic: I have heard about the cove for a number of years but just now became a member, great stuff here.
 

Attachments

Elsmar Forum Sponsor

Caster

An Early Cover
Trusted Information Resource
#2
Welcome

Biggierob

Welcome. For a real simple start try Format/Conditional Formatting. It will let you change both text and background colors. A summer student showed it to me and I now use it a lot.

As an auditor I would definitely be asking you to defend the "retrain on the second change approach". Make sure you have thought this through and can defend it. What about a major change that impacts quality?

You will likely find that you soon need to create an Access database. And you may soon be spending a lot of time programming (great fun) rather than doing Quality (not so much fun). There is a wide range of off the shelf software out there from hundreds to hundreds of thousand$. Somthing to consider.
 
G

gszekely

#5
Rob !
If you run a google search on "excel tutorial" and "excel add in", you will find a lot of free stuff. If you post your sheet with some guidance and indication on what you want, I may help you. Now your question is too general for me, seems that you are looking for general info.
Gyorgy
 
R

ralphsulser

#6
isoboy said:
Here is an example of a training matrix that I use for TS 16949 internal auditors. Notice the conditional formatting features and measurment / data analysis potential. This may give you some ideas for your matrix. Enjoy!

isoboy, I see Mr. Hand is way behind in his training and only competent in assembly. Has he performed any hands on audits?:lol:
 
P

pailsy

#9
Here is an example of the Training Matrix i am currently buiding - also uses conditional formatting and data validation. Any suggestions for improvement are welcome....
 

Attachments

R

rudolfnco

#10
I see people are using Excel to keep training records. Our company has tried using Excel, but the sheer volume of training records accumulated over the years (not to mention the employees who have come and gone) is shifting us towards a database.

We have about 45 employees altogether and generate, say, one training record per week in the production line alone. The database will be used to make sure those who were absent on the day the training was given will receive the training when they come back. There are many other factors besides this to consider, but I was wondering which software/programs other companies use to store/readily retrieve training records per individual.

What were your experiences?
 
Thread starter Similar threads Forum Replies Date
I Training records and levels - When does training NOT need a record? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 13
J Training Record Template and tracking Document Control Systems, Procedures, Forms and Templates 1
Crusader Training / Competency Assessment Record for review and feedback Training - Internal, External, Online and Distance Learning 12
S ISO 9001 - Training Record Content Requirements Training - Internal, External, Online and Distance Learning 5
A Can I give this Training Record to HR (Human Resources)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
S What is the best technique for Training Course Evaluation and Record Tracking Statistical Analysis Tools, Techniques and SPC 3
R Electronic Training Record Form (Template) Document Control Systems, Procedures, Forms and Templates 6
S Training Record Signatures Requirements - Software aspect Records and Data - Quality, Legal and Other Evidence 3
Q What is considered a Training Record? AS9100:2004 Clause 6.2.2 Records and Data - Quality, Legal and Other Evidence 8
B Training Record Retention Training - Internal, External, Online and Distance Learning 6
D The Difference between a Document and a Record - Training Plan Document Control Systems, Procedures, Forms and Templates 11
5 Machinist's Journeyman's Card a Training Record? Records and Data - Quality, Legal and Other Evidence 13
E Training Record - By Job or by Employee? Training - Internal, External, Online and Distance Learning 6
B Training Records and Competency - Seeking sample training record Records and Data - Quality, Legal and Other Evidence 7
A Self-training or Self-studying ISO 13485:2016 - Medical Device Quality Management Systems 8
N ISO 9001 - Training business with fewer than 5 employees ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
S Employees training database Document Control Systems, Procedures, Forms and Templates 4
optomist1 Rates Daily or Hourly Process Improvement Training Consultants and Consulting 2
Le Chiffre Online training available for ISO/IEC 17021-1: Requirements for bodies providing audit and certification of management systems Training - Internal, External, Online and Distance Learning 3
S IEC60601-1 Training recommendations Training - Internal, External, Online and Distance Learning 1
P Training department ideas and development for automotive supplier Training - Internal, External, Online and Distance Learning 6
A Document release vs its related training. Which should come first? ISO 13485:2016 - Medical Device Quality Management Systems 18
C RA (Regulatory Assurance) Training (FDA) looking for resources Training - Internal, External, Online and Distance Learning 5
was named killer Onsite Level II N.D.T. Training in Florida Training - Internal, External, Online and Distance Learning 0
T Training recommendations? Bringing our RoHS and REACH compliance efforts in-house REACH and RoHS Conversations 2
S Quality Audit Training Activities Quality Manager and Management Related Issues 2
M Audit Criteria Training Materials Internal Auditing 1
B Looking for 10 Internal Audit Online Training Participants ISO 17025 related Discussions 2
optomist1 Informational Training IMDS - Management of Product Chemical Regulatory Compliance RoHS, REACH, ELV, IMDS and Restricted Substances 2
Anonymous16-2 Labelling Training Training - Internal, External, Online and Distance Learning 3
J Recommendations for online ISO 19011 training? Training - Internal, External, Online and Distance Learning 8
J Looking for a training organization that can provide in house DFMEA training FMEA and Control Plans 4
A AS9100 Training - Where do I start? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 14
R What's the major difference between Green Belt and Black Belt in term of training and project Six Sigma 3
S ISO 13485 Lead Auditor - Debate between our Quality Team and Regulatory Auditor - Internal Auditor Training ISO 13485:2016 - Medical Device Quality Management Systems 17
I Where can I beg, steal (just kidding of course) or borrow good training material on the ISO 9001:2015 standard? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
JAMESH Building a "Lean" Job Shop Training Program Training - Internal, External, Online and Distance Learning 0
I Does training have to be written? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 14
I Root Cause Analysis as Training ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
Q Regulations for Medical Device Kit for Training Personnel? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
S Can we provide training plan as corrective action for IATF 16949 Non conformity? IATF 16949 - Automotive Quality Systems Standard 9
S IRCA Lead Auditor training and Exam tips Training - Internal, External, Online and Distance Learning 5
N ... and some have greatness thrust upon them - Training for novice QA manager ? Training - Internal, External, Online and Distance Learning 6
C Looking for APQP Training recommendations preferably in the aerospace industry APQP and PPAP 2
B VDA 6.3 Qualification as Process Auditor training course and exam VDA Standards - Germany's Automotive Standards 0
L Hazardous Waste - Tips for creating standardized training Miscellaneous Environmental Standards and EMS Related Discussions 2
R ISO 13485 QMS Implementation Training ISO 13485:2016 - Medical Device Quality Management Systems 7
R How to keep track of employee read-only training ISO 13485:2016 - Medical Device Quality Management Systems 13
I "On the job training" as a response to how someone was trained? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 75
J Getting training either from ASQ or from SAI Global - ISO 9001 Lead Auditor training Training - Internal, External, Online and Distance Learning 1

Similar threads

Top Bottom