Skip to content

Excel tutorial - How to calculate students grade

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Excel tutorial - How to calculate students grade

619,612 views October 25, 2014 7:41

Watch on YouTube

Description from the creator

This clip will help you to
1. Find total of students score by using "SUM"
2. Calculate the grade by using "IF"
3. Count how many student got any grade by using " COUNTIF"
4. Sorting the score
I hope this video will help you.
Thank you for watching.

About this tutorial

TANG JA published this 7:41 video tutorial on October 25, 2014. It has been watched 619,612 times on YouTube.

Channel: TANG JA
Category: Entertainment
Duration: 7:41
Published: October 25, 2014
Views: 619,612
Likes: 2,269

Share

Further reading

Calculating Grades in Excel – Student Multimedia Design Center library.udel.edu
I find Excel to be really useful in calculating my grades, and there are only a few simple formulas that need to be used! The first step is to input the different grading categories and their weight. So if homework is w…
Easiest way to calculate student grades? | My Spreadsheet Lab myspreadsheetlab.com
In the ‘old days’ of Excel (before Excel 2007) only 7 nested ifs were possible but now the limit 64 so this solution works nicely as there are a limited amount of grades. Speed to Create if the number of grades is limit…
Excel Formula for Grade | How to Calculate Letter Grades in ... wallstreetmojo.com
Example #1 – Calculating the Grade of students using Excel Formula. In this example of Excel Formula for Grade, we have the data of the marks that are obtained by the students in their final exams, and we want to calcul…

This tutorial in other languages

Web Analytics