Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
The first row will have the class name, number of hours, number of credits, and the grade received. Enter in the data for each class that you have data for. An A is 4, B is 3, C is 2, D is1, and F is 0.
Total your credit value by multiplying credit number and grade earned.
To obtain your GPA total your number of credits and your credit value. Then divide those numbers. This yields your GPA.
How To: Create an Excel spreadsheet to calculate your GPA
 Hot
 Latest

How To: Find a PValue with Excel

How To: Graph the probability density function in an Excel file

How To: Create a Basic Attendance Sheet in Excel

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Automatically hide the Ribbon menu system in Excel

How To: Update inventory records by formula in Microsoft Excel

How To: Find critical values with T functions in MS Excel

How To: Use TEXT & custom number formatting in Microsoft Excel

How To: Create a relative frequency distribution in MS Excel

How To: Create a bond discount or premium amortization table in Excel

How To: Create an interestonly loan schedule in Microsoft Excel

How To: Create a savings plan with Excel's FV & PMT functions

How To: Group quantitative data in Microsoft Excel

How To: Create a scatter diagram for 2 variables in Excel

How To: Repeat each successive date in an Excel date column

How To: Allow only Monday dates in a cell in Microsoft Excel

How To: Construct confidence intervals with TINV in MS Excel

How To: Count values between a lower & upper bound in MS Excel

How To: Create a weighted gradebook in Microsoft Excel

How To: Find a PValue with Excel

How To: Graph the probability density function in an Excel file

How To: Create a Basic Attendance Sheet in Excel

How To: Display trend arrows in a Microsoft Excel spreadsheet

How To: Automatically hide the Ribbon menu system in Excel

How To: Update inventory records by formula in Microsoft Excel

How To: Find critical values with T functions in MS Excel

How To: Use TEXT & custom number formatting in Microsoft Excel

How To: Create a relative frequency distribution in MS Excel

How To: Create a bond discount or premium amortization table in Excel

How To: Create an interestonly loan schedule in Microsoft Excel

How To: Create a savings plan with Excel's FV & PMT functions

How To: Group quantitative data in Microsoft Excel

How To: Create a scatter diagram for 2 variables in Excel

How To: Repeat each successive date in an Excel date column

How To: Allow only Monday dates in a cell in Microsoft Excel

How To: Construct confidence intervals with TINV in MS Excel

How To: Count values between a lower & upper bound in MS Excel

How To: Create a weighted gradebook in Microsoft Excel
Be the First to Comment
Share Your Thoughts