Excel Training Matrix wanted - Moving employee training info from Access to Excel

S

Sharr76

#1
Hi guys,:bigwave:

I am in the process of moving employee training information from access to excel, reason being is that the access DB is too hard for some employees to understand,.......

So I am looking for a nice excel template which I could use to list employees and what training they have taken along with the dates the training took place.

Has anyone got anything I could use??

Thanks in advance....:)
 
Elsmar Forum Sponsor

SteelMaiden

Super Moderator
Super Moderator
#2
Re: Excel Training Matrix

in the first column, list a job title, then in each row down the "task" or knowledge item that you need to train on. Then, you can list each employee with that job title in columns a through whatever. Put the date trained for each of those employees in the corresponding "skill" row.

If you want simple, this will work for you. Of course, if you have any regulatory requirements about tracking how a person was trained, or who trained them, etc., excel does not work well.
 
S

Sharr76

#4
Re: Excel Training Matrix

in the first column, list a job title, then in each row down the "task" or knowledge item that you need to train on. Then, you can list each employee with that job title in columns a through whatever. Put the date trained for each of those employees in the corresponding "skill" row.

If you want simple, this will work for you. Of course, if you have any regulatory requirements about tracking how a person was trained, or who trained them, etc., excel does not work well.
Thanks for the quick response......:)
 

SteelMaiden

Super Moderator
Super Moderator
#5
You are welcome. This one was an easy one as we are doing an improvement project on training and we've looked at and discarded many of the "easy home brew fixes".
 

Caster

An Early Cover
Trusted Information Resource
#6
...we are doing an improvement project on training and we've looked at and discarded many of the "easy home brew fixes".
So what did you do?

We went to commercial software because we ended up spending too much time playing with Access and Excel rather than doing our jobs (although that was more fun and looked like work to the boss).
 
Last edited by a moderator:
J
#7
Funny, I went the opposite direction with my training records (Excel to Access) because the matrix became too large and difficult to deal with rather quickly.
Access gave us an easier way to quickly see who was trained on what and when. Plus we could print out a report for each employee if needed etc.

Ah well - to each his own.

Peace
James
 

lboll

Involved In Discussions
#8
We went to commercial software
What software package did you purchase? I need to move away from Excel also because it's becoming too large and complicated to track neatly. However, when I start to search for commerical software, the shear volume of options is daunting.
We're a small medical device manufacturer with around 100 employees.
 
B

bhmdave

#9
I have built and used Access for training records. If you already have one built that you have been using, I would investigate the cost of sending one or two employees to training on Access vs the cost of new software and still having to do the training on the new software. Not everyone needs to know how to write the queries and reports, just how to click the buttons to get the reports.
 
Q

quality1

#10
Hi all,

We're currently using access DB that was purchased long before my time and is impossible to make changes we need even for an advanced user. Anyone ever use off-the shelf- Training Management DB by Kaizen SW Solutions or Smart Company or any other company that has worked very well for you? we're a 50 employee company.

thanks
 
Thread starter Similar threads Forum Replies Date
Q Training Matrix in Excel or maybe an Access database Excel .xls Spreadsheet Templates and Tools 1
B Training Record Matrix Macros in Excel .xls spreadsheet Excel .xls Spreadsheet Templates and Tools 11
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
M Excel Charting - Graphing each trainee's length of time in training Excel .xls Spreadsheet Templates and Tools 5
S Training Tool in Excel Attached Training - Internal, External, Online and Distance Learning 15
J Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
S 95% UCL - Attaching an excel for recovery study Statistical Analysis Tools, Techniques and SPC 0
T EXCEL - How do I make the cell stay blank until a date is entered in N7? Excel .xls Spreadsheet Templates and Tools 6
Ed Panek Validating Excel (XLS) formulas 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Ajit Basrur Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 9
J Does anyone have an excel IATF 16949 Internal Audit checklist I could use? IATF 16949 - Automotive Quality Systems Standard 7
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
I Cannot Export multiple sections from Excel to PDF without losing pagination Excel .xls Spreadsheet Templates and Tools 23
M Matching two matrices in Excel Excel .xls Spreadsheet Templates and Tools 5
J Level 3 KPI Excel Template Manufacturing and Related Processes 1
bobdoering Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 23
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
J ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B AS9110 Audit Check Sheet wanted Excel or Word Document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
G Excel report with pictures Excel .xls Spreadsheet Templates and Tools 5
A Query regarding MS Excel usage Excel .xls Spreadsheet Templates and Tools 2
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
Y Excel Automation - Printing Word Documents from within Excel Excel .xls Spreadsheet Templates and Tools 0
P Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
M Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4
C Excel date format from Denmark to USA Excel .xls Spreadsheet Templates and Tools 6
G ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
N Where I can find an Excel sample/template for recording Delivery Time and Cost Excel .xls Spreadsheet Templates and Tools 2
D How do I go about creating document logs and registers with the MS Excel Excel .xls Spreadsheet Templates and Tools 2
D Microsoft Excel database to Stand-alone software Calibration and Metrology Software and Hardware 3
Q Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
B Zeiss CMM Calypso output to Excel or CSV file Help Inspection, Prints (Drawings), Testing, Sampling and Related Topics 17
S used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart Statistical Analysis Tools, Techniques and SPC 0
N Gantt Chart / Time Tracker in Excel - Combining Tasks on the Same Line Excel .xls Spreadsheet Templates and Tools 2
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
1 KPI Dashboard Template in Excel Format wanted Excel .xls Spreadsheet Templates and Tools 9
Ajit Basrur MS Excel to study Correlation between Humidity & Differential Pressure Excel .xls Spreadsheet Templates and Tools 7
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
T Where can I get a PPAP workbook in Excel .xls with links? APQP and PPAP 1
L Excel Template for Cgk Study wanted (Capability Gauges Study) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
V Looking for advice on Pooled Standard Deviation between Minitab and MS Excel Statistical Analysis Tools, Techniques and SPC 1
P Recommendations on SPC Software or Excel SPC add-in(s) Quality Assurance and Compliance Software Tools and Solutions 6
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1

Similar threads

Top Bottom