XMATCH function: This searches for a specified item in an array or range of cells, and then returns the item’s relative position.

Dynamic Arrays: Write one formula and it return an array of values.

Microsoft describes the other new Excel features below: With the LET function, you can assign names to calculation results for storing intermediate calculations, values, or defining names inside a formula. With XLOOKUP, you can find anything you need in a table or range. For everyone else, the most notable new features will be performance improvements, new stock media, an updated Draw tab, the new Microsoft Search button, as well as support for the OpenDocument format. These are catered to enterprise users, however. On Windows, there are a lot of new functions to analyze data, including Dynamic Arrays, XLOOKIP, and LET functions. Microsoft Excel 2021 is one of the apps that gets the most new features.

Note that the new stock media and search button from Windows also are rolling out on Mac, too. Some of the other new features include advanced page color support in the immersive reader, natural-sounding voices with Read Aloud, and the ability to save pictures and charts in the. MicrosoftĪs for Word 2021 on Mac, you should notice a big visual refresh, with cleaner tabs and monoline iconography. The new Sketched style outline, meanwhile, gives a casual, hand-drawn look to shapes in your presentation. New drawing tools let you quickly access and change the color of all your inking tools, all in one place. Rounding out the list of new features in Word 2021 is an updated Draw tab, support for OpenDocument format, and the Sketched style outline. This is a new tool that can help you find text, get online help, use commands, and more. Basically, you’ll have more ways to make your documents look nice!Īlso new is the ability to use Microsoft Search.

Microsoft says that it is adding more rich media content and a better-curated library of stock images and icons. On Windows, the first of those new features in Word 2021 is the ability to enjoy a new collection of stock media. If you use this free password manager, your passwords might be at risk Hackers are using AI to spread dangerous malware on YouTube These are the new AI features coming to Gmail, Google Docs, and Sheets

Latest version of ms office for mac