Managing student grades can be time-consuming. fortunately, Microsoft Excel can help! In this lesson, learn the initial steps to create an Excel grade book.
In this lesson, continue building your Microsoft Excel gradebook by making a student attendance and participation sheet using the Concatenate function.
In this lesson, continue to construct a gradebook in Microsoft Excel by adjusting the spreadsheet’s column headers, and adding exam and averages categories.
Learn how to enter student grade data into your Microsoft Excel gradebook spreadsheet, and color code the different grading categories in this lesson!
Add Average functions to your Microsoft Excel gradebook using AutoSum and Autofill, and change error settings to get the final columns in order!
- Recommended Recommended
- History & In Progress History
- Browse Library
- Most Popular Library
Get Personalized Recommendations
Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.Start Interview
You don't have any lessons in your history.
Just find something that looks interesting and start learning!