Salient features on Microsoft Office 2019

Each new version of Microsoft Office will also give users a lot of new features, including new features and improvements on the application such as effects creation tools, data analysis, formulas, new charts. ..These are the features of the Microsoft Office 2019 version .

As we all know, Microsoft Office 2019 will be based on Office 365 , including many features available on Office 365 from the version of Microsoft Office 2016. Microsoft does not develop its own code for Office 2019 , so the features of Office If 365 is not available, the new version of Office 2019 will not be updated either.

Based on this, users will review every updated version of Office 365, review the features introduced in the Preview version of Office 2019 and make the most reasonable predictions about the possible features in Office 2019 when it is officially released. Below this article Download.com.vn will introduce to you the new features in Office 2019. Specifically on Word, Excel and PowerPoint.

If you have not upgraded to the version of Microsoft Office 2019, please see the article How to install Microsoft Office 2019 Offline .

Microsoft Office 2019 Microsoft Office 2019 for macOS

New feature of Microsoft Word 2019

1. Translate

There are quite a few features that support word processing that have been introduced into Word, but users may not be able to use them all. But Microsoft continues to improve on Word for users. One of them is the Translate feature , to use this feature, you can highlight the word or phrase you want to translate, right-click and select Translate to have Word translate. If there is a notice to use Microsoft Intelligent Services when you first use this feature, click OK.

Or you can choose to display the translation box first by clicking Review> Translate> Translate Selection

Next, the Translator frame will appear on the right side, including the window showing the text to be translated and the translated text at the bottom, the top (From) will determine the language of the text to translate. Just select the language you want to translate into the bottom (To) and click the arrow icon in the middle of the two windows to translate.

If you want to insert translated text into Word, click Insert.

2. Researcher (Smart Lookup)

Researcher is a tool that helps users research and learn about a phrase or word right in Word, and this tool is much more effective than the way you go out searching the Internet. It uses sources of information from accurate references that Microsoft considers reliable from Wikipedia and Bing .

If you want to use this tool, click on References and select Smart Lookup . The Researcher window will appear on the right hand side.

Next, highlight any keyword and right-click it, select Smart Lookup to use Researcher.

Soon, the Smart Lookup window will show you what the word or phrase means, along with a few images searched for from Bing.

3. Spelling & Grammar

This tool suggests the best synonyms, but Spelling & Grammar also contains any spelling errors in the text, they will also appear in the right window for you to correct and replace. To use this feature, click Review > select Spelling & Grammar from the Ribbon.

Immediately, the Spelling window will appear on the right, underline you with misspelled words, and give you synonyms to choose and replace.

In addition to the above 3 features, you also have a number of tools to help you read and write more naturally. Whether you are writing an unfamiliar language or just want to read a document in an easier style, just click View> Learning Tools> Column Width and select the view mode.

Plus you get new tools like

• Use LaTeX syntax to correct and create mathematical equations.
• Add extended symbols or vector graphics to your documents.
• View the files that users share with you, just click File> Open> Shared with me.
• Add many new icons for users.

New features of Microsoft Excel 2019

The first is that you will have a few new functions as follows

• CONCAT: Like CONCATENATE, but the new function is better. Shorter and support range references, in addition to cell references.
• IFS: With this function, the conditions are checked in the order you specify. If passed, the result will be returned. You can also specify someone else to "catch all" if no conditions are met.
• MAXIFS: This new function returns the maximum value between cells specified by a given set of conditions or criteria.
• MINIFS: Similar to MAXIFS but MINIFS will return the minimum value between cells specified by a certain set of conditions or criteria.
• SWITCH: Evaluates an expression based on a list of values ​​in order and returns the first match, if there are no matches, the result will be ELSE.
• TEXTJOIN: Combines text from many different ranges and each item will be separated by the marks you specify.

1. Map chart

You can create map charts to easily compare values ​​and category visibility by geographic area. You should use them when you have geographic areas in your data. For example in country, region, county, province, city, state or by zip code.

