White cells are editable
Name (G1)
Hard Skills Section
Hard skill name links
Actual
Target Date
Trained Status (Formula)
Certification Method (Dropdown)
Attempts thus far (Dropdown)
Successful Certification Attempts (blacked out until trained fully)
Target Cert Date (Dropdown)
Certified Date (Formula)
Soft Skills
Soft Skill name links
Attempts completed
Greyed out cells
Completed (Dropdown)
Target Date (Dropdown)
Completion Date (Manual)
Areas to Continue (Alt + Enter)
Areas to Improve (Alt + Enter)
Training Plan & Tracker
Hard Skills to Train (Formula)
Hard Skills to Certify (Formula)
Soft Skills to Train/Complete (Formula)
Certified Apprentice Goal Date (Manual from Plan Tab)
Benchmarks Column
Train Target (Formula)
Certify Target (Formula)
Actual (Formula)
Difference (Formula)
Total Certified (Formula)
Skills Remaining (Formula)