About this training plan attendance spreadsheet template
This training plan attendance template gives L&D teams and HR professionals a complete system for managing training sessions from planning to follow-up. The four-sheet workbook includes a Training Register for logging courses, trainers, delivery modes, and session dates; an Attendance Matrix for tracking learner attendance with Present, Late, and Absent statuses; a Training Effectiveness Dashboard for monitoring attendance rates and session completion; and a Lists & Guide sheet with a step-by-step operating workflow.
Every sheet is fully editable in WPS Office, Microsoft Excel, or Google Sheets. Replace the sample course data, learner names, and department labels with your own training catalog and team roster. The dashboard formulas automatically calculate attendance percentages so you can spot low-attendance sessions and schedule follow-ups without manual math.
4 integrated sheets
Training Register, Attendance Matrix, Dashboard, and Operating Guide in one workbook.
Auto-calculating dashboard
Attendance percentages and session statuses update as you enter registration and attendance data.
Professional dashboard style
Clean, scannable layout designed for L&D reporting and monthly training reviews.
Standard XLSX format
Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.