What Most People Miss About Does Excel Come With Microsoft 365
By Emily Watson
Yes, Excel comes with Microsoft 365 — but only if you’re signed in *and* connected at least once every 30 days. Otherwise, it goes into reduced-functionality mode, and you won’t get a clear warning until you try to save a pivot table or paste values from Power Query.
The Setup
You’re managing a quarterly sales tracker for six regional teams. Your raw data lives in Sheet1, columns A–E: Sales Rep (A), Region (B), Deal Date (C), Contract Value ($, D), and Status (E). You’ve just imported it from a CSV that came from Salesforce — and yes, it has duplicates, inconsistent date formats, and two entries for "Sarah Chen" labeled as both "Active" and "On Leave".
Sales Rep
Region
Deal Date
Contract Value
Status
Sarah Chen
APAC
2024-03-15
$45,200
Active
James Rivera
EMEA
15/03/2024
$62,800
Closed
Aisha Patel
North America
2024-02-28
$31,450
Pending
Sarah Chen
APAC
2024-03-15
$45,200
On Leave
Diego Morales
Latin America
03/15/2024
$57,100
Active
Lena Kim
APAC
2024-04-02
$29,600
Closed
James Rivera
EMEA
15-Mar-2024
$62,800
Closed
Tariq Hassan
EMEA
2024/03/10
$73,900
Active
Aisha Patel
North America
28-Feb-2024
$31,450
Pending
Diego Morales
Latin America
2024-03-15
$57,100
Active
The Challenge
You need one clean, deduplicated, date-normalized list — but here’s the catch: your team uses Excel on Windows, Mac, and iPads. Some people work offline for days. And no one knows whether their Excel is actually part of Microsoft 365 or just an old perpetual license they inherited from IT.
That matters because Excel in Microsoft 365 gives you dynamic arrays, XLOOKUP, and Power Query refresh on demand. The perpetual version (like Office 2019) doesn’t. Worse: if someone opens this file on a machine with only Excel Online (free tier), they’ll see formulas like =UNIQUE(A2:A11) return #NAME? — with zero explanation.
And yes — Excel *does* come with Microsoft 365. But not the way most assume. It’s tied to your Microsoft account, your subscription status, and your device activation count. Go over five activated devices? Excel stops syncing cloud files unless you deactivate one first. (Trust me, I learned this the hard way after helping a client recover from a shared family account.)
Walking Through It
Start by checking what version you’re actually running. Press Alt + F + T → click “Account” → look under “Product Information.” If it says “Microsoft 365 Apps for enterprise” or “Microsoft 365 Personal,” you’re good. If it says “Excel 2021” or “Office LTSC,” you’re not getting updates or cloud features — even if you log in to office.com.
Now, let’s clean that dataset. First, fix dates. Select column C (C2:C11), press Ctrl + H, find “/”, replace with “-”, then apply format yyyy-mm-dd via Format Cells → Number → Custom.
Before:
Deal Date
2024-03-15
15/03/2024
2024-02-28
2024-03-15
After cleaning and reformatting:
Deal Date
2024-03-15
2024-03-15
2024-02-28
2024-03-15
Next, remove duplicates — but carefully. Don’t just highlight A2:E11 and click Remove Duplicates. That will delete Sarah Chen’s second row without telling you which Status was kept. Instead, insert a helper column in F2: =A2&B2&C2&D2. Then use =UNIQUE(F2:F11) in G2. That tells you exactly how many *logical* duplicates exist — and lets you manually verify before deleting.
Then, use Power Query (Data → Get Data → From Table/Range) to load the cleaned range A1:E11. In Power Query Editor, right-click the “Status” column → “Remove Duplicates” → choose “Keep First.” Close & Load. This preserves the first instance — which, in our case, is the “Active” version for Sarah Chen.
The Result
Here’s your final, production-ready table — now consistent, deduped, and safe to share across all devices:
Sales Rep
Region
Deal Date
Contract Value
Status
Sarah Chen
APAC
2024-03-15
$45,200
Active
James Rivera
EMEA
2024-03-15
$62,800
Closed
Aisha Patel
North America
2024-02-28
$31,450
Pending
Diego Morales
Latin America
2024-03-15
$57,100
Active
Lena Kim
APAC
2024-04-02
$29,600
Closed
Tariq Hassan
EMEA
2024-03-10
$73,900
Active
What Could Go Wrong
You click “Remove Duplicates” on the whole table — and lose the only record with “Pending” status. Excel doesn’t ask which duplicate to keep. It defaults to the top row. If your data isn’t sorted by status first, “Active” might overwrite “Pending” silently. Always sort Status (Z→A) before deduping if priority matters.
You open the file on a Mac with Excel 16.83 (pre-Microsoft 365), and XLOOKUP returns #NAME?. That version shipped before XLOOKUP existed. Even if you’re logged into a Microsoft 365 account, the app itself must be updated. Check Help → About Excel — not your account page.
You save the file to OneDrive, assume auto-sync means it’s always current — but your colleague opened it in Excel Online (free) and edited offline in the desktop app without syncing. Conflict copies appear with names like “Sales Q2 (Conflicted Copy).xlsx”. They’re easy to miss — especially since Excel doesn’t flag them in the tab bar. Always check File → Info → Version History before presenting.
Here’s what you actually get — and don’t — with Microsoft 365 Excel:
Feature
Included?
Notes
XLOOKUP, FILTER, SEQUENCE
✓
Only in Microsoft 365 apps — not Excel for the web (free tier) or perpetual licenses.
Power Query (Get & Transform)
✓
Full desktop editor included. Excel Online only supports basic refresh.
Co-authoring in real time
✓
Requires OneDrive/SharePoint and >1 Microsoft 365 license.
Offline use
✓
But requires sign-in every 30 days. No grace period.
AI-powered Insights (Analyze Data)
✓
Only in Microsoft 365 Business Standard or higher — not Personal.
VBA macro support
✓
But macros are blocked by default in Excel for the web.
Emily Watson
Emily is an expert in workplace culture and team dynamics. Her articles help professionals navigate interpersonal challenges and build better coworker relationships.
