Degree Audit Excel Template: Build a Clear Credit Tracker

How-to basics · Updated November 22, 2026

A degree audit Excel template is a workbook for comparing completed and planned coursework with degree requirements. You can build a useful tracker with a course log and a requirement summary, but treat it as a planning aid—not an official audit: your college’s current catalog and registrar determine whether a course counts.

What a degree audit template tracks

A degree audit compares what a student has completed with what a program requires. Depending on the institution and degree, the requirements may include total credits, general education areas, major courses, electives, minimum grades, residency credits, and prerequisites. A spreadsheet can organize this information and make unmet requirements easier to spot. It cannot decide institutional questions such as whether a transfer class is equivalent to a specific course or whether an exception has been approved.

A practical workbook separates the course facts from the rules being checked. That separation makes it easier to update the requirements without rewriting the course history. Start with two worksheets:

  • Course Log: one row per course, with course code, title, credits, status, and the requirement category to which you are assigning it.
  • Requirement Summary: one row per requirement category, with the required credits, completed credits, remaining credits, and a simple progress status.

For example, a student might list completed courses under categories such as General Education, Biology Major, and Free Electives. The summary can total the credits assigned to each category and show the shortfall. Keep a separate notes column or worksheet for catalog-year rules, adviser guidance, transfer evaluations, and any approved substitutions.

Set up the workbook in Excel

In Excel for Microsoft 365 on Windows, create worksheets named Course Log and Requirement Summary. On Course Log, enter these headings in row 1: Course Code, Course Title, Credits, Status, and Category. Put one course in each row below. On Requirement Summary, use Requirement, Required Credits, Completed Credits, Credits Remaining, and Check as the headings.

Enter course credits as numbers, such as 3 or 4, rather than text like “3 credits.” Use consistent status values, for example Completed, In progress, and Planned. Assign each course to a category only after checking your program rules. A transfer course may need a formally approved equivalency before you can treat it as a particular requirement.

For easier sorting and expansion, convert each range to an Excel table: select the range, then choose Insert > Table and confirm that the table has headers. Give the tables clear names using Table Design > Table Name, such as CourseLog and ReqSummary. Formulas can also use ordinary cell ranges, as in the examples below. On Excel for Mac, the same table feature is available from the Insert tab; exact ribbon placement can vary slightly by version. Excel for the web also supports tables, though some ribbon controls may appear in different locations.

Calculate completed credits by requirement

Assume the Course Log has credits in C2:C200, status in D2:D200, and category in E2:E200. Assume the Requirement Summary has the category name in A2 and required credits in B2. In C2 on the summary sheet, this formula adds credits only for courses in that category whose status is Completed:

=SUMIFS('Course Log'!$C$2:$C$200,'Course Log'!$E$2:$E$200,A2,'Course Log'!$D$2:$D$200,"Completed")

If the course log contains 3 completed Biology Major courses worth 3, 4, and 3 credits, and their category cells all say Biology Major, the result is 10. An in-progress course is not included, so the completed total does not imply that the student has already earned those credits. Copy the formula down the summary for the other categories, adjusting the row reference automatically.

With the requirement category in A2, the required credits in B2, and completed credits in C2, enter this in D2 to show the remaining amount without displaying a negative number when the requirement is met:

=MAX(0,B2-C2)

If the requirement is 30 credits and the completed total is 21, the result is 9. If completed credits reach 30 or more, the result is 0. This calculation checks only credit totals; it does not validate course level, grade, prerequisites, or other restrictions.

With completed credits in C2 and required credits in B2, this formula in E2 labels the credit total:

=IF(C2>=B2,"Credit total met","Needs credits")

For a 30-credit requirement with 21 completed credits, the result is “Needs credits.” Reaching 30 returns “Credit total met,” which is deliberately narrower than “Requirement complete.” Use wording that does not suggest the spreadsheet has confirmed every academic rule.

Represent specific courses and non-credit rules

Credit totals alone are not enough for a degree audit. A program may require a named course, a sequence, a minimum grade, or a choice from an approved list. Add a separate checklist for those conditions, with columns such as Requirement, Required Course or Rule, Student Course, Status, and Source or Notes. For instance, a “Research Methods” requirement might list the course number specified in the catalog and record whether an adviser or official audit has confirmed an equivalent.

A course can sometimes apply to more than one requirement, but double-counting rules vary. The simple SUMIFS setup above assigns each course row to one category, which helps avoid accidentally counting the same credits twice. If official rules allow one course to meet two areas, document that explicitly and make the workbook’s allocation match the school’s policy. Do not duplicate a course row just to make multiple totals appear satisfied unless the institution confirms that treatment.

Some requirements are not measured in credits. Examples include completing a placement, submitting a portfolio, meeting a language requirement, or earning a minimum grade in a course. Track these as checklist items with statuses such as Not started, In progress, and Confirmed. Do not add them to the credit formulas. A note that names the source and date—such as an adviser email or catalog section—helps distinguish verified information from a student’s estimate.

Make data entry consistent and readable

