Create Your Own attendance Sheet | Osama Jaber | Skillshare

# Create Your Own attendance Sheet

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

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
6 Videos (28m)
• Introduction

2:36
• Entering names dates and drop down list

6:20
• Formatting and insert calculation

6:21
• Calculating Absence and freezing panes

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

4

Students

--

Projects

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

#### Osama Jaber

EE,CIPD,CCNA,MCSE,MCSA

CIPD certified training programs Manager, with experience exceeding 18 years of training programs Having over 20 experience in 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 development of competency managem...

See full profile

Technology Skillshare Software Microsoft Excel Microsoft Data Science Attendance
Report class