Using Microsoft Office 2019

Paths

Using Microsoft Office 2019

Authors: J. Peter Bruzzese, Heather Ackmann, Bill Kulterman, Shari Oswald, Alan Wright, Diane McSorley, Ben Howard

Microsoft Office is a suite of cross-compatible applications and services that include programs for word processing, spreadsheets, presentations, information management,... Read more

What you will learn:

  • Word
  • Excel
  • PowerPoint
  • Outlook
  • Access
  • Publisher
  • OneNote
  • Visio
  • Project and Project Online

Pre-requisites

No prerequisite knowledge needed.

Beginner

In this beginner section we will cover how to navigate and use different Microsoft Office applications.

What's New in Office 2019

by J. Peter Bruzzese

Mar 13, 2019 / 1h 32m

1h 32m

Start Course
Description

Learn what’s new in Office 2019. In this course, What’s New in Office 2019, you will learn all 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. When you’re finished with this course, you will have the skills and knowledge revolving around what's new in Office 2019.

Table of contents
  1. New Multi-application Features
  2. New Application-specific Features

Word 2019 Essentials

by Heather Ackmann

Feb 14, 2019 / 2h 44m

2h 44m

Start Course
Description

Learn the basics of Word 2019. 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 and knowledge of Word 2019 Essentials needed to begin creating your own professional documents (and begin preparation for the Microsoft Office exams).

Table of contents
  1. Create a Document
  2. Navigate Through a Document
  3. Format a Document
  4. Print and Save Documents
  5. Insert Text
  6. Format Text and Paragraphs
  7. Create Tables
  8. Modify Tables
  9. Create and Modify Lists
  10. Insert Graphic Elements
  11. Format Graphic Elements

Excel 2019 Essentials

by Bill Kulterman

Jan 31, 2019 / 2h 5m

2h 5m

Start Course
Description

Knowing the basics of Excel 2019 can help make you a more well rounded professional. In this course, Excel 2019 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 and knowledge of Excel 2019 needed to begin creating your own spreadsheets (and begin preparation for the Microsoft Office exams.)

Table of contents
  1. Getting to Know Excel 2019
  2. Backstage View
  3. Working with Worksheets and Data
  4. Working with Rows and Columns
  5. Formatting
  6. Totaling Values
  7. Saving a File

PowerPoint 2019 Essentials

by Bill Kulterman

Feb 15, 2019 / 2h 24s

2h 24s

Start Course
Description

Learn the basics of PowerPoint 2019. In this course, PowerPoint 2019 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 learn how to run a presentation. When you’re finished with this course, you will have the skills and knowledge of PowerPoint 2019 needed to begin creating your own professional slide presentations and begin preparation for the Microsoft Office exams.

Table of contents
  1. Getting to Know PowerPoint
  2. Creating Basic Presentations
  3. Using Pictures
  4. Preparing to Run a Presentation

Outlook 2019 Essentials

by Heather Ackmann

Jun 18, 2019 / 1h 52m

1h 52m

Start Course
Description

Learn the basics of Outlook 2019. In this course, Outlook 2019 Essentials, you begin the process of learning Outlook 2019. First, you'll 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'll have the skills and knowledge of Outlook 2019 Essentials needed to begin using email in a business environment (and continue your preparation for the Microsoft Office exams).

Table of contents
  1. Getting Started with Outlook 2019
  2. Create and Manage Messages
  3. Format a Message
  4. Organize and Manage Messages Basics
  5. Create Basic Appointments, Meetings, and Events
  6. Create and Manage Calendars
  7. Create and Manage Notes and Tasks

Access 2019 Essentials

by Shari Oswald

Oct 3, 2019 / 1h 38m

1h 38m

Start Course
Description

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. In this course, Access 2019 Essentials, you will be will introduced to Access 2019, Microsoft’s application for creating working database solutions. First, you’ll begin with navigation lessons to help you find your way around the Access interface. Next, you will explore the basics of working with databases and tables. From there you’ll move into working with and sorting records, working with filters, forms, queries, and reporting. Finally, you'll explore and understand database objects. When you’re finished with this course, you will have the skills and knowledge of Access 2019 needed to begin development (and begin preparation for the Microsoft Office exams).