To make your chart, go to Insert > black out the data in the statistics table and choose Recommended Chart.

2. Funnel chart

Funnel charts show values ​​across multiple stages in a process. For example, you can use this type of chart to show the number of sales prospects at each stage in a sales "pipeline" . Usually the values ​​decrease gradually, like a funnel.

In addition, Excel 2019 also improves many different features to help you select the exact cells you want to select, this will help you deselect the wrong cells when selecting multiple cells at once, press Ctrl and click on the cells you want to deselect. . Format text values ​​as numbers or indexes, helping you present your data in a more attractive format.

3. Cooperation in real time

You will see the changes while editing an Excel file that is shared with others, in one file many people will edit the file and each will have a different color with a different name. Specifically, when someone does a task such as entering data into a cell in that Excel file, changes will appear.

These files are often used for groups, so when editing information, it is more convenient for each person to 1 file and then edit and send to each other to view, click Share in the right corner to share files to OneDrive or sharing method. other.

In addition, Excel 2019 also improves PivotTable , updates Power Pivot , publishes to Power BI, adds new Ink Effects, inserts 3D models and converts SVG icons into shapes ....

New features of Microsoft PowerPoint 2019

1. Morph

PowerPoint 's Animations tab provides users with tools to create transition effects between slides and details within the slide itself. But there is no animation that is easy to use and if created, it is quite time consuming.

So the Morph effect of the Transitions tab will allow you to show motion during transitions and inside slides, and no need to use the Animations tab .

Specifically, copy an existing slide, then edit the details for the newly copied slide. For example, can zoom, rotate, add details ... Then apply the Morph effect for that Slide , this time PowerPoint will automatically create animations between slides.

2. Zoom

This feature allows users to create an image content that allows you to zoom from part to content. To use you select Insert> Zoom , then select the Slide you want to display in that small frame. Slide that will display with thumbnails, when presenting you just click that thumbnail, very convenient.

3. Designer

Designer is an example of how Microsoft plans to use the intelligence artificial AI in Microsoft Office . When you add graphics to the Slide there is text on it. The designer will review the content and graphics, check out the rest of your presentation, and recommend the best layout for the Slide. Then choose the layout you feel best fits in the Design Ideas column .

4. QuickStarter

When you start using PowerPoint , if you don't know where to start then use this feature, it will give you by helping you create sketches, starting by entering the subject of the presentation and following. That select from the list of sub topics.

Next PowerPoint will show you a complete set of slides you want to use, based on searches and Bing and Wikipedia data . Select the slide and the interface for the selected slides, including the interface complete with background graphics, now you have a sketch of your presentation, and the time to complete the slide will be shortened. .

5. Some photos and other media

Edit the SVG icon

Like Excel , you can insert and edit vector graphics images and scale (SVG) in presentations to create sharp, beautifully designed content. Especially without loss of quality when zooming, can re-color these SVG images.

You can then convert the SVG image or icon into an Office shape, that is, you separate the SVG file and edit each part of the file separately.

3D model

Besides, 3D modeling is also a commonly used tool in presentations. You can download and use 3D models online from Microsoft's online library.

Eliminate unnecessary details on photos

Removing context from an image to emphasize or highlight the subject of an image or removing unnecessary details in an image, this tool can be used in both Word, Excel, PowerPoint and Outlook . Just select photos> Format> Remove Background and choose the part you want to remove.

Export Slide shows as 4K videos

In addition to the above photo effects, you can also export your slide shows into videos with many different formats, including high quality 4K format . Want to export your presentation file into video just go to File> Export> Create a Video , then select the quality you want to export.

Above are a few outstanding features of Microsoft Office 2019 , namely the most prominent tools on Word, Excel, and PowerPoint. There are many other features that you can explore during using Microsoft Office 2019.

Maybe you are interested:

• Instructions to change numbers into words quickly in Excel
• How to remove links, remove all links in Word
• How to insert Excel spreadsheets into Microsoft Word
• How to mix meeting invitations in Microsoft Word
• Why choose WPS Office instead of Microsoft Office