Descriere Markit

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

Puncte cheie de vânzare

• Co-authoring
• Better collaboration with modern comments
• Know who's in your workbook
• XLOOKUP function
• LET function
• Dynamic arrays
• XMATCH function
• Performance improvements
• Unhide many sheets at the same time

Caracteristicile produsului

• 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.
• 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.
• 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.
• 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.
• Unhide many sheets at the same time
  No need to unhide one sheet at a time anymore - unhide multiple hidden sheets at once.