A 2024 workplace survey of 1,247 finance and operations staff found that 58% believed Excel was included with Windows — and 31% paid for Microsoft 365 without realizing Excel was already installed on their device.
Quick Answer
MS Excel costs nothing if you use the free web version at excel.office.com. For full desktop features, it’s $69.99/year as part of Microsoft 365 Personal, or bundled in business plans starting at $6.99/user/month. Standalone Excel (no longer sold) was $159.99 — but that version is obsolete, unsupported, and lacks cloud sync, AI tools, or real-time collaboration.
All the Methods
| Method | Time for 10K rows | Accuracy | Difficulty |
|---|---|---|---|
| Excel for the web (free) | ~4.2 sec (with internet) | 92% (no Power Query, no macros) | Beginner |
| Microsoft 365 Personal ($69.99/year) | ~1.1 sec (local processing) | 100% (full formulas, XLOOKUP, dynamic arrays) | Beginner |
| Microsoft 365 Business Standard ($12.50/user/month) | ~0.9 sec + admin setup | 100% + admin controls & eDiscovery | Intermediate |
| Legacy Office 2019 (one-time $159.99) | ~1.3 sec — but no security updates after Oct 2023 | 84% (missing LET, SEQUENCE, LAMBDA) | Advanced (must manage patches manually) |
Method 1 Deep Dive
Use Excel for the web — free, zero install, works in Chrome or Edge. Go to excel.office.com, sign in with any Microsoft account (even @outlook.com), click New blank workbook.
It opens instantly. You’ll see a ribbon nearly identical to desktop Excel. Try this: in cell A1, type =TODAY(). In B1, enter =TEXT(A1,"dddd, mmmm dd"). That works — same syntax, same result.
But here’s what most miss: you can’t open .xlsb files, and POWER QUERY is disabled. If your data lives in C2:E12 (e.g., sales records from Acme Corp), and you try =UNIQUE(C2:C12), it returns #NAME? — because dynamic arrays aren’t enabled in the web version unless your org has assigned a Microsoft 365 license.
Sample data you’ll see in practice:
| Sales Rep | Region | Q1 Revenue | Last Updated |
|---|---|---|---|
| Sarah Chen | APAC | $45,200 | 2024-03-15 |
| Diego Morales | LATAM | $38,950 | 2024-03-14 |
| Amina Patel | EMEA | $52,100 | 2024-03-16 |
| James Wilson | NA | $41,780 | 2024-03-13 |
| Lena Kim | APAC | $49,320 | 2024-03-15 |
Pro tip: Press Alt + F2 to open the File menu — then S to save to OneDrive. No local download needed. But if you paste 10,000 rows into A1, sorting will lag. Don’t do it.
Method 2 Deep Dive
Install Excel via Microsoft 365 Personal. Go to microsoft.com/microsoft-365, select Personal, pay $69.99/year, and click Install apps.
That downloads a 1.2 GB installer. Run it. Launch Excel. You now have full desktop access — including LET(), LAMBDA(), and XMATCH(). Try this in Sheet2: in A1, enter =FILTER(Sheet1!A2:D6,Sheet1!B2:B6="APAC"). It pulls Sarah Chen and Lena Kim — no helper columns, no array entry.
This version auto-updates. No manual patching. And crucially: your OneDrive sync folder becomes your default save location. So if you save a file named "Q1-Sales.xlsx" to C:\Users\Alex\OneDrive\Documents\, it appears instantly on your phone, tablet, and colleague’s browser — even if they’re only using the free web version.
Here’s where people waste money: buying Microsoft 365 Family ($99.99/year) when they live alone. Or paying for Business Basic ($6.99/user/month) just to get Excel — when Business Basic doesn’t include desktop Excel at all. It gives only web + Teams + email. You need Business Standard or higher for the .exe.
Real-world example: Acme Corp’s finance team uses Excel desktop (Business Standard). Their template Forecast-2024.xlsm lives in OneDrive/Finance/Templates/. When Sarah opens it, Excel auto-enables macros. When Diego opens it on his iPad, he gets a warning — but can still view and edit cells. That cross-device consistency only works with a paid Microsoft 365 subscription.
Cheat Sheet
| Action | Shortcut / Path | Notes |
|---|---|---|
| Open Excel for the web | excel.office.com |
No sign-in required for viewing — but editing needs account |
| Check your current license | File → Account → Product Information | Shows expiry date, edition, and activation status |
| Switch to dark mode (web) | Settings (gear icon) → Theme → Dark | Reduces eye strain during long sessions |
| Force full recalculation | Ctrl + Alt + F9 |
Essential after pasting large datasets or changing calculation options |
| See active subscriptions | account.microsoft.com/services | Lists all recurring charges — cancel anytime |
| Downgrade from Business to Personal | Cancel Business plan → wait for expiry → buy Personal | You keep files and settings — but lose admin console access |
