In PivotTables you can now design and create a preferred layout and save it as your default.Function autocomplete has been around for a while now, but has been improved to return all the functions that contain a typed word, for example typing “=lookup” will list HLOOKUP and VLOOKUP as well as LOOKUP.Inking was introduced in an earlier version of Office, but features added to Excel 2019 include using a Lasso tool to select, or a Surface pen to select and move, resize or rotate.As with PowerPoint and Word, icons and 3D models can be inserted from an online library of categorised items.Map and Funnel charts are further additions to Microsoft’s growing library of ways to visualise your data.New functions include CONCAT (an evolution of the CONCATENATION function) and IFS (so that users can finally leave complex nested IFs behind).And although Project and Visio are mentioned below, these apps are sold separately. Office 2019 is a one-time purchase for 1 PC that includes the classic Microsoft applications Excel, PowerPoint, Word and Outlook and also Access and Publisher. In this article, I will aim to concentrate on comparing two of the business versions of Microsoft Office – Office Professional 2019 and Office 365 Business Premium and some of the new and improved features in these version of Microsoft Office.

There are various ‘flavours’ of Microsoft Office – for example home users can buy Office Home & Student 2019 which includes Excel, PowerPoint and Word through to business users with a subscription to Office 365 Business Premium which includes Excel, PowerPoint and Word plus Access (PC only), OneNote, Outlook, Publisher (PC only) and OneDrive, Skype and various other collaboration tools. Whilst you will receive Microsoft security updates, these won’t include additional tools, systems and functionality.

Office 365 is a monthly or yearly-paid subscription service, providing continued support and updates throughout the lifetime of your subscription.

Here we compare the features and functionality of the two most-popular business options.

Microsoft now offer a variety of different Office licenses.

Office professional plus 2019 outlook