Wednesday, August 10, 2022

What's new in Excel 2021 for Mac [MS]

Excel 2021 for Mac allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.

Note: Some features listed below are not included in Excel LTSC for Mac 2021 for commercial customers. Each of those features is noted if it does not apply to Excel LTSC for Mac 2021 for commercial customers.

Co-authoring

You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly — in a matter of seconds.

LEARN MORE

Note: Co-authoring is not available in Excel LTSC 2021 for Mac.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Better collaboration with modern comments

Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.

LEARN MORE

Note: Modern comments is not available in Excel LTSC 2021 for Mac.

Working with a comment

Know who's in your workbook

See who else is working along with you and where they are in the workbook.

Note: This feature is not available in Excel LTSC 2021 for Mac.

People icons, When others are co-authoring, they'll show up here

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.

LEARN MORE

Note: This feature is not available in Excel LTSC 2021 for Mac.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Sheet views

Create customized views in an Excel worksheet without disrupting others.

LEARN MORE

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

Shows Excel Spreadsheet

Look left, look right… XLOOKUP is here!

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

Return exact matches by default—there's no need to specify​.

LEARN MORE

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

LET function

The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.

Similar to variables in programming, LET is accomplished through Excel's native formula syntax.

LEARN MORE

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Dynamic arrays

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

LEARN MORE

Screenshot of Excel with data using dynamic arrays

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.

LEARN MORE

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

Find what you're looking for

Use the search box to find text, commands, help, and more.

Tell me is a text field where you can enter words and phrases about what you want to do next, and quickly get to features you want to use or actions you want to perform.

LEARN MORE

Shows Tell me search box

Visual refresh

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

Experience a clean, clear style with monoline iconography that communicates action and features with simple visuals.

Excel 2021 for Mac window with Take a Tour template opened

Performance improvements

Experience improved performance, stability, and speed across Excel.

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

Screenshot of Excel data using the SUMIF function

Watch your formulas

Watch cells across multiple sheets and books in a single pane or window.

The Watch Window makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets.

LEARN MORE

Watch window in Excel 2021 for Mac displaying Name, Cell, Value, and Formula

See what's new in stock media

We're constantly adding more rich media content to the Office Premium Creative Content collection, a curated library of stock images, icons, and more that helps you express yourself.

LEARN MORE

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Save as SVG for your pictures and charts

We now support saving pictures, charts, and other graphics from your workbook as SVG (Scalable Vector Graphic).

Your saved images can be resized with no loss of image quality.

LEARN MORE

Save as dialog in Excel 2021 for Mac with SVG option selected

Try the Sketched style outline

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

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

LEARN MORE

Line format options in Mac with Sketched style selected

Grow your Office skills

No comments:

Post a Comment

Search This Blog

"The Microsoft Exchange Replication service may not be running on server" error when you add a mailbox database copy in Exchange Server 2019 [MS]

"The Microsoft Exchange Replication service may not be running on server" error wh...