Excel 2019 adds new formulas and charts and enhancements to PowerPivot.
Some of the features include "Morph" and "Zoom" in PowerPoint 2019, a roaming pencil case, pressure sensitivity and tilt effects. Microsoft Search will give personalised results combining traditional search results, local files, commands, and more.
Spataro also noted that Microsoft is planning to release Exchange Server 2019, Skype for Business Server 2019, SharePoint Server 2019 and Project Server 2019 "in the coming weeks", although the exact timing wasn't described. "Microsoft Search" will be a unified search bar in Bing, Office apps, Windows, Teams for personal users and organisations.
It will also roll out some new products that help protect employees, including Microsoft Authenticator support for apps that use Microsoft's Azure Active Directory single sign-on technology allowing employees to sign into corporate resources without having to use a password.
This major update is available now on Mac and Windows devices and brings a number of improvements to the popular software including upgrades to Word, Excel Powerpoint and Outlook. If it hasn't been used, then organizations get the Universal Windows Platform app version instead when they install Office 2019. And that's for good reason: As Spataro told me, Office 2019 doesn't offer any of the cloud-connected features that Office 365 subscribers would see using the exact same apps. Alternatively, OneNote 2016 is available via the Office Deployment Tool.
Microsoft's release of Office 2019 this week has triggered a bit of confusion in the user community. And thanks to this rapid release schedule, which includes routine quality updates in addition to the new features, Office 365 customers are also more secure as well. Furthermore, as Office 2019 features are now set in stone, Office 365 will continue to be extended and enhanced with innovations in collaboration, artificial intelligence (AI), security, and more.
Organizations can not run Office 2019 simultaneously with Office 2016. Microsoft recommends uninstalling previous versions of Office before installing Office 2019.
"When an end user thinks about cybersecurity, they wish they didn't have to think about cybersecurity", Lefferts said.
"We will do another perpetual release of Office", Spataro told me. "And each time we release a new on-premises version of Office, customers ask us if this will be our last". We've done a full write up of why Office 365 is such a great deal, so we won't go into full detail here.