Microsoft Office 2021

Microsoft Office 2021

What’s New in Office 2021

In Office 2021, you’ll find new co-authoring features, inking tools, data types, functions, translation and editing tools, motion graphics, ease-of-use features, and so much more! Check out what’s available to you today.

Office 2021

Co-author documents

With real-time co-authoring, you can work with others in the same document at the same time. There’s no need to send extra notes or emails because everyone will be notified when a file is updated.

New in: Word Excel PowerPoint   LEARN MORE

 


Better collaboration with modern comments

Have control of when you send comments to your co-authors and be productive with a consistent commenting experience between Word, Excel, and PowerPoint.

New in: Word Excel PowerPoint LEARN MORE

 


Know who’s in your document

See who else is working along with you and where they are in the document. You’ll find this experience in Word, Excel, and PowerPoint.

New in: Word Excel PowerPoint

 


Visual refresh

Work with a modernized Start experience and newly refreshed tabs in the ribbon. Experience a clean, clear style with monoline iconography, neutral color palette, and softer window corners. These updates communicate action and provide features with simple visuals.

New in:  microsoft office 2021 accessmicrosoft office 2021 Excelmicrosoft office 2021 onenotemicrosoft office 2021 outlookmicrosoft office 2021 PowerPointmicrosoft office 2021 plannermicrosoft office 2021 projectmicrosoft office 2021 visiomicrosoft office 2021 Word

 


Look left, look right… XLOOKUP is here!

Row by row, find anything you need in a table or range with XLOOKUP.

New in: microsoft office 2021 Excel LEARN MORE

 


Dynamic arrays

Write one formula and return an array of values. Expedite calculations and insights with six new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.

New in: microsoft office 2021 Excel LEARN MORE

 


LET function

The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula.

New in: Excel LEARN MORE

 


XMATCH function

The XMATCH function searches for a specified item in an array or range of cells, and then returns the item’s relative position. You can also use XMATCH to return a value in an array.

New in: Excel LEARN MORE

 


Sheet views

Create customized views in an Excel worksheet without disrupting others.

New in: Excel LEARN MORE

Note: Sheet views are not available in Excel LTSC 2021.

 


Accessibility ribbon

The Accessibility ribbon puts all the tools you need to create accessible content in one place.

New in: Excel LEARN MORE

Note: The Accessibility ribbon is not available in Excel LTSC 2021.

 


New and improved Record Slide Show

Record Slide Show now supports presenter video recording, ink recording and laser pointer recording.

New in: PowerPoint LEARN MORE

 


Ink Replay – Slide Animation for Ink object

Now you can apply the new Replay or Rewind animation to ink and get the drawing effect directly in your presentations. You can adjust the timing of these animations to be faster or slower to match the experience you want.

New in: PowerPoint LEARN MORE

 


Arrange elements on your slides for screen readers

See the elements in screen-reading order and re-arrange them as necessary to communicate your message effectively.

New in: PowerPoint LEARN MORE

 


Link to a slide

Ask a colleague to contribute to your slide deck, and start them directly on the slide you need help with.

New in: PowerPoint LEARN MORE

Note: Link to a slide is not available in PowerPoint LTSC 2021.

 


Translator and ink in Outlook

Translate email messages into more than 70 languages on the fly and view the transcript—all within Outlook.

Annotate email images or draw in a separate canvas using your finger, pen, or mouse.

New in: Outlook LEARN MORE 

 


In Outlook, use Instant Search to quickly find emails

Select the search bar (located above the Outlook ribbon) to help find email messages anywhere in Outlook.

New in: Outlook LEARN MORE

 


Reduce eye strain with Dark Mode

Previously, you could use Word with a dark ribbon and toolbars, but your document color stayed bright white. Now, Dark Mode in Word offers a dark canvas as well.

New in: microsoft office 2021 Word LEARN MORE

 


Improve comprehension with Line Focus

Move through a document in Word, line by line, without distractions. Adjust the focus to put one, three, or five lines in view at a time.

New in: microsoft office 2021 Word LEARN MORE

 


See what’s new in stock media

Move through a document in Word, line by line, without distractions. Adjust the focus to put one, three, or five lines in view at a time.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPointmicrosoft office 2021 outlookmicrosoft office 2021 visioLEARN MORE

 


Find what you need with Microsoft Search

At the top of your Microsoft Office apps on Windows you’ll find the new Microsoft Search box. This powerful tool helps you quickly find what you’re looking for, from text to commands to help and more.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPointmicrosoft office 2021 outlookmicrosoft office 2021 onenote LEARN MORE

 


Increase the reach of your content

