If you have been buying Microsoft Office on a disc every few years, the shift to Excel for Microsoft 365 changes the rhythm completely. Instead of waiting three years for a "next version," you get rolling updates, new functions land monthly, and the spreadsheet on your laptop is the same spreadsheet your colleague edits from a browser two time zones away.

Microsoft renamed the product line in 2020 — what used to be Office 365 is now Microsoft 365, and the Excel inside it is officially "Excel for Microsoft 365." The icon looks similar, the ribbon looks similar, but underneath, the engine is doing far more.

This is the subscription edition. You pay yearly or monthly, and as long as your subscription is current you get every new function, every new chart type, every new AI feature the moment Microsoft ships it. Cancel and Excel falls back to read-only — your files stay yours, but new edits stop until you renew. That trade-off is the whole reason this guide exists.

For some people the subscription is the only way to get features like dynamic arrays and Copilot. For others, the one-time-purchase Office 2021 or 2024 LTSC still makes more sense. Let's walk through what you actually get, what it costs, and whether the perpetual licence is really the bargain it looks like.

By the end you will know exactly which Microsoft 365 plan covers Excel, which functions are exclusive to the subscription, how the update channels work, and how the maths compares to a one-time licence over five years. If you also want to brush up on the formula side while you read, our Excel functions list page lists every modern function alongside legacy ones, which is a useful companion to this article.

Let's get the naming history out of the way, because it confuses everyone. Until April 2020 the product was called "Office 365." Microsoft rebranded the consumer and small-business plans to "Microsoft 365" to signal that you are paying for more than the desktop apps — you are paying for OneDrive, Teams, Outlook.com integration, Defender, and a lot of cloud plumbing. The enterprise SKUs followed in 2022. The desktop Excel binary itself is now reported as "Excel for Microsoft 365" in File ▸ Account, and the build number ticks up roughly every month.

Why does that matter? Because if you search the web you will still find tutorials calling it "Excel 365," "Office 365 Excel," or "Excel Online" — and they are usually all referring to the same product family. Microsoft 365 is the umbrella; Excel for Microsoft 365 is the specific app on Windows and macOS; Excel for the Web is the browser version included in every plan; Excel Mobile is the iOS and Android edition. One licence covers all of them at once.

The single most important change is the update model. Office 2019 received only a handful of patches after release. Office 2021 was a snapshot of Microsoft 365 features as of late 2021 and is now frozen. Microsoft 365 keeps going — new keyboard shortcuts, new chart layouts, new data types appear on its own schedule. If you have ever wanted to use a function like XLOOKUP and discovered your colleague's Excel does not recognise it, the difference is almost always one of you is on the subscription and the other is not.

Pricing is where most people start, so let's lay out every consumer and business plan that includes the Excel desktop app. The numbers below are the official US list prices as of 2026; regional pricing varies and Microsoft adjusts them roughly every 18 months. Annual billing usually saves 15–17 percent versus paying monthly. All consumer plans include Word, PowerPoint and OneNote alongside Excel, plus 1 TB of OneDrive. The Personal plan covers a single user signed in on up to five devices simultaneously; Family extends that to six separate Microsoft accounts, each with their own 1 TB of cloud storage.

On the business side, the cheapest tier (Basic) is web and mobile only — you cannot install Excel on Windows or Mac. That trips up a lot of new buyers. If you need the desktop app, you must start at Business Standard. Apps for Business is an outlier: it gives you the desktop apps without Exchange, Teams or SharePoint, which is fine for solo operators but rare to see in larger organisations. Premium layers Defender, Intune device management and Copilot on top of Standard. Copilot is also available as a $30/user/month add-on to any qualifying plan.

The Excel cheat sheet we maintain is a handy reference for shortcuts and ribbon layouts that work identically across all of these tiers. Whether you are on Personal at home or Premium at work, the Excel interface and formula engine are the same. The differences live in the surrounding services: storage limits, who can co-author, whether IT can lock down which add-ins you install, and whether Copilot is available in the right rail.

