Cellwise Try it free

Excel for your field

Excel for students

For high school and college students who want straight answers to the questions that come up every term: what is my GPA, what do I need on the final, what is due this week and how much can I spend. Each formula below runs on one sample student's sheet, so you can see exactly what it does before you copy it into your own. Grade scales differ between schools, so the scale lives in cells you can edit rather than inside the formulas.

Grading scales and GPA rules vary by school. Treat these results as estimates and check your official transcript or handbook.

Sample data

Every result on this page comes from this sheet, calculated by the same engine the Cellwise app uses. Change a number and watch the formulas react.

ABCDEFGH
1CourseCreditsGradePointsCurrent %Final countsGradePoints
2Calculus I4B+3.384.50.3A4
3Intro Psychology3A493.20.25A-3.7
4English Comp3A-3.790.40.2B+3.3
5Chemistry4B-2.779.60.35B3
6Chem Lab1A4950.15B-2.7
7Spanish II3B3860.25C+2.3
8C2
9AssignmentCourseDueDone?Target %85D1
10Problem set 7Calculus INov 6, 2026Today's dateNov 2, 2026F0
11Lab report 4Chem LabNov 5, 2026YesStudy hrs/week15
12Essay draftEnglish CompNov 4, 2026

What Excel does for students

Turn letter grades into grade points

GPA runs on grade points, not letters, so the first step is a lookup. Keep your school's scale in two columns (G and H here) and look each letter up with XLOOKUP. If your school gives 4.3 for an A+, or has no minus grades, you change the table, not the formula. In the sample, column D already holds the result of this formula copied down.

The grade must match the table exactly: "B+ " with a trailing space returns #N/A. In Excel 2019 or older, use =VLOOKUP(C2,$G$2:$H$10,2,FALSE).

=XLOOKUP(C5,G2:G10,H2:H10)

Result: 2.7

Chemistry is a B-, which is worth 2.7 points on this scale.

Calculate your GPA, weighted by credits

A 4-credit class moves your GPA more than a 1-credit lab, so GPA is a weighted average: credits times points for each class (quality points), added up, divided by total credits. SUMPRODUCT does the multiply-and-add in one step.

The common mistake is a plain AVERAGE of the points column. Here that gives 3.45, because it counts the 1-credit lab as much as Calculus. Leave pass/fail and withdrawn classes out of both the points and the credits, since most schools do not count them toward GPA; check your school's rules.

=ROUND(SUMPRODUCT(B2:B7,D2:D7)/SUM(B2:B7),2)

Result: 3.34

60.1 quality points over 18 credits is a GPA of 3.34, lower than the 3.45 a plain average suggests.

Work out the score you need on the final

If the final is worth 30% of the grade, your current percentage covers the other 70%. To end on your target: needed = (target - current x (1 - final weight)) / final weight. Put the target in its own cell (F9) so you can try 80, 85 or 90.

This assumes your current % is your grade on everything except the final. A result above 100 means the target is out of reach on the final alone, so look for extra credit or aim lower. A result below 0 means you are safe even with a zero (but take the exam).

=ROUND(($F$9-E2*(1-F2))/F2,1)

Result: 86.2

To finish Calculus at 85% you need 86.2 on the final. Copy it down: Chemistry needs 95, so that is where the study time should go.

See what is due this week that you have not done

FILTER keeps the assignments that pass every test you multiply together: due within the next 7 days of the date in F10, and not marked Yes in Done. TEXTJOIN turns the result into one readable line.

Excel stores dates as day numbers, so F10+7 is simply the date a week later. In your own file you can replace the date in F10 with =TODAY() so the list is always current.

=TEXTJOIN(", ",TRUE,FILTER(A10:A12,(C10:C12<F10+7)*(D10:D12<>"Yes")))

Result: Problem set 7, Essay draft

Problem set 7 and Essay draft are still open this week. Lab report 4 is done, so it drops off.

Count down to a deadline

Subtract two dates to get the days between them. If you only study on weekdays, NETWORKDAYS counts Monday to Friday instead, and it includes both the start and end day: =NETWORKDAYS(F10,C10) returns 5 for the problem set.