Accessibility Checker keeps an eye on your documents and tells you in the status bar when it finds something you should look at. Try it by clicking Review > Check Accessibility.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPoint

 


Performance improvements

Experience improved performance, stability, and speed across Word, Excel, PowerPoint, and Outlook​.

Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPointmicrosoft office 2021 outlook

 


Updated Draw tab

Quickly access and change the color of all your inking tools in one place.

Simplify how you work with ink using new Draw tab additions: Point EraserRuler, and Lasso.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPoint LEARN MORE

 


Save your changes as they happen

Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPoint LEARN MORE

 


Support for OpenDocument format (ODF) 1.3

We now include support for the OpenDocument format (ODF) 1.3. The ODF 1.3 specification adds support for many new features.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPoint LEARN MORE 

 


Refresh, relink, or remove linked tables

The updated Linked Table Manager is a central location for viewing and managing all data sources and linked tables in an Access database. See all the improvements we’ve made to the Linked Table Manager based on your feedback.

New in:  microsoft office 2021 access LEARN MORE

 


Try the new the Date/Time Extended data type in Access

To enhance syntax compatibility with SQL and to increase accuracy and level of detail in records that include dates and times, we’ve implemented the SQL DateTime2 data type into Access.

New in:  microsoft office 2021 access LEARN MORE

 


Keep tabs on your database objects in Access

You can clearly see the active tab, easily drag tabs to rearrange them, and close database objects with just one click.

New in:  microsoft office 2021 access LEARN MORE

 


New Azure stencils and shapes in Visio

We’ve added many more stencils to help you create up-to-date Azure diagrams. You can use these new stencils to build Azure diagrams for network topologies, virtual machine configurations, operations, and more.

New in: microsoft office 2021 visio LEARN MORE

 


New AWS stencils and shapes in Visio

We have enabled infrastructure shapes from another major cloud provider: Amazon Web Services (AWS). You can now use stencils with the latest AWS shapes to help you create diagrams.

New in: microsoft office 2021 visio LEARN MORE

 


Content for social distancing planning in the workplace

Many workplaces need to be re-planned to follow the social distancing guidelines in force. This new Visio template, and the Workplace Social Distancing stencil, provide a number of shapes, fill patterns and line patterns, both scaled and unscaled, to help with this process.

New in: microsoft office 2021 visio LEARN MORE

 


Try the Sketched style outline

You can give a casual, hand-drawn look to shapes in your presentations with the Sketched style outline.

Try out the Curved, Freehand, or Scribble options under Format Shape > Line > Sketched style.

New in: microsoft office 2021 Wordmicrosoft office 2021 Excelmicrosoft office 2021 PowerPointLEARN MORE

 


Pick the perfect color

Based on your feedback, we’ve added a new input field in the Colors dialog for Hex color values. Now you won’t have to spend time converting Hex color values into RGB values.

For any property where you can define a color, you can now enter a Hex color value in the Hex box, for example, #0F4C81 or 444.

New in:   microsoft office 2021 access microsoft office 2021 Excel microsoft office 2021 onenote microsoft office 2021 outlook microsoft office 2021 PowerPoint microsoft office 2021 planner microsoft office 2021 project microsoft office 2021 visio microsoft office 2021 Word 

Microsoft Office 2021 Home and Student Microsoft Office 2021 Home Business Microsoft Office 2021 Professional

Different Versions of Microsoft Office 2021

Office 2019 was released on 5 Oct 2021.

In Office 2021, there are 3 versions.

  • Office 2021 Home/Student
  • Office 2021 Home/Business
  • Office 2021 Pro

There are some prices increment from Office 2016 to Office 2019 and Office 2021

Version Office 2016 Office 2019 Office 2021
Home/Student S$229 S$229 S$229
Home/Business S$349 S$379 S$379
Professional S$619 S$669 S$669

Office 2016 connectivity support for Office 365 services
In addition, we are modifying the Microsoft 365 services system requirements related to service connectivity. In February, we announced that starting October 13, 2020, customers will need Microsoft 365 Apps or Office 2021 clients in mainstream support to connect to Microsoft 365 services.

To give you more time to transition fully to the cloud, we are now modifying that policy and will continue to support Office 2016 and Office 2019 connections with the Microsoft 365 services through 10 October 2023. Office 2021 will provide Microsoft 365 connectivity support until 13 Oct 2026. Microsoft will not be releasing any more Office retail version, instead it will move to the full subscription business model.

 

Office 2013 – 11 Apr 2023
Office 2016 – 10 Oct 2023
Office 2019 – 10 Oct 2023
Office 2021 – 13 Oct 2026