Table of contents
  1. Getting Started with Microsoft Access
  2. Working with Databases and Tables
  3. Table Basics and Sorting Records
  4. Working with Filters and Forms
  5. The Basics of Queries and Reports
  6. Working with Database Objects

Publisher 2019

by Shari Oswald

Aug 5, 2019 / 1h 13m

1h 13m

Start Course
Description

While there are many solutions available for publishing (online or in-print), Microsoft’s Publisher 2019 is very robust. In this course, Publisher 2019, you’ll learn the basics of how to work with Publisher 2019. First, you will do a quick tour of Publisher and help get your bearings. Then, you will explore different editing tips and tricks to fully utilize Publisher 2019. Finally, you will do a final check and edit proof before sharing your completed publication. Upon completion, you’ll be ready to use Publisher 2019 to make professional looking documentation.

Table of contents
  1. Getting Started in Publisher 2019
  2. Creating and Saving Publications
  3. Editing Your Publication
  4. Working with Pages
  5. Controlling Common Content
  6. Working with Text
  7. Adding Illustrations
  8. Finishing Your Publication
  9. Sharing Your Publication

OneNote for Windows 10

by Heather Ackmann

Mar 29, 2019 / 58m

58m

Start Course
Description

If you are someone who uses OneNote and wants to maximize the use, this course, OneNote for Windows 10, is for you. First, you'll look at creating, managing, and sharing notebooks. Then, you'll look at formatting and finding notes. Finally, you'll explore how to insert content. By the end of this course, you will be proficient at using OneNote for Windows 10..

Table of contents
  1. Manage and Share Notebooks
  2. Creating, Formatting, and Finding Notes
  3. Inserting Content

Visio 2019 Essentials

by Alan Wright

Jan 23, 2019 / 1h 57m

1h 57m

Start Course
Description

This course, Visio 2019 Essentials, will introduce you to Visio 2019, Microsoft's application for creating visual diagrams, including flowcharts, process maps, network diagrams, organization charts, and more. You'll become familiar with shapes, stencils, templates, connectors, containers, callouts, embellishments, and working with text. You'll also learn best practices for printing.

Table of contents
  1. Getting Started with Visio
  2. Shapes, Stencils, and Templates
  3. Tools
  4. Text
  5. Printing

Project 2019 Online Essentials

by Diane McSorley

Sep 24, 2019 / 1h 49m

1h 49m

Start Course
Description

Microsoft’s powerful project management solution is online and it's not exactly the same as its on-premises older brother, but here you will learn what you can do with the online version. In this course, Project Online Essentials you’ll learn how to navigate through the UI, how to create projects and add tasks and how to publish your plan. Then you’ll move into project management features by integrating with your installed Project Professional application and learning how to use more intricate features of the solutions.

Table of contents
  1. Getting Started
  2. Project Management Features

Intermediate

In this intermediate section we will cover topics that a typical Microsoft Office power user needs to master.

Word 2019 Power Users

by Heather Ackmann

Mar 15, 2019 / 1h 29m

1h 29m

Start Course
Description

It's time to increase your skills and learn intermediate techniques of Word 2019. In this course, Word 2019 Power Users, you will learn about document collaboration and the use of references. First, you will learn how to customize options and views for documents. Next, you will explore 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 and knowledge of Word 2019 needed to continue in creating your own professional documents (and continue preparation for the Microsoft Office exams).

Table of contents
  1. Customize Options and Views for Documents
  2. Document Collaboration and Accessibility
  3. Manage Document Changes
  4. Create and Manage Reference Markers
  5. Create and Manage Advanced References

Excel 2019 Power Users

by Bill Kulterman

Aug 20, 2019 / 3h 26m

3h 26m

Start Course
Description

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

Table of contents
  1. Formatting Data
  2. Working with Workbooks and Worksheets
  3. Working with Data
  4. Printing a Workbook
  5. Working with Tables
  6. Working with Advanced Function

PowerPoint 2019 Power Users

by Bill Kulterman

Apr 16, 2019 / 2h 36m

2h 36m

Start Course
Description

Gain next level understanding of PowerPoint 2019. In this course, PowerPoint 2019 Power Users, you will build upon your foundational knowledge of the PowerPoint interface and settings. First, you will learn how to work with text, shapes, images, and objects. Next, you will discover how to insert and format tables and charts. Finally, you will explore printing presentations, and creating custom slide shows and animations. When you’re finished with this course, you will have the skills and knowledge of PowerPoint 2019 needed to create professional slide presentations (and continue preparation for the Microsoft Office exams).

