The top pane attempts to identify the original language. The top of the pane shows your selection, and the bottom shows the translation. You won’t have to do it again.Īfter that, the Translator pane appears. If it’s the first time you’ve used one of these AI-driven features, a screen appears asking if you want to turn Intelligent Services on. Note that Translator is part of what Microsoft calls Intelligent Services, the artificial intelligence behind such Office features as Smart Lookup and Researcher. To translate words or phrases with it, you select them, then right-click your selection and choose Translate from the menu that appears. The only significant new feature Word gets in Office 2019 is the Translator pane, useful for those who need to work in multiple languages. The upshot for Excel 2019: Nice new additions. Get more details about them all from Microsoft. And two more, MAXIFS and MINIFS, make it easier to filter and calculate data in a number of different ways.
#BEST BUY MICROSOFT HOME OFFICE 2019 SERIES#
Two other functions added are the IFS and SWITCH functions, which help specify a series of conditions, for example, when using nested IF functions. 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.
#BEST BUY MICROSOFT HOME OFFICE 2019 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.
0 kommentar(er)
