If you're using Excel on a Mac computer, just note that the CTRL key for Windows will be the CMD key for Mac.ĭon't Miss: How to Create a Pass-Fail Grade Formula in Microsoft Excel Step 1: Fill in Basic Labelsįire up Excel, and start by adding labels for Attendance and Name, then use 'Student1' for the name name slot. This guide uses the latest Windows version of Excel, but these steps will work on all legacy versions of Excel for Windows and Mac OS X (now macOS), as well as Excel online. You'll also be able to create a print area where attendance totals are associated with their students. Using the method outlined below, you can automate the entry of many fields, as well as total up attendance days using SUM and IF functions.
With this software, you can create a simple yet functional attendance sheet to keep track of your students. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet.
