Using Microsoft Office 2016

Paths

Using Microsoft Office 2016

Authors: J. Peter Bruzzese, Heather Fitzpatrick, Diane McSorley, Patricia Ciszek, Alan Wright, Heather Ackmann, Bob Flisser, Shari Oswald

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

Related topics

Productivity Business Professional

What will you learn

  • Word
  • Excel
  • PowerPoint
  • Outlook
  • OneNote
  • Access
  • Project
  • Publisher
  • Visio
  • Sway
  • Delve
  • Skype for Business

Pre-requisites

No prerequisites are necessary for this path.

Beginner

In this section, you’ll get a glimpse of the interface, and learn all about the new features in Microsoft Office 2016.

What's New in Office 2016

by J. Peter Bruzzese

Dec 18, 2015 / 1h 35m

1h 35m

Start Course
Description

Get up to speed and learn what's new in Office 2016 in this short course. This course covers all the new features in Word, Excel, PowerPoint, OneNote, Outlook, Access, Visio, Project, Publisher, Skype for Business, Outlook on the Web, Delve, and Sway.

Table of contents
  1. The Difference between Office 2016 and Office 3656m
  2. What's New in Word 20164m
  3. What's New in Excel 20166m
  4. What's New in PowerPoint 20167m
  5. What's New in OneNote 20167m
  6. What's New in Outlook 20168m
  7. What's New in Access 20166m
  8. What's New in Visio 20166m
  9. What's New in Project 20167m
  10. What's New in Publisher 20169m
  11. What's New in Skype for Business4m
  12. What's New in Outlook on the Web 9m
  13. What's New in Delve5m
  14. What's New in Sway3m

Intermediate

In this section, you will learn the fundamentals of each of the different Microsoft Office applications and begin using them in a variety ways.

Microsoft Word (2016): Essentials

by Heather Ackmann

May 4, 2016 / 1h 32m

1h 32m

Start Course
Description

Interested in learning how to use Microsoft Word for your job or daily personal use? This course is the one for you! In this course, you will learn how to get started in Word 2016 by exploring the toolbar, ribbon, and changes from previous versions. Next you will learn about all the different things you can do when working with a document in Word 2016. Finally, this course will teach you important information about formatting and working with text and paragraphs to create the perfect finished document. By the end of this course, you'll know your way around Microsoft Word and you'll be able to use its many features for a variety of projects.

Table of contents
  1. Getting Started46m
  2. Working with Documents14m
  3. Formatting Text and Paragraphs30m

Excel 2016 for Windows and Mac: Essentials

by Bob Flisser

Dec 21, 2015 / 2h 53m

2h 53m

Start Course
Description

Learn the fundamentals of using and creating Excel spreadsheets, including entering and editing data, managing lists, writing formulas and using functions, formatting sheets, and printing your work.

Table of contents
  1. Getting Acquainted with Excel47m
  2. Data Entry Techniques13m
  3. Managing Lists with Excel 201636m
  4. Calculating with Formulas and Functions27m
  5. Formatting Worksheets27m
  6. Printing Worksheets21m

Using Office PowerPoint (2016)

by Heather Ackmann

Apr 13, 2016 / 3h 56m

3h 56m

Start Course
Description

PowerPoint is one of the best and most popular tools today for creating great presentations. Whether you are an IT Pro or just casual Office PowerPoint user, this course, Using Office PowerPoint 2016, will teach you the latest additions and features of PowerPoint 2016. First, you will learn how to set up your PowerPoint presentation. Next, you'll learn all about features and functions you can integrate into the presentation for a rich and dynamic experience. Finally, you'll learn about the different ways to present, publish, and share a finished PowerPoint presentation. By the end of this course, you'll be able to use PowerPoint like a pro and give fantastic presentations every time.

Table of contents
  1. Getting Started20m
  2. Working with Presentations45m
  3. Working with Text, Tables, and Formatting Options36m
  4. Working with Pictures, Shapes, Objects, Charts, and SmartArt48m
  5. Transitions, Animations, Hyperlinks, and Actions35m
  6. Working with Video and Audio in PowerPoint 201622m
  7. Setting up and Running a SlideShow27m

Using Outlook (2016)

by Shari Oswald

Apr 6, 2016 / 3h 20m

3h 20m

Start Course
Description

This course introduces the new and improved features of Microsoft Outlook 2016. You'll become familiar with the layout of the Outlook environment, learn best practices for working with and managing email, and how to use the calendar, contacts, and tasks.

Table of contents
  1. The Basics of Outlook 201615m
  2. Working with Email25m
  3. Managing Mail48m
  4. Working with the Calendar24m
  5. Working with Contacts14m
  6. Working with Tasks17m
  7. Other Items56m

OneNote 2016

by Heather Fitzpatrick

Dec 21, 2016 / 1h 8m

1h 8m

Start Course
Description

If you are someone who uses OneNote and wants to maximize the use, this course OneNote 2016 is for you. First, you'll look at creating and adding to a notebook. Then, you'll look at writing notes, sending messages, and merging notes and sections. Finally, you'll explore how to tag, track changes, and share your notebooks with others on your team.

Table of contents
  1. Getting Started28m
  2. Better Using Tools in OneNote21m
  3. Sharing OneNote18m

Microsoft Access (2016)

by Patricia Ciszek

Jun 27, 2016 / 4h 27m

4h 27m

Start Course
Description

Do you have to create a desktop database? Microsoft Access 2016 is the tool for you. You will start with a brief introduction to Access 2016, before you get into tables, fields, queries, and form building. This course will teach you how to create browser-based databases with scalable and usable data. Software required: Microsoft Access (2016).

