Compare MS Office 2021 Editions
What's new in Office 2021
XLOOKUP: Row by row, find anything you need in a table or range with XLOOKUP.
Dynamic arrays: You can now write one formula in Excel and return an array of values. Use Excel to expedite calculations and insights with 6 new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
LET function: Microsoft has included the LET function in Office 2021. It assigns names to calculation results to store intermediate calculations, values, or defining names inside a formula.
XMATCH function: The XMATCH function in Excel searches for a specified item in an array/range of cells and returns the item's relative position. XMATCH can also help you return a value in an array.
New in Outlook
Translator and ink in Outlook: Translate email messages into more than 70 languages and view the transcript— all within Outlook.
Drawing/inking: Annotate email images or draw in a separate canvas using your finger, pen, or mouse.
Instant search: use Instant Search in Outlook to quickly find emails. Select the search bar (located above the Outlook ribbon) to help find email messages anywhere in Outlook. Just like you do in, say, Gmail.
New in PowerPoint
New and improved Record Slide Show: You can now record Slide Show. Office 2021 now supports presenter video recording, laser pointer recording, and ink recording.
Replay your ink strokes: Draw and replay your ink strokes as they were drawn. This allows you to illustrate things step by step or even show a thought process. You can also pause the replay and select the point to start the replay.
Arrange elements on your slides for screen readers: Select elements in screen-reading order and rearrange them as necessary. This allows you to communicate your message effectively.
New in Access
Refresh, remove or relink linked tables: Access now has an updated Linked Table Manager in a central location for viewing and managing all data sources and linked tables in the database.
The new Date/Time Extended data type: Access has an updated Date/Time data type to enhance syntax compatibility with SQL and increase accuracy and level of detail in records that include dates and times. Microsoft implemented the SQL DateTime2 data type into Access.
Tab manager: Keep tabs on your database objects in Access. You can see the active tab, easily drag tabs to rearrange them, and close database objects with just one click.
New in Visio
New Azure stencils and shapes: Visio now has more stencils to help you create up-to-date Azure diagrams. You can build Azure diagrams for network topologies, virtual machine configurations, operations, and more.
New AWS stencils and shapes: Visio now has infrastructure shapes from Amazon Web Services (AWS). You can use stencils with the latest AWS shapes to you create diagrams.
Content for social distancing planning in the workplace: The new Visio template, and the Workplace Social Distancing stencil, provide several shapes, fill patterns, and line patterns, both scaled and unscaled, to help space replanning.
New in Word
Find what you need with Microsoft Search: This powerful tool helps you quickly find what you're looking for, such as text, commands, help, and more.
Try the Sketched style outline: You can give a casual, hand-drawn look to shapes in your presentations with the Sketched style outline.