Compare Excel 365 and Excel 2016 Features for Accounting and Reporting
Question details
The user wants to compare Excel 2016 with Excel in Microsoft 365 and identify features added after Office 2016.

- 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.
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.
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.
Search Microsoft Support for “What’s new in Excel 2016” and note the accounting, reporting, and analysis features already included.
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.
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.
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.
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.

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.

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.