Small data-entry differences can make a summary misleading. “General Education,” “Gen Ed,” and “General education” may be treated as different category text. Use a controlled list for status and category fields where possible. In Excel for Microsoft 365 on Windows, select the cells, then choose Data > Data Validation and set Allow to List. Supply the allowed entries, such as Completed, In progress, and Planned. Excel for Mac also has Data Validation on the Data tab, although the dialog layout can differ.

Use clear visual cues, but do not let formatting stand in for a calculation. Select the summary status cells and choose Home > Conditional Formatting to highlight “Needs credits” or other attention states. Add filters to the course log so you can view only in-progress courses or one category at a time. Keep a visible note that credits shown as completed are based on the entries in the workbook and must be checked against the official record.

For readability, freeze the header row, use consistent number formats for credits, and avoid merged cells inside data tables. If multiple people will edit the workbook, protect formula cells from accidental changes while leaving input cells editable. Save a dated copy before making major revisions, especially when changing requirement categories or importing a new academic record.

Check the rules before trusting the totals

Before entering data, identify the correct degree, major, catalog year, and any concentration or minor being tracked. Requirements can change between catalog years, and a student may follow a different set of rules from a newly admitted student. Confirm whether the institution counts transfer, test, repeated, remedial, or in-progress credits in the way the spreadsheet assumes. Also check whether a minimum grade or upper-level credit requirement applies.

Compare the workbook with the institution’s official degree audit or advising materials. Resolve differences with the registrar or academic adviser rather than changing a formula until the numbers look convenient. Record how a disputed course was evaluated, when the information was confirmed, and who confirmed it. This is particularly important for transfer credit, substitutions, waivers, repeated courses, and courses that may satisfy multiple areas.

Do not include sensitive information that is unnecessary for planning. A student ID, personal contact details, or another student’s academic record should not be casually shared in a workbook. If the file is stored in cloud storage or emailed, consider who can access it and follow the institution’s policies for student information. A spreadsheet is not automatically an approved record system just because it contains academic data.

Common spreadsheet problems

  • In-progress credits look completed: A formula that sums every row in a category can overstate earned credits. Filter by the Completed status, as the SUMIFS example does.
  • A category total is too high: Check for duplicated course rows, inconsistent category names, or a course assigned to the wrong area. Confirm the school’s double-counting rules.
  • A course appears not to count: Check spelling and status values, then verify whether the course is approved for that requirement. Excel matching cannot establish academic equivalency.
  • The remaining-credit figure is zero, but the requirement is not satisfied: A credit threshold may have been reached while a required course, grade, level, or non-credit condition remains incomplete.
  • Totals change unexpectedly: Look for formulas overwritten by pasted values, rows outside the formula range, or credits stored as text. An Excel table can expand more reliably as new rows are added, but verify that summary formulas include them.

One useful review is to sort the course log by status and then by category. Check that every completed course has a recorded credit value and a defensible category. Next, compare the summary against the official audit requirement by requirement, not just by total credits. A student can have enough credits overall and still be short of a particular major or general education requirement.

Template versus official audit software

An Excel tracker is flexible: students can add notes, plan future terms, compare scenarios, and view their own categories in a compact summary. It is also easy to adapt when a program has unusual rules. Its weakness is that the student must maintain the data and encode the rules correctly. Excel does not automatically know the current catalog, course equivalencies, grade policies, or approved exceptions.

An institution’s degree-audit system typically draws on the student record and applies program rules maintained by the school, although the details and accuracy depend on the institution’s systems and records. It may still need human review, particularly for exceptions or transfer work. Use the official audit for decisions about eligibility and graduation; use Excel as a companion for planning and for preparing focused questions for an adviser.

A printable checklist or notes app may be sufficient if a student has only a few requirements to track. A spreadsheet becomes more useful when the student wants category totals, a term-by-term plan, or a record of unresolved questions. There is no need to add complicated automation unless it reduces a real source of error.

Frequently Asked Questions

Can I download an official degree audit Excel template?
There is no single official template that applies to every college. Some schools provide their own worksheets, but requirements and approved course substitutions are institution-specific. Check the registrar or advising website first, then use a general workbook only as a supplemental tracker.

Can Excel tell me whether I will graduate on time?
It can help you map remaining credits and planned courses, but it cannot guarantee a graduation date. Course availability, prerequisites, registration priority, grades, program rules, and administrative approvals can affect a plan. Confirm your course sequence with an academic adviser.

Should in-progress courses count toward completed credits?
Usually, a planning sheet should show them separately from completed credits. You can list their status as In progress and include them in a future-plan view, but label any projected total clearly. Whether they satisfy a requirement depends on successful completion and the institution’s rules.

How do I track transfer credits?
Record the credits and the institution or source, but do not assume a transfer course meets a particular major requirement based only on its title. Use the school’s official transfer evaluation or ask an adviser to confirm its equivalency and applicable category.

Can one course satisfy two degree requirements?
Sometimes, but policies differ by institution, program, and requirement type. Do not count it twice in a spreadsheet unless the applicable rules allow that. Record the confirmed allocation or double-counting decision in the workbook notes.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.