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: Update inventory records by formula in Microsoft Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Group quantitative data into classes in MS Excel

How To: Enter formulas in Excel with a macro

How To: Clear data & cell contents in Excel using a macro

How To: Do bank reconciliation in Microsoft Excel

How To: Check your voicemail in Microsoft Outlook

How To: Embed YouTube videos in PowerPoint 2003

How To: Create a multiuser login system in Microsoft Access

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Cross tabulate categorical data in Microsoft Excel

How To: Conditionally format at every change in value in Excel

How To: Summarize survey results with a pivot table in Excel

How To: Grade test responses with formulas in Microsoft Excel

How To: Create confidence intervals for proportions in Excel

How To: Highlight Excel values repeated a set number of times

How To: Calculate vacation days with TODAY, YEAR & IF in Excel

How To: Remove empty space when converting an Excel file to a PDF document

How To: Use SUMIFS or SUMPRODUCT to get invoice info in Excel

How To: Find a PValue with Excel

How To: Update inventory records by formula in Microsoft Excel

How To: Create a Basic Attendance Sheet in Excel

How To: Group quantitative data into classes in MS Excel

How To: Enter formulas in Excel with a macro

How To: Clear data & cell contents in Excel using a macro

How To: Do bank reconciliation in Microsoft Excel

How To: Check your voicemail in Microsoft Outlook

How To: Embed YouTube videos in PowerPoint 2003

How To: Create a multiuser login system in Microsoft Access

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Cross tabulate categorical data in Microsoft Excel

How To: Conditionally format at every change in value in Excel

How To: Summarize survey results with a pivot table in Excel

How To: Grade test responses with formulas in Microsoft Excel

How To: Create confidence intervals for proportions in Excel

How To: Highlight Excel values repeated a set number of times

How To: Calculate vacation days with TODAY, YEAR & IF in Excel

How To: Remove empty space when converting an Excel file to a PDF document

How To: Use SUMIFS or SUMPRODUCT to get invoice info in Excel
Be the First to Comment
Share Your Thoughts