XMATCH will make it possible to search for an item and return the relative position. You will be able to perform searches for the values in the columns on the left or right of the reference column as well as search for the position in the table. New features include XLOOKUP in Excel, which should make it easier to search in Excel documents. New Excel featuresĮxcel for Mac receives some formulas in the Office 2021 version that were previously only available in the Business variant. You will be able to save as SVG (Scalable Vector Graphic) format. Office 2021 gains some features that were previously only accessible to Microsoft 365 subscribers.įor all Office programs Microsoft has extended the collection of graphics, photos and icons. There will also be support for improved dark mode.

Microsoft has visually revised all programs in line with Windows 11. Microsoft is promising that after Office LTSC there will be another stand-alone version without a subscription, so 2021 won’t be the last version of Office that you can buy outright. The price is 10% more than the equivalent 2019 package.

You can also buy the Office LTSC (which means Long Term Servicing Channel and is essentially the perpetual license version of Microsoft Office for businesses and volume customers) It costs £249.99/$249.99.

Office Home & Business 2021 (£249.99/$249.99) which is designed for families and small businesses who want the office apps Word, Excel, PowerPoint as well as Outlook. This is the same as the price for Office Home & Student 2019.

Latest version of excel for mac