Take Attendance in Excel
Channel: ForeverMore Training
Date: 2021-02-24

I take attendance in my college class. I teach 2 days a week for a 15-week semester, so my attendance tracking is a little different than a standard attendance tracking sheet. 
As a college instructor, I really believe in the benefit of attending class, so, yep, I take attendance. If you are in a similar situation, watch and see how to easily set up an attendance worksheet with little effort.
This video is with Excel 2019, but will work with all versions. 

Chapters:
0:00 Introduction
0:28 Starting from a blank worksheet
1:16 Entering dates using a simple formula
4:30 Add borders
5:27 Countif function - count the number of days a student is absent/present
7:10 Countif function - count how many students are present each day
8:34 Conditional Formatting
9:44 Hide/Show columns
10:45 Add comments to a cell
11:16 Printing

***************
Not every college class takes attendance. However, I teach a course that does not have prereg's, this is often a student's first college course. I like to help them start good habits:)
Do you keep attendance in your college class? Let me know in the comments.

New to Excel? Take my Excel course over at Udemy:
https://www.udemy.com/course/excelbasics-personalbudgetproject/