Deal Alert: Microsoft Office Home & Student 2021 available for $99

Microsoft Office Home and Student 2021 is available now for $99.99 from Amazon US. Office Home and Student 2021 includes Word, Excel, and PowerPoint applications. You can find the deal at Amazon.

• With real-time co-authoring in Office 2021, you can work with others on the same document at the same time.
• Microsoft Teams is now part of the Office 2021 suite.
• New visual updates: Neutral color palette, softer window corners, refreshed tabs in the ribbon, and colorful presence indicators so you can easily see who’s working on the document with you. Application themes will always sync with Windows light or dark mode by default.

In addition to the above, Office 2021 will get the following features that are already available to Microsoft 365 subscribers.

What’s new in Microsoft Office 2021:

Look left, look right… XLOOKUP is here!

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

LET . function

The LET function assigns a name to the calculation result. This allows storing intermediate calculations, values, or defining names inside formulas.

XMATCH function

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

New and improved recording slideshow

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

Redraw your ink strokes

You can redraw your ink strokes as they are drawn; This allows you to illustrate things step by step or show a thought process. You can also pause playback and select a point to start playback.

Arrange your slides for screen readers

View the elements in screen-reading order and rearrange them as needed to communicate your message effectively.

Translator and Ink in Outlook

Quickly translate email messages into more than 70 languages ​​and view transcripts — all in Outlook.

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

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.

Refresh image

Work with a modernized Start experience and refreshed new tabs in the ribbon.

Experience clean, clear style with a Monoline icon that conveys action and features with simple visuals.

See what’s new in stock media

We’re constantly adding more media to Office’s Premium Creative Content collection, a built-in library of images, icons, and more to help you express yourself.

Find what you need with Microsoft Search

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

Performance improvements

Experience improved performance, stability, and speed on Word, Excel, PowerPoint, and Outlook?.

Calculate faster from popular Excel functions like SUMIF, COUNTIF, and AVERAGEIF.

Updated Drawing tab

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

Simplify the way you work with ink using the new Draw tab addition: Erase points, Ruler, and lariat.

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.

OpenDocument Format (ODF) 1.3″ support

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

Refresh, relink or delete linked tables

Update Linked Table Manager is the central place to view and manage all data sources and linked tables in an Access database. See all the improvements we’ve made to Linked Table Manager based on your feedback.

Try the new Extended Date/Time data type in Access

To improve syntax compatibility with SQL, and to increase accuracy and granularity in records that include dates and times, we have implemented the DateTime2 SQL data type into Access.

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 a single click.

New Azure shapes and stencils in Visio

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

New AWS Shapes and Stencils in Visio

We 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.

Contents of social distancing planning at work

Many workplaces need to be re-planned to follow the social distancing guidelines that are in effect. This new Visio template, and the Workplace Social Distancing stencil, provide several shapes, fills, and line patterns, both scaled and unscaled, to help with this process.

Try Sketched Sketch

You can give a casual, hand-drawn look to shapes in your presentation with Sketch style outline.

Try Curved, Freehand or Scribble options in Shape Format > Row > Sketch style.

Choose the perfect color

Based on your feedback, we have added a new input field in Colour dialog box for Hex color values. Now you won’t have to waste time converting Hex color values ​​to RGB values.

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

The source: Microsoft