MINIFS is the same, but it will return the smallest number. SWITCH can be used to evaluate one value against a list of values, and it will return the result corresponding to the first matching value. If there is no match, you can set an optional default value.įinally, TEXTJOIN is a unique function that can combine text from multiple ranges – you can choose how each text is separated, for example, by a comma, a full stop, or any other delimiter. In the Office 2019 Professional Plus, you can now add Scalable Vector Graphics (SVG) into Excel, Word, and PowerPoint documents. This type of graphic can be easily rotated, moved, colored, and resized without any degradation to the quality of the image. You can also find a number of icons in the Insert tab. There will be a new Icon button here that can be used to access a variety of popularly used SVG icons. These icons may serve as an easy way to fancy up your emails or presentations, or just as a way to add some life to an otherwise dull document. Microsoft Translator is a new feature added to Word, Excel and PowerPoint. To access it, open the Review tab in your document and then click the new Translate and Language buttons. From here, you’ll have the opportunity to translate the entire document or translate a selected portion of text. It has been around for some time, but seeing it integrated into Office is excellent. Translation services like Microsoft Translator aren’t perfect, but over time they are becoming more accurate. Morph in PowerPoint Adds Better Animation and MotionĪ new transition called Morph has been added to PowerPoint. This powerful transition will allow you to add smooth movement between one slide to the next in a presentation. It’s essentially a straightforward way to get any animation created within seconds. PowerPoint will do the heavy lifting for you. To use Morph, you must first duplicate a slide, then move, resize, or edit the objects on the duplicated slide, and then click Transitions and morph. Doing this will automatically create a smooth animation from the original slide to the duplicated one. Zoom adds a new dynamic navigation option for presenting your PowerPoint slides. With Zoom, you will have thumbnails for all of your slides on one single page.
0 Comments
Leave a Reply. |