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.

MS Excel comes with a tool to calculate simple moving averages. The Data Analysis Tool Pack is an add-in, which means you may not have it by default. We are listing here the steps to get this tool.