Microsoft 365 Excel is the subscription edition of Excel that ships inside the Microsoft 365 bundle. It is not a separate product — it is the same spreadsheet engine you already know, refreshed with features Microsoft only delivers to subscribers. New functions, AI tools, and cloud-native collaboration arrive here first. Standalone perpetual versions like Excel 2021 and Excel 2024 stay frozen on the day they shipped.
That distinction matters. When a colleague sends you a workbook that uses TEXTSPLIT or GROUPBY, those formulas only resolve if you also run a subscription build. Open the same file in Excel 2019, and you will see #NAME? errors where the new functions should be. The split is bigger than most people realise, and it grows every quarter as Microsoft pushes another wave of subscriber-only features.
This guide walks through what comes bundled with Microsoft 365 Excel, which features are exclusive to it, how it compares to the one-time-purchase versions, and the practical workflow gains you should expect day-to-day. If you are weighing whether to switch — or whether to stay put — you will find the answer here. We will also touch on certification paths, Copilot pricing, and the small print that catches buyers out.
One quick note before we get started. Microsoft 365 Excel runs on Windows, Mac, the web, iPad, iPhone, and Android. Most features are identical across desktop platforms, but a handful — Power Pivot, Power Query authoring, and the new Python in Excel — are Windows-only. Mac users get parity for everyday tasks, but heavy analytics workflows still favour the PC. If you sit in a mixed shop, plan around the gap.
The subscription pulls ahead of perpetual Excel in five areas: dynamic arrays, AI integration, real-time collaboration, advanced data types, and new chart types. Each one shifts how you build spreadsheets, and together they make the gap between editions hard to ignore.
Dynamic arrays alone changed everything. Functions like FILTER, SORT, UNIQUE, SEQUENCE, and the newer TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, TOROW, TOCOL, CHOOSEROWS, CHOOSECOLS, and GROUPBY let you write one formula in a single cell and have it spill across as many rows or columns as needed. No more dragging fill handles. No more wrapping formulas in array-entry brackets. If you already know Excel formulas well, the transition is genuinely fun — you start solving problems in two lines that used to need 20.
Copilot in Excel is the headline addition. It sits in the ribbon and answers natural-language questions about your data. Ask it to summarise a sales table by region, highlight outliers, or suggest a formula, and it builds the output for you. Copilot is not bundled with the base Microsoft 365 plan — it is a separate add-on at $30 per user per month — but it leans on workbook features that only the subscription version exposes.
Real-time co-authoring lets multiple people edit the same workbook at the same time, with cursors visible to each other. The file lives in OneDrive or SharePoint, and changes appear instantly. Perpetual Excel can open the same files, but only one person at a time gets write access. For teams running shared trackers, budgets, or planning sheets, the difference is night and day.
Stocks, Geography, and other linked data types live only in the subscription. Type a company ticker into a cell, mark the column as Stocks data type, and Excel pulls live financial data — price, market cap, P/E — straight from the cloud. The same trick works for cities, countries, foods, movies, and a growing list of categories. Charts have expanded too: funnel, sunburst, treemap, waterfall, and box-and-whisker charts are all subscription-first. Many of these eventually appear in perpetual releases, but the gap is usually two to four years.
Open Excel, click File > Account, and look under the Product Information section. If it says Microsoft 365 Apps for business, Microsoft 365 Apps for enterprise, or Microsoft 365 Personal/Family, you have the subscription. If it says Office Home & Student 2021, Office Home & Business 2024, or anything ending in a year, you are on a perpetual licence. The difference matters for feature access.
Excel does not have its own subscription. You buy it as part of a Microsoft 365 plan, and the price depends on which tier you pick. For personal use, Microsoft 365 Personal is $9.99 per month or $99.99 per year and covers one person across five devices. Microsoft 365 Family is $12.99 per month or $129.99 per year and covers up to six people. Both plans include Word, Excel, PowerPoint, OneNote, Outlook, 1 TB of OneDrive storage per user, and Skype minutes.
Business plans start at Microsoft 365 Business Basic, which is $6 per user per month but only includes the web and mobile versions of Excel. To get the desktop app on Windows or Mac, you need Microsoft 365 Business Standard at $12.50 per user per month, Microsoft 365 Business Premium at $22 per user per month, or one of the enterprise plans. Apps for business — desktop apps without Teams, SharePoint, or Exchange — sits at $8.25 per user per month.
Compare that to the one-time purchase. Excel 2024 standalone is $159.99, and Microsoft Office Home & Business 2024 (which bundles Word, Excel, PowerPoint, and Outlook) is $249.99. If you use Excel daily for ten years and never need new features, the perpetual licence is cheaper. If you want dynamic arrays, Copilot, or live data types, the subscription is the only path.
There is one more wrinkle. Copilot Pro is $20 per user per month on top of any consumer Microsoft 365 plan, and Microsoft 365 Copilot for Business is $30 per user per month on top of the business subscription. Without that add-on, the AI side of Microsoft 365 Excel stays mostly dormant. If Copilot is the reason you are upgrading, factor in the full stack cost — not just the base plan.
Single user, 5 devices. Includes Word, Excel, PowerPoint, Outlook, 1 TB OneDrive.
Up to 6 people, each with their own 1 TB OneDrive and full app access.
For businesses needing the desktop apps plus Teams, SharePoint, and Exchange.
Adds advanced security, device management, and Intune. Aimed at SMBs with compliance needs.
Excel 2024 is the latest one-time-purchase release, and it picked up many of the features Microsoft 365 introduced over the past four years. Dynamic arrays, XLOOKUP, FILTER, SORT, UNIQUE, the new LET function, and improved charts all made it across. If you compare Microsoft 365 Excel and Excel 2024 side by side today, they look almost identical for most everyday work.
The gap shows up in three places. First, Copilot in Excel only runs on the subscription. Excel 2024 will never get AI features — that is the whole point of a frozen perpetual release. Second, the latest dynamic array functions (GROUPBY, PIVOTBY, the Python in Excel preview, the form-filler input pane) are subscription-only. Third, security updates last only five years on Excel 2024 — Microsoft will stop patching it in October 2029. Microsoft 365 stays current forever, with monthly feature drops on the current channel.
Excel 2021 is now noticeably behind. It got the first wave of dynamic arrays — XLOOKUP, LET, FILTER, SORT — but missed everything Microsoft shipped after late 2021. No TEXTSPLIT, no VSTACK, no GROUPBY, no Copilot, no Python. Workbooks that use those functions will throw #NAME? errors when opened in 2021. If you are still on this version and you collaborate with subscription users, the friction is constant.
The decision usually comes down to how you use Excel. Light users who build basic budgets, track expenses, and run simple formulas are well served by Excel 2024 or even Excel 2021. Heavy users who write complex formulas, build dashboards, run financial models, or share workbooks with teams should be on the subscription. The cost difference works out to about $50 a year for personal users — small enough that the productivity gain pays for itself within a week if you actually use the new features.
Subscription. Always up to date. Includes dynamic arrays (FILTER, SORT, UNIQUE, TEXTSPLIT, VSTACK, GROUPBY, PIVOTBY), Copilot (add-on), Python in Excel, live data types, co-authoring, and continual feature drops. 1 TB OneDrive included. Runs on Windows, Mac, web, iPad, iPhone, Android.
Perpetual licence, $159.99. Includes most dynamic array functions through 2024 (XLOOKUP, LET, FILTER, SORT, IFS, SWITCH), modern charts, and improved performance. No Copilot, no Python, no GROUPBY, no co-authoring with other 2024 users on shared servers. Security patches until October 2029.
Perpetual licence, sold while supplies last. First wave of dynamic arrays only — XLOOKUP, LET, FILTER, SORT, UNIQUE, SEQUENCE. No TEXTSPLIT, no VSTACK, no GROUPBY. Workbooks built in newer versions may show #NAME? errors on functions added after late 2021. Security patches end October 2026.
Mainstream support ended. Predates the dynamic array engine entirely. No XLOOKUP, no FILTER, no SORT, no UNIQUE. Workbooks that use any function from the last six years will throw errors. Strongly recommend upgrading if you collaborate with anyone on a newer build.
The subscription edition treats the cloud as a first-class citizen, not a bolt-on. Every workbook you save can live in OneDrive or SharePoint, and once it does, sharing becomes a one-click action. Send a link, choose who can edit or view, and the recipient opens the file in their browser, the desktop app, or the mobile app. Permissions follow the document, not the device.
AutoSave is the feature most people fall in love with. With a cloud-stored workbook open, every keystroke saves silently in the background. Version history sits one click away. If you delete the wrong column at 4 PM, you can roll the file back to its 3 PM state without losing anyone else's work. The same feature in perpetual Excel only works on locally synced OneDrive folders and is much less reliable for team scenarios.
Co-authoring is where the subscription pulls clearly ahead. You and a colleague can both type into the same workbook simultaneously. You see their cell cursor in colour, watch them edit, and merge changes without conflict. Comments are threaded — like a chat — and you can @ mention someone to drop a notification into their inbox. Excel 2024 supports co-authoring on OneDrive and SharePoint files too, but only with subscription-equivalent versions on the other end. Mix in a perpetual user, and the file falls back to single-user mode.
Excel for the web is included with every subscription. It runs in any modern browser, opens .xlsx files directly from OneDrive, and supports about 90% of desktop features. Pivot tables, charts, formulas, conditional formatting, and most data tools all work. You will run into gaps on Power Pivot, macros, and Power Query authoring, but day-to-day editing feels almost identical. For users who switch between a work laptop and a personal machine, the web app removes the friction of installing Excel everywhere.
Microsoft 365 Excel includes the full Power suite — Power Query, Power Pivot, Power View — and updates each one regularly. Power Query is the most useful for most users. It connects to dozens of data sources (SQL Server, web pages, CSV, JSON, Salesforce, SharePoint, SAP, Snowflake) and lets you build a reusable, refreshable ETL pipeline inside Excel. If you are stuck cleaning the same messy CSV every Monday, Power Query reduces it to a single refresh click.
Power Pivot handles workbooks with millions of rows by loading data into a columnar in-memory engine. You can build a star-schema data model, write DAX measures, and connect that to a pivot table without ever leaving Excel. It is overkill for monthly reports, but it is the right tool for analytical work that exceeds the standard 1,048,576-row limit of a worksheet. Power Pivot was once an add-in; it is now built in for Microsoft 365 and Office Professional users on Windows.
Python in Excel is the newest entry. Type a formula starting with =PY and you can run Python code inside a cell, with the result returning to the worksheet. Pandas, NumPy, Matplotlib, Seaborn, statsmodels, and scikit-learn are all preloaded. The Python execution runs on Microsoft's cloud, not your machine, so you do not need to install anything. Note the catch — it is a premium feature, currently included with most Microsoft 365 plans for personal use but metered for heavy enterprise workloads. Check Microsoft's licensing page before you build a critical workflow around it.
For traditional analysts, the Analysis ToolPak and Solver add-ins are still here, both untouched for years but still useful. They handle regression, ANOVA, optimisation, and what-if scenarios. If you regularly run statistical tests or model business decisions, both are worth enabling under File > Options > Add-ins. They sit alongside pivot tables as the bedrock of the Excel analyst toolkit.
If you use Microsoft 365 Excel professionally, certification is worth considering. The Microsoft Office Specialist (MOS) Excel Associate exam tests core skills — formulas, charts, formatting, sorting, filtering — and costs around $100. MOS Excel Expert covers advanced features like Power Query, conditional formatting rules, custom number formats, and array formulas. Both certifications are widely recognised by employers and look strong on a CV, especially for administrative, finance, and analyst roles.
Beyond MOS, Microsoft offers role-based certifications that include Excel as one of several tools. The Microsoft Certified: Data Analyst Associate covers Power BI heavily but assumes Excel proficiency. The Microsoft 365 Fundamentals exam (MS-900) covers the broader Microsoft 365 ecosystem and is a useful starting point if you are new to the platform. Each role-based exam costs $165 in the United States.
For training, Microsoft Learn offers free tutorials covering every Excel feature, from basics to advanced. LinkedIn Learning has well-structured Excel courses that count toward MOS exam prep. Coursera and edX host university-led courses that go deeper into modelling and analysis. If you prefer practice over theory, our Excel practice test covers the same skills MOS examiners test — formulas, formatting, charts, pivot tables, and data tools — with detailed explanations on each question.
One tip: do not start with Copilot. Learn the spreadsheet first. Copilot is a productivity multiplier, but it amplifies what you already know. Drop someone with no Excel background in front of Copilot and they will accept whatever it suggests. Learn the formulas, learn the keyboard shortcuts, learn how conditional formatting rules work, and Copilot becomes the speed boost it is meant to be — not a crutch that hides your gaps.
Google Sheets is the obvious alternative for users who live in a browser. It is free for personal use, $6 per user per month with Google Workspace Business Starter, and runs entirely in the cloud with real-time collaboration baked in from day one. Sheets is excellent for shared trackers, light analytics, and lightweight modelling. Where it falls short — and the gap is real — is heavy computation, complex pivot tables, and large-file handling. A 100,000-row pivot in Sheets crawls. The same pivot in Excel resolves in under a second.
LibreOffice Calc is the free, open-source option. It opens .xlsx files, supports most formulas, and runs on Windows, Mac, and Linux. The interface looks like Excel from a decade ago, and the formula library lags behind, but for casual work it is genuinely capable. There is no cloud collaboration and no AI features. It costs nothing.
Apple Numbers ships free on every Mac, iPhone, and iPad. The design is clean and the integration with iCloud is smooth, but it is fundamentally a different product. Numbers treats a workbook as a canvas of independent tables rather than a single grid. That works well for personal budgets and small reports. It does not work well for anyone who has built their workflow around Excel's grid-based logic. .xlsx import is reasonable for simple files, painful for anything with macros or Power Query.
Zoho Sheet, WPS Office Spreadsheets, and OnlyOffice round out the field. All three are competitive on price (free or low-cost) and feature parity for basic work. None of them match Microsoft 365 Excel for advanced analytics, formula coverage, or ecosystem integration. If you sit in an organisation that already runs Microsoft 365, switching out Excel rarely makes sense — the integration with Outlook, Teams, Power BI, and SharePoint locks the value in.
Switch to the current channel if you are not already on it. Microsoft 365 has two release tracks — current channel and monthly enterprise channel — and the current channel gets new features within days of release. IT admins sometimes default users to the slower track for stability. If you want the latest functions, ask your admin or change it under File > Account > Office Insider.
Turn on AutoSave for every workbook. It is off by default for files saved locally, on by default for files in OneDrive or SharePoint. The toggle sits in the top-left of the title bar. Once on, version history becomes your safety net — you can roll a file back to any state from the last 30 days with two clicks.
Master the dynamic array functions. FILTER, SORT, UNIQUE, and XLOOKUP cover 80% of what most people use INDEX/MATCH and SUMIF for, and they spill results automatically. TEXTSPLIT replaces the old text-to-columns workflow. GROUPBY and PIVOTBY are newer (mid-2025) and reduce a lot of pivot-table setup to a single formula. If you have not learned these yet, start with FILTER and XLOOKUP — those two alone change how you think about lookups.
Use the desktop and web apps for what each is good at. Desktop wins for heavy calculation, large files, macros, Power Query authoring, and any work where you need every feature. Web wins for quick edits, sharing, mobile access, and collaboration. The two stay in sync via OneDrive, so the switch costs nothing. Many heavy users keep desktop open for analysis and use web for quick reviews — it is the cleanest way to work.