Читать книгу Office 2021 for Macs For Dummies - Bob LeVitus - Страница 17

Excel users will be delighted by the following features, new to Excel :

 Sheet views: When collaborating with others on a spreadsheet, your view may be altered from time to time by someone else if they’re filtering or sorting. Sheet views allows you to create a custom view so that the actions of others don’t affect what you’re seeing.

 XLOOKUP function: XLOOKUP is a new function that allows you to search and find anything in a table or range in a spreadsheet. You can look for info in one row of a column and have the result appear in the same row of another column.

 Updated Draw tab: The ribbon’s Draw tab provides better functionality than previous iterations, making it super-simple to add compelling graphics and notations to spreadsheets.

 Watch window: The new Watch window allows you to keep an eye on multiple cells in multiple worksheets, all within a single window. This way, you can see how changes you make in the cells of one worksheet affect those in your Watch window.

 Dynamic arrays: Dynamic array is a new way that Excel calculates data, enabling you to do quickly what used to be time-consuming. Dynamic array functions make it easy to place a formula in one cell and have it return multiple values in multiple cells. According to all the Excel gurus we know, this feature is a game-changer.