Microsoft office 2019 home and business windows#

You only need to refer to the range and specify a delimiter, and Excel does the rest. They let you compare data across different geographical regions, such as countries, regions, states, counties or postal codes.ДЄmong the functions added to Excel are TEXTJOIN and CONCAT, which let you combine text strings from ranges of cells with or without using a delimiter separating each item, such as a comma. Map charts are useful as well, and probably have wider applicability for most people. (Click any image in this story to enlarge it.) IDGДЇunnel charts, available in Excel 2019, let you display values at multiple stages in a process. Overall theyвЂ™re a nice-to-have addition to Excel. Generally, the values in funnel charts decrease with each stage, so the bars in the chart look like a funnel. A funnel chart can show the number of sales prospects at every stage of a sales process, for example, with prospects at the top for the first stage, qualified prospects underneath it for the second stage, and so on, until you get to the final stage, closed sales. ExcelвЂ™s new features focus primarily on data analysis, including funnel charts and 2D maps, new functions and connectors, the ability to publish from Excel to PowerBI, and enhancements to PowerPivot and PowerQuery.ДЇunnel charts are useful when you want to display values at multiple stages in a process. There are a few nice tidbits for Excel users in Office 2019, but donвЂ™t expect anything dramatic. There will still, however, be both 32-bit and 64-bit versions of it.

Microsoft office 2019 home and business windows#

One final note about Office 2019 before we get into the nitty-gritty: Unlike previous releases of the perpetual version of Office, it will run only on Windows 10. (In addition to the features covered here, Office 2019 gets improved support for digital ink across the entire suite, including what Microsoft calls вЂњroaming pencil caseвЂќ support, which lets you write by hand and also move around sections of documents with a digital pencil.) So whatвЂ™s new in Office 2019? And which is better for you or your organization, Office 2019 or Office 365? To help you decide, weвЂ™ve taken a look at Office 2019вЂ™s most important new features below, and then compared it to Office 365. So the company had nothing new to wow the world with when talking about Office 2019. ThereвЂ™s nothing new in Office 2019 that hasnвЂ™t already been available for quite some time to millions of Office 365 subscribers (the company says it has more than 31 million subscribers to consumer editions), and in fact, Microsoft left several features out of Office 2019 that it had introduced in Office 365 over the past few years. Office 2019 is considerably less powerful than Office 365. It used to be that whenever Microsoft released Office with a new version number - for example, Office 2016 - that version was more powerful than any other available. ThereвЂ™s another reason that Microsoft whispered.

ItвЂ™s clear that Microsoft wants people to move to Office 365, so it wants to draw as little attention as possible to any new perpetual Office release. ThatвЂ™s in contrast to Office 365, which requires an ongoing subscription fee and is constantly updated with new features. When you purchase a perpetual version of Office, such as Office 2016 or Office 2019, you pay a one-time fee for it and own it forever - and it never gets new features. ThereвЂ™s good reason for that: Microsoft is pushing Office 365, the subscription of version of Office, over the perpetual version of the suite. In years gone by, Microsoft typically trumpeted new Office releases with great fanfare and hoopla, but this time it released a blog post or two with few details and left it at that. When Microsoft released Office 2019 for Windows this fall, it did so not with a bang, but a whisper.