If the result shows as a date like Jan 4, 1900, the cell has a date format. Set it to General to see the number of days.

=C10-F10

Result: 4

Problem set 7 is due in 4 days (Monday November 2 to Friday November 6).

Split your study hours by credits

A simple starting plan: give each class a share of your weekly study hours equal to its share of your credits. Divide the class credits by the total and multiply by the hours you have (F11). Lock the total and the hours with $ so it copies down.

Then adjust by hand. A class where you are below target, like Chemistry here, deserves more than its credit share; one you are acing can take less.

=ROUND(B2/SUM($B$2:$B$7)*$F$11,1)

Result: 3.3

Calculus is 4 of your 18 credits, so it gets 3.3 of your 15 weekly study hours.

Practice: 8 exercises

Use the sample data above. Type a formula and press Check: it is graded by a real spreadsheet engine, the way Cellwise grades lessons.

  1. 1How many credits are you taking in total?

    Show answer

    =SUM(B2:B7) = 18. 4 + 3 + 3 + 4 + 1 + 3 = 18 credits.

  2. 2How many classes are you at 90% or above in right now?

    Show answer

    =COUNTIF(E2:E7,">=90") = 3. Intro Psychology (93.2), English Comp (90.4) and Chem Lab (95) pass the test, so 3.

  3. 3Look up the grade points for Spanish II (row 7) from the scale in G2:H10.

    Show answer

    =XLOOKUP(C7,G2:G10,H2:H10) = 3. Spanish II is a B, and B is worth 3 on the scale.

  4. 4What is your average current percentage across all classes (not weighted)?

    Show answer

    =AVERAGE(E2:E7) = 88.116666667. The six percentages add up to 528.7, and 528.7 / 6 is about 88.1.

  5. 5How many quality points (credits x points) have you earned in total?

    Show answer

    =SUMPRODUCT(B2:B7,D2:D7) = 60.1. 13.2 + 12 + 11.1 + 10.8 + 4 + 9 = 60.1 quality points.

  6. 6What score do you need on the Spanish II final to finish at the target in F9?

    Show answer

    =(F9-E7*(1-F7))/F7 = 82. (85 - 86 x 0.75) / 0.25 = 82, so an 82 on the final lands exactly on 85%.

  7. 7How many credits are you earning an A or A- in?

    Show answer

    =SUMIF(C2:C7,"A",B2:B7)+SUMIF(C2:C7,"A-",B2:B7) = 7. SUMIF matches the whole cell, so "A" does not pick up "A-". A: 3 + 1 credits, A-: 3 credits, total 7.

  8. 8How many unfinished assignments are due before November 6, 2026?

    Show answer

    =COUNTIFS(C10:C12,"<"&DATE(2026,11,6),D10:D12,"<>Yes") = 1. Lab report 4 is done and Problem set 7 is due on the 6th itself, which leaves only Essay draft: 1.

Free templates for students

Guided project: Semester budget on a student income

Turn weekly, monthly and one-off money into a semester plan and a weekly spending number.

6 steps in the Cellwise app. Each step checks your formula in a real grid, with hints when you get stuck. Part of Cellwise Plus.

Open guided projects

Guides for these formulas

FAQ

How do I calculate my GPA in Excel?

Put each class's credits and grade points in two columns, then use =SUMPRODUCT(credits,points)/SUM(credits). Look the points up from your school's scale with XLOOKUP so letter grades convert automatically.

How do I figure out what I need on my final exam?

Use needed = (target - current x (1 - final weight)) / final weight, with the weight as a decimal. If your class is at 84.5% and the final is worth 30%, reaching 85% needs (85 - 84.5 x 0.7) / 0.3 = 86.2 on the final.

Is Excel or Google Sheets better for students?

Either works for everything on this page. Google Sheets is free and easy to share for group projects; Excel is often free through your school's Microsoft 365 account and is what many employers expect you to know.

How do I make a study schedule in Excel?

List your classes with their credits, then share your weekly study hours by credits: =ROUND(B2/SUM($B$2:$B$7)*hours,1). Adjust by hand for classes where you are below target, and put the hours into a weekly calendar.

Excel for other fields

Updated