Office Compatibility Issues

Compare Excel 365 and Excel 2016 Features for Accounting and Reporting

Huda QurayshiHuda Qurayshi Nov 20, 2026 869 views

Question details

The user wants to compare Excel 2016 with Excel in Microsoft 365 and identify features added after Office 2016.

Compare Excel 365 and Excel 2016 Features
Product
Microsoft Excel 2016 and Excel for Microsoft 365
Device & OS
not provided
Scenario
Evaluate Excel features for accounting, reporting, and data analysis.
Observed behavior
The goal is to build a reliable comparison of features available in each version.
Before you start

In each Excel installation, open File > Account and check Product Information to identify the license and version. Note the platform and, for Microsoft 365, the update channel because feature availability can vary.

Solution 1Recommended

Compare Microsoft’s Excel release notes and update history

Use Microsoft’s version-specific documentation to identify features introduced after Office 2016.

Microsoft does not provide one complete comparison list for Excel 2016 and Excel for Microsoft 365. Combine release notes with update documentation, using the September 2015 release of Office 2016 as a starting point.

1
Review the 2016 baseline

Search Microsoft Support for “What’s new in Excel 2016” and note the accounting, reporting, and analysis features already included.

2
Check later perpetual releases

Search Microsoft Support for “What’s new in Excel 2019 for Windows” and the corresponding Excel 2021 and Excel 2024 pages. Record relevant features and the version in which each is listed.

3
Review Microsoft 365 updates

Search Microsoft Learn for “Update history for Microsoft 365 Apps” and review the release notes for your update channel. Check Excel feature entries against the version shown under File > Account.

4
Check the roadmap

Open the Microsoft 365 Roadmap and search or filter for Excel features. Check each item’s platform and release status; a roadmap entry does not guarantee that a feature is available to every user.

5
Build a comparison table

In Excel, create columns for Feature, Excel 2016, Excel for Microsoft 365, Requirements, and Source. Include items relevant to your work, such as XLOOKUP and dynamic arrays, which are not available in perpetual Excel 2016.

Compare Microsoft’s Excel release notes and update history
Check feature requirements: Microsoft 365 features can depend on the platform, subscription, update channel, and rollout status. A feature listed for a later perpetual release should not automatically be assumed to be available in Excel 2016.
Free Microsoft Office alternative

Explore WPS Spreadsheets for Everyday Reporting

If you are also evaluating alternatives to Excel, WPS Office is a free, lightweight option with a familiar interface. Open existing spreadsheets and continue everyday reporting without rebuilding your files from scratch; check advanced features for compatibility.

Create and edit spreadsheets for accounting and reportingOpen and save Microsoft Excel formats, including XLSX and XLSWork in a familiar spreadsheet interfaceUse a free, lightweight alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Is there a single official comparison of Excel 2016 and Excel 365?

Microsoft does not provide one complete list. Combine the Excel “What’s new” pages with Microsoft 365 Apps update history and the Microsoft 365 Roadmap.

How do I check which edition of Excel I have?

Open Excel and select File > Account. Under Product Information, check the product name and version; Microsoft 365 installations may also show an update channel.

Does Excel 2016 support XLOOKUP and dynamic arrays?

Perpetual Excel 2016 does not support XLOOKUP or dynamic arrays. Check Microsoft Support for the availability of each feature in the newer Excel edition you are considering.

Does a Microsoft 365 roadmap listing mean I can use a feature now?

Not necessarily. Open the roadmap item and check its release status and supported platforms, then verify that your Microsoft 365 subscription and update channel include the feature.