You need to use this formula to calculate the average GPA in Excel: =<cell with sum of grade values>/<total number of subjects>. Then, you can use VLOOKUP to enter the grades.

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

How to use Excel’s RANK.AVG() function In almost every way, Excel’s RANK.AVG() function performs as RANK(), except in one way: RANK.AGE() returns an average rank if a number occurs more than once.

To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR. ... You can use Microsoft Excel to calculate the variance of the data you have entered into a spreadsheet.