Search
Generic filters

Attendance Sheet Excel Template

Use this attendance sheet on your phone or other mobile device to keep track of attendance in your classes or meetings. If you don’t have it already, you will just need to install the Excel app. Save the file to OneDrive to sync your changes with your other devices, or download the file directly to your phone. The attendance log can  complete very easily using drop-downs for selecting the month and day and for marking attendance. You can customize the template by using whatever fun Unicode symbols will display in your version of Excel.

Attendance Sheet in excel

In this template I decided to do something a little more fun than just using an “x” for marking attendance. It turns out that on some phones you can use the emoji or emoticon symbols within the Excel app. While these are not easy to insert using the keypad, you can easily select them when the sheet is set up with Excel drop down lists.

Attendance Sheet template

The template uses the COUNTA() function to count the number of cells that have text in them. So, it doesn’t matter what symbol you use for marking the roll. You can even use many different symbols.

Not all Unicode symbols are define for all fonts and operating systems and browsers and apps. So, you can always revert back to using a symbol that your app supports (like an “x”). To customize the drop-down boxes, you can edit the Check Box list to the right of the attendance roll within the spreadsheet. Piece of 🍰 (cake).

Training Attendance sheet

Below are a few symbols or characters you might use for your attendance roll. You can copy and paste from this page to get these symbols into Excel.

x, ★, ☆, ☺, ✔, ❤, ♫, ⚜, ☘, ☀, ⚽, ⚾, 🏈, 🏀, 🚲, ⛳, 🎾, ⛸, 🙂, 😐, 🍎

These symbols may not show up in your browser. Some of the more recently defined Unicode characters only show up in more recent browsers.

Download Attendance Sheet Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: