Attendance Tracker (Teachers new to Excel) - Step 1

Links Verified: March 20, 2026

Create a simple attendance tracker with student names and one week of school days across the top of the worksheet.

Build the Attendance Table

Next step: enter attendance codes.

Try It

1. Type Student Name in column A.
2. Type Monday through Friday across row 1.
3. Enter several student names down column A.

This project is part of the Excel Classroom Data Projects series.

Next step: Continue to step 2.