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.