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.
