The sheet view feature allows individual users to customize views on different sheets without affecting others who access the same document. LET is a new enhanced performance version that does not rerun the action. Traditional formulas that reuse data were required to run the same action if called multiple times. In addition, Xlookup functionality offers flexibility in supporting exact matches, partial matches, and wildcards.Īlso known as spilled arrays, dynamic arrays can return results of varying sizes. The new Xlookup function is the latest iteration of Vlookup, Hlookup, and Lookup.

This functionality allows you to see who is actively working on your shared documents.Įnjoy the updated and user interface with a simplified design to provide easy access to actionable collaboration. Image credit: Microsoft See who is actively working on your documents Important note: This feature is NOT available in Office 2021 LTSC The modern comments feature allows for productive collaboration between co-authors. Important note: This feature is NOT available in Office 2021 LTSC Modern comments This feature is available in the following applications: What are the new features in Office 2021?Ĭo-authoring allows users to collaborate effectively by working on documents at the same time. The primary differences are that the LTSC is for volume license customers and only has five years of support from Microsoft. The latest office client comes in two flavors: Office 2021 or Office 2021 Long Term Servicing Channel (LTSC). Office 2021 supports Windows 10, Windows 11, and macOS Office 2021 versions It is important to note that current Microsoft 365 customers do not need Office 2021, as they already have all the functionality. Unlike the subscription-based Microsoft 365 service, this product is for customers who prefer a one-time purchase.

Behind the public hype around the release of Windows 11, on the same day, Microsoft quietly launched the latest version of the standalone version of their productivity suite, Office 2021.

Microsoft office 2019 vs 2021