Table of contents
  1. Getting Started with Access 201657m
  2. Working with Tables30m
  3. Fields and Queries1h 4m
  4. Advanced Queries and Form Building54m
  5. Formatting and Printing43m
  6. Working with Data16m

Project 2016 for Business Professionals

by Diane McSorley

Apr 25, 2016 / 4h 25m

4h 25m

Start Course
Description

Microsoft Project 2016 is a great tool to help any business professional manage their projects from beginning to end. In this course, Project 2016 for Business Professionals, you will learn how to use Project 2016 to organize and complete your projects more efficiently than ever. First, you'll learn how to create a plan, work with tasks, and set deadlines to make management easier down the road. Next, you'll work with resources and the resource calendar and you'll also cover managing your budget and timeline. Finally, you'll explore how to find and view information, how to create reports that you can present, and learn about master projects. By the end of this course, you'll have a better management system for your projects and you'll be able to increase the efficiency and quality of your work.

Table of contents
  1. Getting Started with Project 201632m
  2. Creating a Plan57m
  3. Working with Resources35m
  4. Managing Your Budget and Timeline39m
  5. Finding and Viewing Information31m
  6. Introduction to Reporting21m
  7. Creating Custom Reports, Tables, Fields, and Templates32m
  8. Master Projects16m

Using Publisher 2016

by Shari Oswald

Dec 21, 2016 / 1h 2m

1h 2m

Start Course
Description

If you have a project that you want to integrate with Publisher 2016 this course, Using Publisher 2016, is the course for you. First, you will do a quick tour of Publisher and help get your projects organized. Then, you will cover different editing tips and tricks to fully utilize Publisher 2016. Finally, you will do a final check and edit before publishing your project. By the end of this course, you'll have a strong foundation of knowledge in order to use Publisher 2016 to to help enhance your projects.

Table of contents
  1. Getting Started with Publisher17m
  2. Editing Tips and Tricks36m
  3. Save and Publish Your Project9m

Using Visio (2016)

by Alan Wright

Apr 6, 2016 / 2h 48m

2h 48m

Start Course
Description

This course will introduce you to Visio 2016, 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, glue, themes, styles, containers, callouts, layers, embellishments, and working with text. You'll also learn best practices for printing and sharing, plus tips for creating diagrams and charts.

Table of contents
  1. Getting Started with Visio 201622m
  2. Shapes, Stencils, and Templates53m
  3. Tools44m
  4. Text9m
  5. Printing13m
  6. Sharing14m
  7. Tips10m

Using Office Sway (2016)

by Heather Fitzpatrick

Jun 17, 2016 / 38m

38m

Start Course
Description

If you want to learn a new, interactive way to give presentations, reports, and tell stories, then this course is for you! In Using Office Sway (2016), you'll learn the new features of Sway, how to create a Sway from scratch, how to grab attention with your content, and how to publish your storyline.

Table of contents
  1. Getting Started10m
  2. Sway: Create Something New7m
  3. Sway: Grab Attention with Content10m
  4. Sway: Polish and Publish Your Storyline9m

Using Office Delve 365 (2016)

by Heather Fitzpatrick

Jun 22, 2016 / 33m

33m

Start Course
Description

Get up and running with Microsoft Office Delve 2016 in this short course! In this course, you'll learn the new features, how to work with the content card, how to make authoring easy, and tips on searching for content and people.

Table of contents
  1. Getting Started8m
  2. Working with the Content Card6m
  3. All About Me6m
  4. Authoring Made Easy7m
  5. Search for Content and People4m

Using Skype for Business

by Heather Fitzpatrick

Jan 28, 2016 / 1h 7m

1h 7m

Start Course
Description

The Skype for Business platform can be used for calls, conferencing, video, and sharing. Whether you are new to Skype for Business or if you're coming from Lync, this course will get you up and running with everything you need to know to simplify communication. This course covers new features, contacts, groups, change alerts, instant messaging, meetings, calls, and sharing content.

Table of contents
  1. New Features4m
  2. Getting Started6m
  3. Adding Contacts and Creating Groups3m
  4. Tagging for Status Change Alerts2m
  5. Communicating with Instant Messaging7m
  6. Connecting from Outlook2m
  7. Starting an Unscheduled Online Meeting or Conference Call5m
  8. Scheduling and Starting a Meeting9m
  9. Transferring a File in a Meeting2m
  10. Sharing Presentable Content12m
  11. Making an Audio Call2m
  12. Making a Video Call5m
  13. Recording and Publishing a Meeting4m

Advanced

This section focuses on two of the most popular Microsoft Office applications: Word and Excel. You’ll take your foundational skills to the next level by learning more about styles, advanced formatting and tools, and functions.

Word 2016 for Power Users

by Heather Ackmann

Dec 21, 2016 / 2h 23m

2h 23m

Start Course
Description

Go beyond the basics with this Word 2016 for Power Users course. If you are someone who uses Word in your day to day operations then this course will help you maximize your usage. First, you'll learn about advanced formatting options before customizing and editing configuration settings. Then, you'll move onto what makes your Word experience pop, the art, pictures, tables, symbols, and other advanced tools.

Table of contents
  1. Styles24m
  2. Advanced Formatting30m
  3. Word Tools1h 27m

Excel 2016 for Power Users

by Diane McSorley

Dec 18, 2015 / 3h 18m

3h 18m

Start Course
Description

Go beyond the basics in this Excel 2016 for Power Users course. Busy business professionals will learn how to advance their Excel 2016 skills by learning conditional formatting, functions, tables, graphics, and printing.

Table of contents
  1. Conditional Formatting34m
  2. Functions43m
  3. Tables46m
  4. Graphics40m
  5. Printing24m
  6. Review9m
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