VLOOKUP has always been required but inconvenient and experts would historically resort to the terribly complicated INDEX MATCH combination, XLOOKUP not only fixes most of VLOOKUP’s flaws but does so whilst being more intuitive to write & understand for novices. Merging two tables by looking up a value in one table in another table us useful in many scenarios. XLOOKUP: VLOOKUP (Excel’s 3rd most used function) is now largely regarded as a legacy function that will continue to exist only because most Excel users sadly don’t explore what’s new.
Translate: Use Review > Translate on a phrase or your entire document/sheet/slide Excel’s feature formerly known as “Comments” has been renamed to “Notes” still available from the Review tab.Īccessibility checker: Review > Check Accessibility now suggests how to improve documents. Modern Comments: Insert > Comment and start a thread with possibilities for replies or co-workers, you can open the comments pane from the top right. Some enhancements alongside co-authoring have also been introduced…Īutosave: Store on OneDrive or SharePoint and you’ll be able to turn on/off Autosave Excel, PowerPoint & Word co-authoringĬo-author: A document saved on OneDrive or SharePoint can now have multiple people editing simultaneously using the desktop apps of Word, Excel, or PowerPoint, you will see icons of everyone’s photo who is currently in the file. Hide Quick Access Toolbar: Your quick access toolbar may disappear by default, but you can get it back by right clicking the ribbon and choosing to show it, then when you right click the toolbar you can choose to show command labels. Microsoft documents some updates to all apps here, but this list is more complete: You’ll notice rounded edges on the tabs on the ribbon, performance updates and other small user interface changes like the undo/redo buttons have moved and the search bar is updated and now can find text, commands, documents, help etc.
XLOOKUP in Excel, more capable than VLOOKUP whilst being easier to write.Dynamic Arrays in Excel (one formula returns multiple cells).If you are a Microsoft Office 365 subscriber, you may use this post as a digest of some (but not all) of features released over the last few years.
0 kommentar(er)
