Office 2019

In this course, What’s New in Office ProPlus, you will learn about new features and feature enhancements in the Office ProPlus Suite (beyond what is already in Office 2019). The focus will be on the Office 365 subscription-based versions of Word, Excel, PowerPoint and Outlook.

In this course, What’s New in Office 2019, you will about new features and feature enhancements in the Office 2019 suite. First, you will learn the difference between Office 2019 and other flavors of Office. Next, you will discover all the new features that span across multiple applications. Finally you will learn application specific feature enhancements and new features for the entire Office 2019 suite.

In this course, Word 2019 Essentials, you will learn foundational knowledge of the Word interface and settings. First, you will learn how to create and navigate through a document. Next, you will discover how to work with text, tables and lists. Finally, you will explore how to insert and manipulate graphic elements. When you’re finished with this course, you will have the skills needed to begin creating your own professional documents (and begin preparation for the Microsoft Office exams).

In this course, Word 2019 Power Users, you will take your Word knowledge to the next level. First, you will learn how to customize options and views for documents. Next, you will learn about document collaboration, accessibility and the management of document changes. Finally, you will learn about reference markers and advanced references. When you’re finished with this course, you will have the skills needed to take your professional documents to the next level (and continue preparation for the Microsoft Office exams).

In this course, Word 2019 Pro, you will take your Word knowledge to the ultimate level. First, you will learn how to work with fields, create styles and custom style sets and themes. Next, you will learn more about managing documents and templates and automating Word elements and tasks. Finally, you will learn about advanced editing and formatting. When you’re finished with this course, you will have the skills needed to feel fully complete in creating your own professional documents (and complete the preparation for the Microsoft Office exams).

In this course, Excel 2019/365 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When you’re finished with this course, you will have the skills needed to begin creating your own professional spreadsheets (and begin preparation for the Microsoft Office exams).

In this course, Excel 2019/365 Power Users, you will take your Excel knowledge to the next level. First, you will learn how to format cells with borders, styles, shapes and more. Next, you’ll learn how to work with workbooks, worksheets and data. Then you’ll learn more about printing workbooks (in whole or parts). Finally you’ll learn about tables and a few advanced functions. When you’re finished with this course, you will have the skills to format and manage more advanced spreadsheets (and continue preparation for the Microsoft Office exams).

In this course, Excel 2019/365 Pro, you will take your Excel knowledge to the ultimate level. First, you will learn how to format and work with data . Then you’ll learn about queries, text/logical/statistical and other functions. Finally you’ll learn conditional formatting, charts, pivot tables, macros and form controls. When you’re finished with this course, you will have the skills needed to feel fully complete in creating professional spreadsheets (and complete preparation for the Office exams).

In this course, PowerPoint 2019/365 Essentials, you will learn foundational knowledge of the PowerPoint interface and settings. First, you will learn how to navigate through a presentation using the Ribbon and Backstage View. Next, you will discover how to create presentations and work with slides, add text and use pictures. Finally, you will prepare to run a presentation. When you’re finished with this course, you will have the skills needed to begin creating your own professional slide presentations (and begin preparation for the Microsoft Office exams).

In this course, PowerPoint 2019/365 Power Users, you will take your PowerPoint knowledge to the next level. First, you will learn how to work with text, shapes, images and objects. Next, you will learn how to insert and format tables and charts. Finally, you will learn about printing presentations, creating custom slide shows and animations. When you’re finished with this course, you will have the skills needed to create more advanced presentations (and continue preparation for the Microsoft Office exams).

In this course, PowerPoint 2019/365 Pro, you will take your PowerPoint knowledge to the ultimate level. First, you will learn how to work with document outlines and use morph transitions. Next, you will learn how to work with slide masters, SmartArt graphics and media. Finally, you will learn how to combine presentations, inspect and review a presentation and deliver your presentation to an audience. When you’re finished with this course, you will have the skills needed to create, polish and deliver professional presentations (and complete preparation for the Microsoft Office exams).

In this course, Outlook 2019 Essentials, you will learn foundational knowledge of the Outlook interface and settings. First, you will learn how to navigate the Outlook interface . Then you’ll learn how to create, format, organize and manage messages. Finally you’ll learn how to create appointments, meetings, events, tasks and notes. When you’re finished with this course, you will have the skills needed to begin using email in a business environment (and begin preparation for the Microsoft Office exams).

In this course, Outlook 2019 Power Users, you will take your Outlook knowledge to the next level. First, you’ll learn how to create and manage contacts and contact groups. You’ll also learn how to print Outlook items, customize Outlook settings and perform advanced scheduling and tasks. When you’re finished with this course, you’ll have the skills needed to use Outlook on a deeper level (and continue preparation for the Microsoft Office exams).

In this course, Outlook 2019 Pro, you will take your Outlook knowledge to the ultimate level. First, you will learn how to manage multiple email accounts, including 2-step verification. Next, you’ll learn advanced search operations, an essential aspect of working with email. Finally, you’ll learn advanced mail management features like working with Junk Email, using Rules and delegating access to your mailbox. When you’re finished with this course, you will have the skills needed to successfully use email in any business environment (and complete preparation for the Microsoft Office exams).

In this course, Access 2019 Essentials, you will learn foundational knowledge of the Access interface and settings. First, you will learn how to navigate your way around the Access interface. Next, you will learn the basics of working with databases and tables. From there you’ll move into working with and sorting records, working with filters and forms, queries and reporting. And we’ll finish up with an understanding of database objects. When you’re finished with this course, you will have the skills needed to begin basic database development (and begin preparation for the Microsoft Office exams).

In this course, Access 2019 Power Users, you will take your Access knowledge to the next level. First, you will continue your understanding of working with databases and tables. Then you’ll begin learning about data types and learn how to work with fields. Finally, you will learn more about creating and managing queries, forms and reports. When you’re finished with this course, you will have the skills needed to expand your database development (and continue preparation for the Microsoft Office exams).

In this course, Access 2019 Pro, you will take your Access knowledge to the ultimate level. First you will dive deeper into database management and key fields. Then you will learn more about relationships, external sources and advanced field properties. Finally, you will explore techniques for controlling data entry, queries, form and report controls and more. When you’re finished with this course, you will have the skills needed to fully develop a professional database (and complete preparation for the Microsoft Office exams).

In this course, Publisher 2019, you’ll learn how to use Microsoft’s solution for publishing professional documentation (online or in-print). First, you will go through a quick tour of Publisher and help get your bearings. Then, you will learn different editing tips and tricks to fully utilize Publisher 2019. Finally, you will learn how to do a final check and edit proof before sharing your completed publication.

In this course, OneNote for Windows, you will learn how to use the downloadable OneNote app for creating online notebooks. First, you'll look at creating, managing and sharing notebooks. Then, you’ll learn how to use formatting and how to find notes. Finally, you'll explore how to insert content.

In this course, Visio 2019 Essentials, you will first learn the basics of creating visual diagrams, including flowcharts, process maps, network diagrams, organization charts, and more. Then you will become familiar with shapes, stencils, templates, connectors, containers, callouts, embellishments, and working with text. Finally, you will learn best practices for printing.

In this course, Visio 2019 Power Users, you will take your Visio knowledge to the next level. First, you’ll learn how to work with shapes and shape data. Then you’ll move into chart types and diagrams. Finally, you will be shown advanced Visio techniques.