If you spend any time inside Microsoft's documentation you will see references to update channels. This is the mechanism that decides when new Excel features arrive on your machine. Knowing which channel you are on matters when you are troubleshooting — a function that works on your colleague's machine but throws #NAME? on yours is almost always a channel mismatch.

Microsoft runs three main channels for Excel. Current Channel is the default for consumer subscriptions and most small businesses. New features ship roughly once a month, and security patches arrive within days of release. If a user-visible function like LAMBDA or TEXTSPLIT appears in the Insider builds, Current Channel users typically see it 30 to 60 days later.

Monthly Enterprise Channel is the same payload bundled on the second Tuesday of each month, designed for IT teams that want a predictable patch window. Semi-Annual Enterprise Channel ships only in January and July, with extended servicing — chosen by regulated environments and labs that prize stability over novelty.

If you are on Semi-Annual today, your Excel still does not know what XLOOKUP is — at least not the spilling, dynamic-array version. That is the most common reason an enterprise user feels "left behind" compared to a home user on Current. You can switch channels through the Office Deployment Tool, but most users have it locked by their IT department. Check File ▸ Account ▸ About Excel to see your channel and build number.

Now the part that matters most to spreadsheet builders: which functions actually require Microsoft 365? The headline list is shorter than people think but unusually powerful. XLOOKUP replaces VLOOKUP and HLOOKUP with a cleaner syntax that searches left or right, returns vertical or horizontal results, and supports approximate, exact and wildcard matching natively.

It is the single most-requested function for the past four years. FILTER returns rows that meet a condition as a spilled array, no helper columns required. SORT and SORTBY do the same for ordering. UNIQUE dedupes a range in one keystroke. SEQUENCE generates a numeric series. RANDARRAY fills any rectangle with random numbers.

Then there are the formula-engineering functions. LET assigns names to intermediate calculations inside a single formula, so you stop writing the same long expression three times. LAMBDA lets you define a reusable function in pure formula language — no VBA, no Office Scripts — and call it from any cell. Combined with LET, LAMBDA turns Excel into a small functional-programming environment. Pair it with BYROW, BYCOL, MAP, REDUCE and SCAN and you can replicate most pandas operations directly in a workbook.

And then the small-but-friendly additions: IFS replaces nested IFs; SWITCH compares an expression to a list of values; TEXTBEFORE, TEXTAFTER, TEXTSPLIT and TEXTJOIN handle strings the way Python's str methods do. None of these exist in Office 2019. Some were backported to Office 2021 (XLOOKUP, FILTER, LET, IFS, SWITCH) but LAMBDA and the array-iteration helpers stayed exclusive to Microsoft 365. If your work depends on those, the subscription is not optional.

Talking of Copilot, the AI assistant deserves its own paragraph because it is the most disruptive Excel feature in a decade. Microsoft 365 Copilot for Excel appears as a sidebar that accepts natural-language prompts: "Summarise sales by region," "Highlight rows where margin is below 12 percent," "Build a pivot showing units by quarter and product family." Copilot then writes the formula, applies the formatting, or builds the pivot table for you. Behind the scenes it uses GPT-4-class models grounded in your workbook content, so it can refer to actual cell ranges and column names rather than guessing.

Copilot is not included in every Microsoft 365 plan. Consumers get it through Copilot Pro at $20/month layered on top of Personal or Family. Businesses can add Microsoft 365 Copilot to Standard, Premium or Apps for Business at $30/user/month — and it requires an annual commitment plus active M365 subscription. If you want to try the patterns without paying, our Microsoft Copilot for Excel guide walks through the most useful prompts and shows the boundaries where Copilot tends to hallucinate.

Beyond functions and Copilot there is a quieter set of features that only the subscription unlocks. Dynamic arrays are the most important. Type a single formula into one cell and watch the result "spill" into the cells below or to the right, with a blue outline marking the spilled range. The original cell is the only formula you maintain — change it and the whole range updates. Office 2019 cannot do this; Office 2021 added it but kept the array-helper functions limited. Microsoft 365 is the only edition with the full picture.