Table of contents
  1. Working with Slides
  2. Working with Text
  3. Working with Shapes
  4. Working with Images
  5. Working with Objects
  6. Working with Tables
  7. Working with Charts
  8. Printing Presentations
  9. Creating Slide Shows
  10. Animations

Outlook 2019 Power Users

by Heather Ackmann

Aug 5, 2019 / 1h 13m

1h 13m

Start Course
Description

Learn the deeper aspects of Outlook 2019 and realize its full potential. In this course, Outlook 2019 Power Users, you advance your training with Outlook 2019. First, you will learn how to create and manage both contacts and contact groups. Next, you’ll see how to print Outlook items (emails, contacts, and calendars). Finally, you’ll discover how to customize Outlook settings and how to perform more advanced scheduling. When you’re finished with this course, you will have the skills and knowledge of Outlook 2019 needed to successfully use Outlook collaboration features in a business environment (and continue your preparation for the Microsoft Office exams.)

Table of contents
  1. Create and Manage Contacts
  2. Create and Manage Contact Groups
  3. Print Outlook Items
  4. Customize Outlook Settings
  5. Advanced Scheduling and Calendar Tasks

Access 2019 Power Users

by Shari Oswald

Sep 5, 2019 / 1h 49m

1h 49m

Start Course
Description

In this course, Access 2019 Power Users, you will dive further into the world of Access 2019. First, you’ll 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’ll discover more about creating and managing queries, forms, and reports. When you’re finished with this course, you will have the skills and knowledge of Access 2019 needed to expand your development (and continue preparation for the Microsoft Office exams).

Table of contents
  1. Working with Databases
  2. Working with Tables
  3. Understanding Data Types
  4. Working with Fields and Datatypes
  5. Creating and Managing Queries
  6. Creating and Managing Forms
  7. Creating and Managing Reports

Visio 2019 Power Users

by Bill Kulterman

Sep 24, 2019 / 2h 45m

2h 45m

Start Course
Description

This course will continue your understanding of Visio 2019. First, you’ll learn how to work with shapes and shape data. Then you’ll move into chart types and diagrams. Finally, you’ll be shown advanced Visio techniques.

Table of contents
  1. Working with Shapes and Shape Data
  2. Working with Chart Types and Diagrams
  3. Advanced Visio Techniques

Project 2019 Online Power Users

by Diane McSorley

Nov 6, 2019 / 1h 30m

1h 30m

Start Course
Description

Microsoft’s powerful project management solution is online, although it’s not exactly the same as its on-premises older brother. In this course, Project 2019 Online Power Users, you’ll learn how to create lists, work with documents, and more. You’ll learn how to convert to an enterprise project, how to begin and update a roadmap, and how to work with PWA Settings.

Table of contents
  1. Project Online Power Users

A Comprehensive Introduction to Microsoft Project 2019

by Ben Howard

Apr 15, 2019 / 4h 24m

4h 24m

Start Course
Description

Dealing with large projects can be daunting through the whole project lifecycle. In this course, A Comprehensive Introduction to Microsoft Project 2019, you will learn foundational knowledge of defining and creating a project, resources, assignments, as well as tracking and reporting. First, you will learn how to create a work breakdown structure, link tasks and then display and print the project's Critical Path. Next, you will discover the different resource types and how these, and costs, can be assigned to the project. Finally, you will explore how to how to formally close the project and create a template from the existing schedule. When you are finished with this course, you will have the skills and knowledge of Microsoft Project 2019 needed to use the Agile capabilities in the subscription version of Project, and how to print and communicate different aspects of the project plan using custom and pre-defined reports.

Table of contents
  1. Course Overview
  2. Microsoft Project Quick Tour
  3. Creating Tasks
  4. Defining Duration Estimates
  5. Linking Tasks and Displaying the Critical Path
  6. Entering External Constraints and Deadlines
  7. Creating and Assigning Resources, Costs & Work
  8. Creating Agile Projects
  9. Baselining the Project
  10. Reporting and Printing
  11. Tracking the Project
  12. Closing the Project

Advanced

