Microsoft Excel 2021 is the newest addition to Microsoft’s Office product family for Mac. It not only includes all of the already existing features and tools in a more visually appealing package, but comes with new additions and capabilities as well!

Improved performance

Excel 2021 for Mac is the most efficient and stable version of Excel yet, with improved performance on all macOS-based systems. With this new update you can expect to experience faster operations that will allow for a smoother workflow in your workday!

Visual refresh

The new and improved Start experience will help you start your project the right way. With a modernized ribbon, updated tabs in Excel 2021 for Mac for easier access to tools, complete with all-new Monoline iconography that communicates action with simple visuals — it doesn’t get any more convenient than this!

Dynamic arrays

The Dynamic arrays feature has been improved drastically in Excel 2021 for Mac. There are six more functions available within this exciting update: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.

XLOOKUP

The XLOOKUP function is a game changer in Excel 2021 for Mac. Now, you can find anything much easier without spending precious minutes scrolling up and down your sheets, or using less efficient search functions!

The function can be used to find anything you need in tables or ranges with just one row. The search term will return results from any column on the same side of your table.

XMATCH function

With XMATCH in Excel 2021 for Mac, you can search for and return a specific item from an array or range of cells. You could also use this function to get the absolute position on one value within another array — which is really useful if we’re trying to find cells at different intervals!

LET function

The LET function in Excel 2021 for Mac is a powerful addition that will help you as a spreadsheet user. It’s especially useful for storing intermediate calculations, values or defining names inside formulas and outputting them all at once instead of one by one!

Watch your formulas

Excel 2021 for Mac enables you to “watch” cells across multiple sheets and workbooks in a single pane or window. This new Watch Window functionality makes it convenient to inspect, audit, or confirm formula calculations and results on large worksheets with ease as well!

The “Tell me” bar makes it to Mac

In-app search is an excellent way to find cells, commands and help without having to fire up your browser or ask for assistance. The new addition of the “Tell me” bar on Mac will let you enter keywords about what your next action should be so that Excel 2021’s features can be accessed more quickly than ever before!

Save as SVG

Save your pictures and graphics as SVG in Excel 2021 for Mac. The app now supports saving various elements from your documents with no loss of quality when upscaling. The new feature allows you to resize these SVG files without it affecting how they look when displayed on screen or printed out!

Sketched style outline

Try out the Sketched style outline in Excel 2021 for Mac. You can give a casual, hand-drawn look to shapes with this new feature and it’s easy as pie! Try out the Curved, Freehand, or Scribble options for some unique looks to add interesting visual touches to your Excel spreadsheets.