Cloud-only abilities are equally important. AutoSave turns every keystroke into a saved revision in OneDrive or SharePoint — close the file without thinking, every change is preserved. Real-time co-authoring shows your colleagues' cursors moving across the sheet, and a presence pill in the top-right indicates who is editing what.

Linked data types let you type "Apple Inc." in a cell, mark it as a Stocks data type, and then pull dozens of attributes (CEO, market cap, P/E ratio) into adjacent cells. The Geography data type does the same for cities and countries. Both of these talk to Microsoft's live data services and only work while online and subscribed.

Maps and 3D charts live in the same camp. The Filled Map chart geocodes any column of place names and renders a choropleth. 3D Maps (formerly Power Map) plays animated heat maps over time. Insights and Ideas are now bundled under Analyze Data — click the button and Excel proposes pivots, trend lines and outlier flags you might have missed.

Power Query in the cloud is the newest addition: Refresh-on-open used to require the desktop app, but Web users can now schedule Power Query refreshes against Dataverse and Fabric sources. For more on the everyday tooling, our walkthroughs of how to add a pivot table in Excel and how to create a VLOOKUP in Excel use only features that work identically in every M365 tier.

Let's run a five-year cost comparison since that is the longest most people keep a major workflow tool. Microsoft 365 Personal at $69.99/year is $349.95 over five years. Office Home & Business 2021 is $249.99 once. On paper the perpetual licence wins by $100. But the perpetual licence has no OneDrive — adding 1 TB of OneDrive Standalone is $1.99/month or $23.88/year, which is $119.40 across five years.

Now perpetual is $369.39 — already more expensive than the subscription, before counting the value of getting LAMBDA, Copilot and every other new function. Add the second device you forget to license, or the family member you wanted to cover, and the gap widens further.

For business, the equivalent maths uses Microsoft 365 Apps for Business at $8.25/user/month — $495 over five years per user. Office Standard 2021 perpetual is roughly $440 with volume licensing. The numbers are closer here, but again that perpetual licence comes with zero cloud, zero Copilot eligibility, and no path to LAMBDA. Most CFOs end up choosing the subscription once they realise the perpetual costs do not include security updates beyond five years.

If you are still building basic formulas, our how to create a formula in Excel and how to create a filter in Excel primers work identically on every edition, so do not feel pushed to upgrade just to follow along. The subscription becomes a clear win the moment you adopt dynamic arrays — at that point the work simply cannot be done on Office 2019 and only partially on 2021.

One last practical thing — what happens to your files if you cancel? Excel for Microsoft 365 enters a "reduced functionality" mode after the subscription lapses. You can still open every .xlsx file you own, you can still print, you can still copy data out. What you cannot do is edit.

New cells, new formulas, even fixing a typo will all be blocked until you renew or buy a perpetual licence to migrate to. The 1 TB of OneDrive shrinks to the free 5 GB allotment over a 90-day grace period; anything above 5 GB gets flagged and eventually trimmed. So always keep a local copy of important workbooks before letting a subscription lapse, just in case.

On the bright side, Microsoft makes downgrading easy. You can switch from Personal to Family or vice versa from your account page at any time, with the new pricing applied at the next renewal. You can also pause month-to-month payments instantly — there is no contract on monthly plans. Annual plans refund prorated for the unused months. And if you accidentally bought Business Basic only to discover you need the desktop app, Microsoft will let you upgrade to Standard with a single click and only charge the difference.

For most spreadsheet users in 2026, Excel for Microsoft 365 is the sensible default. The functions are stronger, the collaboration is real, the storage is generous, and the bug fixes never stop. It is only when you have a specific reason — air-gapped environments, regulated compliance, dislike of subscriptions on principle — that the perpetual licence still makes sense. Whichever you choose, the file format is the same .xlsx, so you can always switch later without leaving any workbook behind.