VBT Office 2019 New Features - English

This video-based training comprises a total of 124 video learning nuggets on the topic of Microsoft Office 2019 new features and makes it really easy for you to enter the world of Microsoft Office 2019! Learn how to use the new features efficiently in everyday business as well as in your spare time and work with the new interface and menu design.

After completing this educational video, you will will have knowledge on the following Topics:

• Excel 2019
• Word 2019
• PowerPoint 2019
• Outlook 2019
• Office 2019

This VBT is ideal for experienced users who want to learn everything about the new version

It would be best to have some knowledge of older Microsoft Office versions. But no deep knowledge is required.

Excel

Welcome

• Overview

Interface

• Working with two Windows
• Precise Selection
• Quick Navigation

New Features

• Quick Analysis
• Flash Fill
• Filtering Spreasheet Date with Slicers
• One-click Forecasting
• New function: CONCAT
• New function: IFS
• New function: MAXIFS
• New function: MINIFS
• New function: SWITCH
• New function: TEXTJOIN

Charts

• Recommended Charts
• New Charts
• New diagram: Map Chart
• Chart Tools Tab
• Quick Optimization

Pivot

• Recommended PivotTables
• Multiple Table Data for PivotTables
• Quick Explore
• Activate PowerPivot
• Insert Timeline
• Customize the PivotTable default layout

Office

Welcome

• Overview

Interface

• The Office Start Screen - Quicker Start to Work
• New Ribbon Design
• Microsoft Office Backstage View
• Sharing
• Chatting with Co-authors

New Features

• Tell me what you want to do
• Smart Lookup
• "Dictate" Function
• Translating texts
• New tools for proofreading
• Improvements to accessibility
• Solving accessibility problems
• Live Preview for Formatting and Pasting from the Clipboard
• Adding recently used links

Edit Pictures

• Inserting Screenshots
• SmartArt-Graphic Layouts
• Artistic Effects & Picture Correction
• Compress Image and Delete Cropped Areas
• Simplified background removal
• "Transpareny" Function
• 3D Models
• Ink Editor
• Convert your handwritten Ink
• Using icons
• Converting SVG icons into shapes

Outlook

Welcome

• Overview

Interface

• The New Navigation Bar
• Get an quick overview
• Show E-Mails & select Attachments
• Focused Inbox
• Customizing the inbox

New Features

• Replying Faster
• Attaching files
• Quickly Deleting a Message

Tips & Tricks

• Working with Contacts in Outlook
• Instant Search

PowerPoint

Welcome

• Overview

Interface

• Presenter View
• Select Different Views

New Features

• Overview
• Collaborating on the same Presentation
• Text Highlighting
• Screen Recording
• The record function

Design

• New Designs
• Color Dropper
• Combining Shapes
• Zoom
• Smart Guides

Word

Welcome

• Overview

Interface

• Reading View
• Backstage Area Options

New Functions

• Expand or Collapse Headings
• Track Changes
• Markup and Comments with Replies
• Alignments
• Immersive Reader

Navigating within a Document

• Switch Between Documents
• Changes and New Tabs
• Menu Ribbon Display Options
• The Navigation Pane
• Document View

Working in a Document

• Opening and Editing PDF Files
• Working with Tables - Inserting Columns & Rows
• Using LaTeX formulas