This is more of a template than tutorial, but i've attempted to create a file that will hopefully help others calculate their GPA's easily.

I have a table that looks like this:

It should be pretty straightforward, but I want to clarify a couple of things:

1. There's a tab that contains numerical equivalents of letter grades. I used A,A+ = 4, A- = 3.66.., B=3, C=2, etc. Feel free to change them if you use a different system. But make sure you order that tab otherwise it won't calculate right.
2. I used 1,0.5 for credits, which is what I had at Swarthmore, but it will work fine if you change them to 3's, 4's, 19's...
3. I have two majors listed on the right. Use it like a checkbox; major gpa is evaluated if there's a 1 in the box (0,2,3,x) will have no effect
4. You may also use one of those majors to calculate your junior-senior gpa, or even junior-senior major gpa (this bullet was even more obvious than the previous ones, sorry)
5. You can use lowercase for letter grades but you shouldn't use extra spaces or other characters
6. finally, use at your own risk. If this template shows your gpa lower or higher than what it really is, your fault :)

two versions of excel documents here:

excel 95-2003	excel 2007

problems?