Question: how to do attendance in excel?
Answer: Step 1Fill in Basic Labels. Fire up Excel, and start by adding labels for Attendance and Name, then use "Student1" for the name name slot. ... 
Step 2Add & Format Dates. ... 
Step 3Add Column for 'Total' ... 
Step 4Remove Zeros for Non-Existent Students. ... 
Step 5Create Printable Area for Final Tally. ... 
4 Comments.