Employee Training record

Acuemen

New Member
Joined
Mar 13, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi! i want to use such sheet to keep records of employee training with 5 check buttons or radio buttons for each training point, once all the trainings are completed, trainer clicks the save button, a pdf file is generated certifying the completion, and i wish to have this available in teams for all the trainers,can someone help me with this plz


first look.xlsx
ABCDEFGH
1Training Area
2Employee Name
3Employee ID
4
5Ideally populates Training from other sheet on selection of training area
6Training 1
7Training 2
8Training 3
9Training 4
10Training 5
11Training 6
12Training 7
13Training 8
14Training 9
15Training 10
16Training 11
17Training 12
18Trainer name:
Sample
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
If this is something you could work with, it is by far much simpler to implement. I like to use the 'Webdings' font and type a lowercase 'a' to get a checkmark. The best part is you don't have to insert any checkboxes/radio buttons and you can count the results with formulas.
Book1
ABCDEF
1Training Area
2Employee Name
3Employee ID
4
5Ideally populates Training from other sheet on selection of training area
6Training 1a
7Training 2a
8Training 3a
9Training 4a
10Training 5a
11Training 6
12Training 7
13Training 8
14Training 9
15Training 10
16Training 11
17Training 12
18Trainer name:
Sheet2

Edit: Okay, it seems the mini-sheet does not support 'Webdings', but see the screenshot here for what I mean:
1710364438307.png
 
Upvote 0

Forum statistics

Threads
1,223,954
Messages
6,175,601
Members
452,658
Latest member
GStorm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top