Training Completion Log

About this template

When to use it

A completion log for training that has to be evidenced — the statutory courses Korean employers owe their staff (KR) alongside job, safety and leadership courses — with the shortfall against each legal minimum calculated for you. Three sheets — Dashboard, Input data, Usage guide — and only Input data takes typing.

What the dashboard holds

Everything on the Dashboard is a formula. “Key metrics — summed automatically from the ‘Input data’ sheet” holds B7:E7 — Rows entered, Completed (h) total, Completed (h) average, Completed (h) max. Under it, Summary by training type (rows 12–15) splits the hours across the four types in column B, and Hours completed by quarter (rows 19–22) is hand-typed for Q1 to Q4 with a total in B23 and an average in B24.

Filling order

1. Rows 2–21 of Input data take No., Course, Training type, Attendees / Unit, Training date, Statutory minimum (h), Completed (h), Shortfall (h), Completion, Proof in columns A–J.
2. Keep Training type to Statutory, Job skills, Safety and health, Leadership — those four strings are the criteria behind B12:B15.
3. Attendees can be a group or a person: the samples use All employees / All sites, Data handlers / IT Division and Park Ji-hoon / Marketing Team.
4. Statutory minimum (h) holds the hours the law sets for that course. In Korea, office staff owe 3 hours of occupational safety and health training a quarter, while sexual harassment prevention and disability awareness training are 1 hour a year.
5. Column G must hold plain numbers. Fill it and columns H and I resolve themselves.
6. Proof carries the certificate number or where the attendance sheet is filed. Records of statutory training are kept for three years.

How the formulas calculate

• The key metrics read column G: =COUNT(‘Input data’!$G$2:$G$21), SUM, =IFERROR(AVERAGE(…),0), =IFERROR(MAX(…),0).
• Each type row pairs =COUNTIF(‘Input data’!$C$2:$C$21,$B12) with SUMIF and AVERAGEIF over column G, and a share of =IFERROR(C12/COUNT(‘Input data’!$G$2:$G$21),0).
• Shortfall is =ROUND(MAX(0,F2-G2),1) — never negative, so extra hours do not offset another course’s gap.
• Completion is =IF(G2>=F2,”Completed”,”Not completed”), read straight off the same two columns.
• Under the quarterly table, =SUM(C19:C22) and =AVERAGE(C19:C22) return 420 and 105.

Examples

• Row 2 — 1 · H1 occupational safety and health training · Statutory · All employees / Head office · 2026-03-18 · 3 · 3 · 0 · Completed · Certificate SAF-2026-01.
• Row 4 books 1.5 hours against a 2-hour minimum, so Shortfall reads 0.5 and Completion reads Not completed.
• Row 7 is the other gap: 20 hours against a 24-hour leadership course, with “Absent on day 3” in Proof to explain it.
• The eight sample rows total 74.5 hours, average 9.3 and peak at 24.

Common mistakes

• Leaving Statutory minimum (h) at 0 for a legally required course, which makes every row look Completed.
• Using a fifth training type, so those hours vanish from B12:B15.
• Typing over columns H and I rather than correcting the hours behind them.
• Recording a course with no entry in Proof — the row then proves nothing at an inspection.