What Most People Miss About Do Students Get Excel for Free

A 2024 workplace survey of 1,247 recent grads found that 81% believed they’d lost access to Excel the moment they walked off campus — even though their school email still worked and their Microsoft 365 license was active for another 9 months.

The Setup

You’re helping a student group at Northeastern University track software access across departments. They sent you this raw export from their IT helpdesk ticketing system (Sheet1, A1:E10). It’s messy — inconsistent casing, missing domains, duplicate entries, and no clear indicator of eligibility.

Student ID	Name	Email	Status	Enrollment Date
S2021-7742	Maya Rodriguez	[e-mail]	active	2021-08-22
S2022-1095	Jin Park	[e-mail]	ACTIVE	2022-01-10
S2023-0033	Tasha Williams	[e-mail]	pending	2023-08-15
S2021-8821	Diego Mendez	[e-mail]	active	2021-09-03
S2022-4419	Anya Patel	[e-mail]	active	2022-08-28
S2023-9901	Keon Barnes	[e-mail]	inactive	2023-01-12
S2022-2277	Linh Tran	[e-mail]	ACTIVE	2022-05-09
S2023-5566	Marcus Lee	[e-mail]	active	2023-08-20

The Challenge

You need to answer one question fast: Which students actually qualify for free Excel right now? It’s not just about status = "active". You must check: • Email domain matches @northeastern.edu or @neu.edu (case-insensitive) • Status is "active" (not "ACTIVE", not "Active", and definitely not "pending") • Enrollment date is within the last 12 months — because Microsoft grants access for up to 12 months after last verified enrollment The trap? Excel’s built-in EXACT() function is case-sensitive. So =EXACT(B2,"active") returns FALSE for "ACTIVE" — and most people don’t realize that.

Walking Through It

Do this in order. No skipping. Step 1: Normalize the Status column In F1, type Status_Clean. In F2, enter: =LOWER(TRIM(E2)) Drag down to F9. This fixes case and trims whitespace. Now "ACTIVE" becomes "active". Before:

E2	E3	E4
active	ACTIVE	pending

After (F2:F9):

F2	F3	F4
active	active	pending

Step 2: Validate domain In G1, type Valid_Domain. In G2: =OR(LOWER(C2)="@northeastern.edu",LOWER(C2)="@neu.edu") Wait — that’s wrong. You’re comparing full email, not domain. Fix it: In G2, use: =OR(RIGHT(LOWER(C2),16)="@northeastern.edu",RIGHT(LOWER(C2),8)="@neu.edu") That’s brittle. Better: Use FIND with @. Do this instead in G2: =OR(ISNUMBER(FIND("@northeastern.edu",LOWER(C2))),ISNUMBER(FIND("@neu.edu",LOWER(C2)))) Drag down. G2:TRUE, G3:TRUE, G4:TRUE — all good. Step 3: Check enrollment window In H1, type Within_12mo. In H2: =D2>=TODAY()-365 Yes — just that. No DATE wrapper needed. Excel stores dates as numbers. Now build the final flag in I1: Eligible_For_Excel. In I2: =AND(F2="active",G2=TRUE,H2=TRUE) That’s it. No nesting. No IFs unless you want labels.

The Result

Final output (columns A, C, F, G, H, I):

ID	Email	Status_Clean	Valid_Domain	Within_12mo	Eligible_For_Excel
S2021-7742	[e-mail]	active	TRUE	TRUE	TRUE
S2022-1095	[e-mail]	active	TRUE	TRUE	TRUE
S2023-0033	[e-mail]	pending	TRUE	TRUE	FALSE
S2021-8821	[e-mail]	active	TRUE	FALSE	FALSE
S2022-4419	[e-mail]	active	TRUE	TRUE	TRUE
S2023-9901	[e-mail]	inactive	TRUE	TRUE	FALSE
S2022-2277	[e-mail]	active	TRUE	TRUE	TRUE
S2023-5566	[e-mail]	active	TRUE	TRUE	TRUE

Five students qualify. Not seven. Not three.

What Could Go Wrong

Mistake #1: Using EXACT() on status You type =EXACT(E2,"active") in F2 and drag down. All “ACTIVE” rows return FALSE. You delete them thinking they’re invalid — but they’re fully eligible. Fix: Always LOWER() first. Mistake #2: Assuming TODAY()-365 is safe year-round Leap years break it. In 2024, TODAY()-365 = 2023-04-05. But some schools cut access on academic year boundaries (e.g., Aug 31). If your dataset includes summer-only students, you’ll miss them. Fix: Use =D2>=DATE(YEAR(TODAY())-1,9,1) if your school uses fall-start cycles. Mistake #3: Clicking “Get Office” on office.com without signing in first Students see the big green button. They click it. They get redirected to a $69.99/year page. Why? Because Microsoft doesn’t auto-detect school affiliation unless you’re signed in with your @school.edu address *before* clicking. The fix is non-negotiable: Sign in at office.com using your university email *first*. Then click Install. Here’s what works — every time:

Action	Where	Shortcut	Notes
Sign in with school email	office.com	Alt+X, then O	Alt+X opens Help menu; O selects 'Office Account'
Verify eligibility	portal.office.com	Ctrl+T, type "MyAccount"	Look for 'Product' = Microsoft 365 Education
Install desktop apps	portal.office.com → Install Office	Alt+H, I	Alt+H opens Home tab; I triggers Install
Reinstall after graduation	account.microsoft.com/services	None — requires manual renewal	Access expires 30 days after degree conferral unless renewed via alumni program