Launch Microsoft Excel. Name cell A1 "Courses," cell B1 "Hours" cell C1 "Grade Points" and cell D1 "Grade Value."
Click the "View" tab at the top of the window and select the triangle-shaped icon next to the "Freeze Panes" button. Select the "Freeze Top Row" option.
Type the course names into row A below cell A1. You may want to leave space for multiple courses so that you can use this template in future semesters.
Type in the number of hours of each course in row B below cell B1. Click cell B9, then click the "Auto Sum" button on the "Formulas" tab and select cells B2 through B8 to sum.
Type in the grade for each course in row C below cell C1. Replace any "A" grades with "4," any "B" grades with "3," any "C" grades with "2," any "D" grades with "1" and any "F" grades with "0."
Select cell D2 and click the "Insert Function" button on the "Functions" tab. Choose the "Product" function and select cells B2 and C2, then press "Enter." This function creates the grade value for the first course.
Click cell "D2," hold down the "Ctrl" key and press "C" to copy the formula. Click cell "D3," hold down the "Ctrl" key and press "V" to paste the grade value formula to cell D3. Repeat this process for cells D4 through D8.
Select cell "D9," click the "Autosum" button and choose to sum cells D2 through D8.