Opis producenta

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.

Kluczowe zalety

• Co-authoring
• Better collaboration with modern comments
• Know who's in your workbook
• Save your changes as they happen
• XLOOKUP function
• LET function
• XMATCH function
• Performance improvements
• Save as SVG for your pictures and charts

Funkcje produktu

• 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.
• 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.
• Know who's in your workbook
  See who else is working along with you and where they are in the workbook.
• 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.
• XLOOKUP function
  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.
• 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.
• 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.
• Performance improvements
  Experience improved performance, stability, and speed across Excel. Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
• Save as SVG for your pictures and charts
  Excel now supports 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.