What is included in Microsoft Excel 2016?

Power Query – Built into the Data tab as Get & Transform.
Power Pivot – Data model add-in included with standalone Excel 2016.
Six new charts – Waterfall, histogram, Pareto, box plot, treemap, sunburst.
Forecast Sheet – One-click exponential smoothing forecasts with confidence intervals.
Core Capacity – Power Pivot models exceed the 1,048,576-row worksheet limit.
Important – This is a standalone application; the full Microsoft Office suite is not included.

Compare included Office programs from 2010 to 2024
To compare included applications, read our overview:

What are the main benefits of Microsoft Excel 2016?

Microsoft Excel 2016 is the standalone, one-time-purchase desktop version of Excel for Windows, sold separately from the Office 2016 suite. It was the release that moved Power Query and Power Map into the application itself as Get & Transform and 3D Maps, and Microsoft ended support for it on October 14, 2025.

One-time purchase – No recurring fee for the spreadsheet application.
Offline operation – Workbooks stay on local drives and network shares.
Power Pivot included – Not available in Home and Student 2016.
Macro compatible – Runs existing VBA macros and .xlsm workbooks.
Single-app install – Adds Excel without the other Office programs.
Fixed feature set – The ribbon and functions never change unexpectedly.

What does Microsoft Excel 2016 actually do in daily work?

Excel 2016 handles worksheets of up to 1,048,576 rows and 16,384 columns, with the data-preparation tools built into the application instead of installed as separate downloads. The concrete change over Excel 2013 is Get & Transform on the Data tab: importing a monthly CSV export, dropping columns, unpivoting a cross-tab and merging it with a second file becomes a saved query that refreshes when the next export arrives, replacing a manual copy-and-clean routine. Forecast Sheet on the same tab builds an exponential-smoothing forecast using the FORECAST.ETS family, detects seasonality automatically and draws a confidence band, which fits monthly sales data better than the straight-line trend available in earlier versions. The six chart types added in this release remove the stacked-column workarounds previously needed to draw a waterfall bridge for a profit-and-loss variance or a Pareto chart for defect counts.

Who is Microsoft Excel 2016 best suited for?

It suits users who need one licensed copy of Excel on a Windows PC and nothing else from the Office family, such as a workstation that already has a separate mail client and no use for Word or Outlook. The specific reason to pick the standalone Excel 2016 over a bundled Home and Student 2016 or Home and Business 2016 package is Power Pivot: Microsoft lists standalone Excel 2016 among the perpetual products that include it, while those two bundles do not. That matters when a report has to join a multi-million-row transaction export to a product table, because the Power Pivot data model holds those rows outside the worksheet grid entirely. Since support ended on October 14, 2025, it now fits offline machines, archive workstations and systems kept in place to open legacy 2016-era workbooks, rather than an internet-facing daily-driver PC.

Does Excel 2016 include XLOOKUP, dynamic arrays and Power Pivot?

Power Pivot is included; XLOOKUP and dynamic arrays are not. Microsoft states plainly that XLOOKUP is not available in Excel 2016 or Excel 2019, and the dynamic array engine behind FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY arrived with Excel 2021, so spilled formulas do not work in this version. The 2019-era functions TEXTJOIN, CONCAT, IFS, MAXIFS, MINIFS and SWITCH are also missing, which means text assembly still runs through CONCATENATE and multi-condition logic through nested IF chains. In practice, a workbook a colleague built in Microsoft 365 using XLOOKUP will still open here, but those cells return a #NAME? error instead of a result. Get & Transform, Power Pivot and 3D Maps all work as shipped.

How does Excel 2016 compare with Excel 2019, 2021 and 2024?

All four are one-time-purchase desktop versions of the same application and use the same file formats, but the formula engine differs sharply between them. Excel 2019 added CONCAT, TEXTJOIN, IFS, MAXIFS, MINIFS and SWITCH plus funnel and 2D map charts; Excel 2021 added XLOOKUP, XMATCH, LET and the dynamic array functions; Excel 2024 added newer text and stacking functions such as TEXTSPLIT and VSTACK together with the IMAGE function. Excel 2016 and Excel 2019 both reached end of support on October 14, 2025, and Microsoft confirmed there would be no extension and no extended security updates for either. The table below lists the verified differences.

