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: Create a Basic Attendance Sheet in Excel

How To: Value assets with discounted cash flow analysis in Microsoft Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Extract records that meet certain criteria in Excel

How To: Change Excel options directly in the Registry

How To: Build a 15minute schedule in Microsoft Excel

How To: Create a relative frequency distribution in MS Excel

How To: Chart crosssectional and time series data in MS Excel

How To: Group duplicates & extract unique records in MS Excel

How To: Create a distribution for categorical data in MS Excel

How To: Calculate variance and standard deviation using Excel

How To: Print doublesided and reverse printing order in Word

How To: Make calculations for markup & markdown in Excel

How To: Use Excel for daily interest and monthly deposits

How To: Go to New Record in a form using macros in MS Access

How To: Automatically format duplicate values in Excel 2010

How To: Extract records from a table to a column in MS Excel

How To: Enter formulas in Excel with a macro

How To: Generate random numbers (with decimals) in Excel

How To: Find a PValue with Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Value assets with discounted cash flow analysis in Microsoft Excel

How To: Create a passfail grade formula in Microsoft Excel

How To: Extract records that meet certain criteria in Excel

How To: Change Excel options directly in the Registry

How To: Build a 15minute schedule in Microsoft Excel

How To: Create a relative frequency distribution in MS Excel

How To: Chart crosssectional and time series data in MS Excel

How To: Group duplicates & extract unique records in MS Excel

How To: Create a distribution for categorical data in MS Excel

How To: Calculate variance and standard deviation using Excel

How To: Print doublesided and reverse printing order in Word

How To: Make calculations for markup & markdown in Excel

How To: Use Excel for daily interest and monthly deposits

How To: Go to New Record in a form using macros in MS Access

How To: Automatically format duplicate values in Excel 2010

How To: Extract records from a table to a column in MS Excel

How To: Enter formulas in Excel with a macro

How To: Generate random numbers (with decimals) in Excel
Be the First to Comment
Share Your Thoughts