Tech

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

Microsoft Office Visual Update

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.

Screenshot of Excel with data using dynamic arrays

LET . function

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

Example of using XMATCH to find the position of an item in a list

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.

List items in reading order on a slide with up and down arrow buttons to rearrange them

Arrange your slides for screen readers

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

This message has been translated from English to French using the Outlook Translator Add-in

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.

Excel 2021 start screen with a list of recently opened workbooks displayed

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.

Screenshot of Excel data using the SUMIF . function

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.

Pen Microsoft 365 Drawing Tools

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.

Convert AutoSave in Office

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.

List of file formats from Word with ODT file format marked

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.

Linked Table Manager Dialog

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.

Show Access data type

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.

A data table with tabs that can be rearranged

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.

Stencils and AWS shapes

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.

Template for AWS: SAP uses SIOS

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.

Visio template for a floor plan with social differentiation.

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.

Line formatting options in Mac with Sketched style selected

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.

Color picker in Office apps. Under the RGB fields there is a new field to enter the Hex color value.

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

https://mspoweruser.com/microsoft-office-home-student-2021-deal/ Deal Alert: Microsoft Office Home & Student 2021 available for $99

Hung

Inter Reviewed is an automatic aggregator of the all world’s media. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials, please contact us by email – admin@interreviewed.com. The content will be deleted within 24 hours.

Related Articles

Back to top button