Compare Office versions from 2010 to 2024
For help choosing the right Office version, read our guide:

How does Excel 2016 differ from Excel in Microsoft 365?

Excel 2016 is a fixed desktop application, while the Microsoft 365 version keeps receiving functions that never reach the 2016 build. Beyond the formula gap, the practical difference is service connectivity: Microsoft ended support for Office 2016 clients connecting to Microsoft 365 services, including Exchange Online, SharePoint Online and OneDrive for Business, on October 10, 2023. Files already stored in those services are not deleted or blocked, but opening and saving them from inside Excel 2016 sits outside Microsoft's support scope and can break as the services change. Co-authoring, LAMBDA, Python in Excel and Copilot belong to Microsoft 365 and are not part of this product, so a team that edits the same workbook simultaneously will not get that behaviour here.

What technical limitations should buyers know before choosing Excel 2016?

The main one is lifecycle: support for Excel 2016 ended on October 14, 2025, with no extended security updates offered, so the application keeps running but receives no further security or bug fixes. Second, this is the spreadsheet application on its own, and Word, PowerPoint, Outlook and Access are separate products. Third, the formula set stops at the 2016 list, which rules out XLOOKUP, dynamic arrays, LET and LAMBDA as well as the 2019 additions such as TEXTJOIN and IFS. Fourth, connections from Excel 2016 to SharePoint Online and OneDrive for Business have been unsupported since October 10, 2023. Workbooks still travel in both directions as .xlsx files, but formulas written with newer functions will not calculate on this version.

Which file formats and data sources does Excel 2016 support?

Excel 2016 reads and writes .xlsx, .xlsm, .xlsb, .xltx and .csv, still opens the legacy .xls and .xlt formats from Excel 97 to 2003, and exports directly to PDF. On the data side, Get & Transform connects to text and CSV files, other workbooks, Access databases, SQL Server, Oracle, web pages, OData feeds, entire folders of files and ODBC sources, and each connection is stored as a query that can be refreshed rather than rebuilt. VBA macros in .xlsm workbooks run unchanged, which is usually why a finance or engineering team keeps a 2016-era workbook in service instead of rewriting it. 3D Maps plots rows containing an address, city, postal code, state or country field onto a globe view without a separate add-in download.

What should users check before choosing Excel 2016?

First, check which Excel version the people receiving the workbooks use, because files built with XLOOKUP or spilled array formulas will not calculate correctly here. Second, confirm the work is local: since October 10, 2023 Microsoft no longer supports Excel 2016 connecting to SharePoint Online or OneDrive for Business, so a cloud-first document workflow points to a newer version instead. Third, decide whether the security position is acceptable, since no patches have been issued for this version since October 14, 2025. Fourth, confirm that only the spreadsheet application is needed, because Word, PowerPoint and Outlook are not part of this product and have to be bought separately.

Check Windows compatibility for Office versions
To check whether your Windows version fits, read our overview:

Frequently asked questions about Microsoft Excel 2016

Is Microsoft Excel 2016 a classic desktop application?

Yes. It installs locally on a Windows PC and runs from the hard drive rather than streaming from a browser session. No cloud sign-in is needed for the application to open workbooks and calculate formulas.

Are Word, PowerPoint or Outlook included with Excel 2016?

No. This product contains the Excel application only. Anyone who also needs Word, PowerPoint or Outlook has to choose a suite edition or buy those applications separately.

Does Excel 2016 require an existing Office installation?

No. The standalone Excel application installs on its own and does not need Word, Outlook or an Office suite to be present first. It appears as its own entry in the Windows program list.

Can Excel 2016 open workbooks created in Excel 2021 or Microsoft 365?

Yes, the .xlsx, .xlsm and .xlsb formats are unchanged across those versions, so the file itself opens normally. Formulas that use functions added after 2016, such as XLOOKUP, FILTER or LET, return a #NAME? error because Excel 2016 does not recognise them. Values that were already calculated and saved in the file stay visible in the cells.