Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

## Create Your Own attendance Sheet

#### Osama Jaber, CIPD,CCNA,MCSE,MCSA

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
6 Videos (9m)
• Steps 2 Whiteboard

2:36
• Entering names dates and APL

6:20
• Formatting and insert calculation

6:21
• Calculating Absence and freezing

5:19
• Taking Attendance of the 1st week

3:36
• COnditional Formatting

3:48

This course is for educators , coaches , mentors , supervisors who need to take daily attendance of their students or employees ,

In this course you will how create their Attendance sheet using Excel, using the following steps :

1. First step is copying the names from the grade book
2. The second step is creating the timeline (calendar days and Dates)
3. The third step is shading the off days , Saturday ‘s and Sundays off , we will shade them with a darker color
4. The fourth step is inserting a drop down list ( P = Present , A=absent , L = late) in the cells to take the attendance
5. The fifth step is inserting 2 new columns to calculate the number of absent days , and percentage of absence
6. Step 6 is Formatting
7. Step 7 is Formatting to make the sheet user friendly
8. The eighth step is inserting a function to calculate the number of absent days
9. In step 9 we will be calculating the Percentage of absence
10. Step 10 we will be freezing panes “we will freeze the 1st three columns to show the names and statistics” when we scroll left or right
11. In step 11 We will be taking the attendance of the first week
12. In step 12 we will be doing conditional formatting , if the absence of any student is greater than 20% the cell will be shaded to red to alarm us that the student must be warned .

To achieve that please review the following in Excel:

• How to use Formulas
• The order of operator precedence in Excel Formulas
• How to use VLOOOKUP Function
• Absolute and Relative References
• COUNT,COUNTA,and COUNTIF
• Conditional Formatting

--

Students

--

Projects

0

Reviews (0)

#### Osama Jaber

CIPD,CCNA,MCSE,MCSA

CIPD certified training programs Manager, with experience exceeding 15 years of training programs

Having over 20 experience in Training Project Management , leading Multicultural and cross-functional teams

Managing training programs from Training Needs Analysis, writing proposals budgeting, execution to evaluation.

Conducting trainer's induction and train the trainer courses, excellent experience in blended learning management, design of Learning Management Systems and d...

See full profile