Master Excel for Education: Create Customized Grade Books
Create Customized Grade Books and Attendance Sheets with Ease
4.59 (29 reviews)
5,078
students
1.5 hours
content
Jan 2025
last update
$44.99
regular price
What you will learn
Create your own Grade Book using Excel and using the following steps :
Creating a blank Sheet
Entering Names
Sorting Names
Entering The Grades
Calculating The Final Mark
Inserting The LOOK UP Table
Inserting VLOOKUP Function
Adjusting The VLOOKUP Function
Inserting The Average
.Formatting
At the End of of the second section learners will be able to create their own attendance sheet using Excel and using the following steps :
Copying The Names From GradeBook
Inserting Days & Dates(Timeline)
Shading Off Days
Inserting Drop Down List to Take Attendance
Inserting New Calculation Columns
Formatting
Counting Number Of Absent Days
Calculating the % of Absence
Freezing Panes
Taking Attendance of The First Week
Conditional Formatting
Using Brad to create a count down Time
Screenshots
Related Topics
1053588
udemy ID
12/28/2016
course created date
11/20/2019
course indexed date
Bot
course submited by