In this advanced section we will cover all the remaining topics that a professional who would like a MOS certification should know. This section covers only the most popular Office applications.

Word 2019 Pro

by Heather Ackmann

Mar 1, 2019 / 1h 56m

1h 56m

Start Course
Description

Learn advanced techniques of Word 2019. In this course, Word 2019 Pro, you will learn about fields, styles and advanced management. 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 and knowledge of Word 2019 needed to feel fully complete in creating your own professional documents (and complete the preparation for the Microsoft Office exams.)

Table of contents
  1. Working with Fields
  2. Create Styles
  3. Create Custom Style Sets and Themes
  4. Manage Documents and Templates
  5. Automate Word Elements and Tasks
  6. Perform Advanced Editing and Formatting

Excel 2019 Pro

by Bill Kulterman

Aug 7, 2019 / 5h 20m

5h 20m

Start Course
Description

Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll 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'll have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams).

Table of contents
  1. Formatting
  2. Working with Data
  3. Power Query
  4. Text Functions
  5. Logical and Statistical Functions
  6. Expanded Functions
  7. Error Checking
  8. Conditional Formatting
  9. Charts
  10. Pivot Tables
  11. Advanced Options
  12. Finalizing a Workbook
  13. Macros
  14. Form Controls

PowerPoint 2019 Pro

by Bill Kulterman

Jun 3, 2019 / 2h 29m

2h 29m

Start Course
Description

Gain a full understanding of the many uses of PowerPoint 2019. In this course, PowerPoint 2019 Pro, you will build upon your already mature understanding of the PowerPoint interface and settings. First, you'll learn how to work with document outlines and use morph transitions. Next, you'll explore how to work with slide masters, SmartArt graphics, and media. Finally, you'll discover how to combine presentations, inspect and review a presentation, and deliver your presentation to an audience. When you’re finished with this course, you'll have the skills and knowledge of PowerPoint 2019 Pro needed to create, polish, and deliver professional slide presentations (and continue preparation for the Microsoft Office exams).

Table of contents
  1. Document Outlines
  2. Working with Masters
  3. Working with SmartArt Graphics
  4. Working with Media
  5. Combining Presentations
  6. Presenting a Slide Show
  7. Finalizing a Presentation

Outlook 2019 Pro

by Heather Ackmann

May 23, 2019 / 52m

52m

Start Course
Description

Learn the more advanced aspects of Outlook 2019. In this course, Outlook 2019 Pro, you complete your training with Outlook 2019. First, you'll 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 and knowledge of Outlook 2019 Pro needed to successfully use email in a business environment (and continue your preparation for the Microsoft Office exams).

Table of contents
  1. Manage Multiple Mail Accounts
  2. Advanced Search Operations
  3. Advanced Mail Management

Access 2019 Pro

by Shari Oswald

Nov 6, 2019 / 3h 9m

3h 9m

Start Course
Description

This course will move you to the deepest levels of the world of Access 2019. You’ll continue to explore what it takes to manage databases and work with key fields. Then you’ll begin learning about the relationship window and working with relationships. You’ll learn more about external sources, controlling data entry, advanced queries, form and report controls, and more. When you’re finished with this course, you will have the skills and knowledge of an Access 2019 pro needed to expand your development (and complete your preparation for the Microsoft Office exams.)

Table of contents
  1. Managing Databases and Working with Key Fields
  2. Using the Relationships Window and Managing Table Relationships
  3. Working with External Sources and Advanced Field Properties
  4. Controlling Data Entry
  5. Using Calculations in Queries
  6. Refining Query Results and Creating Advanced Queries
  7. Managing Data with Action Queries and Types of Field Controls
  8. Working with Form and Report Controls
  9. Formatting Your Forms and Reports
Offer Code *
Email * First name * Last name *
Company
Title
Phone
Country *

* Required field

Opt in for the latest promotions and events. You may unsubscribe at any time. Privacy Policy

By providing my phone number to Pluralsight and toggling this feature on, I agree and acknowledge that Pluralsight may use that number to contact me for marketing purposes, including using autodialed or pre-recorded calls and text messages. I understand that consent is not required as a condition of purchase from Pluralsight.

By activating this benefit, you agree to abide by Pluralsight's terms of use and privacy policy.

I agree, activate benefit