student attendance spreadsheet template excel

Read More: How to Create a Monthly Staff Attendance Sheet in Excel Then, type “ Type” as the name and press OK.Lastly, select the Type cells and go to the Defined Name option.Then, type “ Holiday” as the name and press OK.Similarly, select the holiday cells and go to the Defined Name option.Here, give a suitable name for the list of cells. After that, you will see a window named “ New Name”.Then, go to the Formula tab > Defined Name option.To do this, select the cells of months.First, define a name for the list of the months.Defining the name will allow you to use the Data Validation tool to make a drop-down menu in the cells. Read More: How to Create Monthly Attendance Sheet in Excel with FormulaĪfter inserting the necessary information, you have to define names for them. You can add or remove holidays as per the calendar of your institution. See my article Using Unicode Character Symbols in Excel for more Unicode symbols.💬 NOTES: I haven’t listed all the holidays in this workbook. Some of the more recently defined Unicode characters only show up in more recent browsers and may not be supported by all apps. These symbols may not show up in your browser. You can copy and paste from this page to get these symbols into Excel. Piece of 🍰 (cake).īelow are a few symbols or characters you might use for your attendance roll. To customize the drop-down boxes, you can edit the CheckBox list to the right of the attendance roll within the spreadsheet. So, you can always revert back to using a symbol that your app supports (like an 'x'). Not all Unicode symbols will be defined for all fonts and operating systems and browsers and apps. So, it doesn't matter what symbol you use for marking the roll. The template uses the COUNTA() function to count the number of cells that have text in them. 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. It turns out that on some phones you can use the emoji or emoticon symbols within the Excel app. In this template I decided to do something a little more fun than just using an 'x' for marking attendance.

Student attendance spreadsheet template excel