Support for OpenDocument format - Now you can use OpenDocument format or ODF 1.3 files.Įxcel is a powerful spreadsheet application, and while it is very intuitive for essential functions, it has a steep learning curve to learn to apply the most advanced ones.Sheet views – This lets you create custom views in a worksheet.XMATCH function - Find an item’s relative position in an array or range of cells.Adds six new functions-FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY. Dynamic arrays - Write one formula to get a variety of values.LET function - Assigns names to calculation results.It can return a value from the left or the right when there is a match, as opposed to VLOOKUP, which can only return values from the right. This is in contrast to VLOOKUP, which only searches vertically. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |