Thank you, John for completing my transition to the new computer effectively and efficiently.
Just like in its previous versions, Microsoft Office 2019 includes its popular tools like Word, Outlook, PowerPoint, Excel, and updated versions of Publisher 2019, Access 2019, and Visio 2019. Many of our clients in Chicagoland are using Microsoft’s Office 365, a cloud subscription-based service. Office 2019 is different. It allows you to pay a one-time fee to get access to the tools it includes, and you’ll have them forever. Want to know more? We’ll tell you what’s new below.
It’s great for businesses that don’t want a cloud solution. It comes with volume licensing so you can use it on any number of computers. You can also use Office 2019 applications on all your mobile devices, where you’ll have access to its basic features.
It’s supported on all devices that run Windows 10 or the three most recent versions of macOS. It supports macOS, macOS Sierra (10.12), Mojave (10.14), and High Sierra (10.13). If you are still using Windows 8.1 or Windows 7 (hopefully you aren’t) you’ll have to purchase a subscription for Office 365 to use Office 2019.
6 Great New Functions In Excel
1. SWITCH. The SWITCH function compares one value against a list of values. It provides a result corresponding to the first match. It will use an optional default value if no match is found. SWITCH allows you to test more than one condition without nesting. This makes it easier to read and create formulas with many conditions.
2. CONCAT. The CONCAT function supports individual cell references, just like CONCATENATE does. But is also supports ranges references as well. CONCAT replaces Excel Mobile and Excel Online.
3. IFS. The IFS function determines whether one or more conditions are met. It will return a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements. It’s much easier to read when applying multiple conditions.
4. MAXIFS. Use the MAXIFS function when you want to return the largest number in a range. If you want, you can set the returned number to one that meets certain criteria.
5. MINIFS is the same as MAXIFS, except that it will return the smallest number.
6. TEXTJOIN is a unique function that can combine text from multiple ranges. You can choose how each text is separated (for example, with a comma, a full stop, or any other delimiter).
The 2019 version of Excel also brings in some great new functions like Power Pivot, 2D maps, and Power Query enhancements. You’ll have access to new formulas, new charts (like funnel charts and 2D maps), and you can publish your work from Excel to Power BI.
You’ll Really Like These New Features In PowerPoint
Do You Ink? Then You’ll Like Inking In Office 2019 Even More!
If you use touch-enabled devices, you’ll love the new inking features added to Microsoft Office 2019. Tap into the new inking capabilities across all of Office 2019’s apps, such as pressure sensitivity, and the tilt effect that adjusts the ink’s thickness depending on the angle of the pen.
You can highlight text, or delete whole written words or areas of text with the Ink Tools > Eraser option in the Pens tab. You’ll even have a roaming pencil case to store and organize your favorite pens, pencils, and highlighters to roam with across your different devices.
And Of Course, There Are New Features In Word.
Word has a new look and is black themed. However, it has all the features that you’re used to. Plus, Word in Office 2019 has incorporated learning tools, a new text-to-speech feature and sounds that you can personalize.
What’s New In Outlook?
You’ll like Outlook’s improved user details, its support, and the look of the inbox. Some new features include:
What About OneNote?
This is an entirely new release in Office 2019. It can replace OneNote 2016 (the 2016 version is still available and supported until 2025). OneNote now has ink-to-text support. This means that you can convert your handwritten words into a typed text.
Microsoft advises that if you want to move to Office 2019 from Office 2016, you shouldn’t delay. This is because Office 2016 cloud support will be dropped in 2020. And Office 2016 installs will be barred from connecting to Microsoft’s cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business), after Oct. 13, 2020.
Outsource IT Solutions Group is a Microsoft Gold-Certified Partner. This means that we collaborate with, and have a close working relationship with Microsoft. And it shows that we’ve earned the highest standards of Microsoft’s widely-recognized partnership program.
Need more information about Microsoft products or IT in general? Check out our Tech Articles.