Using Microsoft Office 2016

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

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


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, Heather Fitzpatrick, Diane McSorley, Patricia Ciszek, Alan Wright

Dec 18, 2015 / 1h 35m

Beginner • 1h 35m

Start Course

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 365
    6m 7s
  2. What's New in Word 2016
    4m 19s
  3. What's New in Excel 2016
    6m 47s
  4. What's New in PowerPoint 2016
    7m 51s
  5. What's New in OneNote 2016
    7m 54s
  6. What's New in Outlook 2016
    8m 36s
  7. What's New in Access 2016
    6m 50s
  8. What's New in Visio 2016
    6m 20s
  9. What's New in Project 2016
    7m 2s
  10. What's New in Publisher 2016
    9m 16s
  11. What's New in Skype for Business
    4m 38s
  12. What's New in Outlook on the Web
    9m 43s
  13. What's New in Delve
    5m 52s
  14. What's New in Sway
    3m 55s


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

Beginner • 1h 32m

Start Course

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 Started
    46m 51s
  2. Working with Documents
    14m 38s
  3. Formatting Text and Paragraphs
    30m 41s

Excel 2016 for Windows and Mac: Essentials

by Bob Flisser

Dec 21, 2015 / 2h 53m

Beginner • 2h 53m

Start Course

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 Excel
    47m 29s
  2. Data Entry Techniques
    13m 1s
  3. Managing Lists with Excel 2016
    36m 22s
  4. Calculating with Formulas and Functions
    27m 42s
  5. Formatting Worksheets
    27m 42s
  6. Printing Worksheets
    21m 10s

Using Office PowerPoint (2016)

by Heather Ackmann

Apr 13, 2016 / 3h 56m

Beginner • 3h 56m

Start Course

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 Started
    20m 34s
  2. Working with Presentations
    45m 43s
  3. Working with Text, Tables, and Formatting Options
    36m 40s
  4. Working with Pictures, Shapes, Objects, Charts, and SmartArt
    48m 46s
  5. Transitions, Animations, Hyperlinks, and Actions
    35m 16s
  6. Working with Video and Audio in PowerPoint 2016
    22m 21s
  7. Setting up and Running a SlideShow
    27m 2s

Using Outlook (2016)

by Shari Oswald

Apr 6, 2016 / 3h 20m

Beginner • 3h 20m

Start Course

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 2016
    15m 7s
  2. Working with Email
    25m 19s
  3. Managing Mail
    48m 14s
  4. Working with the Calendar
    24m 16s
  5. Working with Contacts
    14m 27s
  6. Working with Tasks
    17m 1s
  7. Other Items
    56m 19s

OneNote 2016

by Heather Fitzpatrick

Dec 21, 2016 / 1h 8m

Beginner • 1h 8m

Start Course

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 Started
    28m 18s
  2. Better Using Tools in OneNote
    21m 51s
  3. Sharing OneNote
    18m 8s

Microsoft Access (2016)

by Patricia Ciszek

Jun 27, 2016 / 4h 27m

Beginner • 4h 27m

Start Course

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 2016
    57m 32s
  2. Working with Tables
    30m 28s
  3. Fields and Queries
    1h 4m 34s
  4. Advanced Queries and Form Building
    54m 31s
  5. Formatting and Printing
    43m 45s
  6. Working with Data
    16m 9s

Project 2016 for Business Professionals

by Diane McSorley

Apr 25, 2016 / 4h 25m

Beginner • 4h 25m

Start Course

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 2016
    32m 31s
  2. Creating a Plan
    57m 25s
  3. Working with Resources
    35m 6s
  4. Managing Your Budget and Timeline
    39m 39s
  5. Finding and Viewing Information
    31m 8s
  6. Introduction to Reporting
    21m 33s
  7. Creating Custom Reports, Tables, Fields, and Templates
    32m 27s
  8. Master Projects

Using Publisher 2016

by Shari Oswald

Dec 21, 2016 / 1h 2m

Beginner • 1h 2m

Start Course

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 Publisher
    17m 4s
  2. Editing Tips and Tricks
    36m 1s
  3. Save and Publish Your Project
    9m 3s

Using Visio (2016)

by Alan Wright

Apr 6, 2016 / 2h 48m

Beginner • 2h 48m

Start Course

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 2016
    22m 7s
  2. Shapes, Stencils, and Templates
    53m 25s
  3. Tools
    44m 46s
  4. Text
    9m 52s
  5. Printing
    13m 41s
  6. Sharing
    14m 18s
  7. Tips
    10m 12s

Using Office Sway (2016)

by Heather Fitzpatrick

Jun 17, 2016 / 38m

Beginner • 38m

Start Course

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 Started
    10m 14s
  2. Sway: Create Something New
    7m 44s
  3. Sway: Grab Attention with Content
    10m 52s
  4. Sway: Polish and Publish Your Storyline
    9m 58s

Using Office Delve 365 (2016)

by Heather Fitzpatrick

Jun 22, 2016 / 33m

Beginner • 33m

Start Course

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 Started
    8m 45s
  2. Working with the Content Card
    6m 2s
  3. All About Me
    6m 41s
  4. Authoring Made Easy
    7m 47s
  5. Search for Content and People
    4m 5s

Using Skype for Business

by Heather Fitzpatrick

Jan 28, 2016 / 1h 7m

Beginner • 1h 7m

Start Course

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 Features
    4m 37s
  2. Getting Started
    6m 11s
  3. Adding Contacts and Creating Groups
    3m 9s
  4. Tagging for Status Change Alerts
    2m 7s
  5. Communicating with Instant Messaging
    7m 9s
  6. Connecting from Outlook
    2m 14s
  7. Starting an Unscheduled Online Meeting or Conference Call
    5m 31s
  8. Scheduling and Starting a Meeting
    9m 1s
  9. Transferring a File in a Meeting
    2m 5s
  10. Sharing Presentable Content
    12m 16s
  11. Making an Audio Call
    2m 51s
  12. Making a Video Call
    5m 18s
  13. Recording and Publishing a Meeting
    4m 41s


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

Beginner • 2h 23m

Start Course

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. Styles
    24m 39s
  2. Advanced Formatting
    30m 47s
  3. Word Tools
    1h 27m 53s

Excel 2016 for Power Users

by Diane McSorley

Dec 18, 2015 / 3h 18m

Intermediate • 3h 18m

Start Course

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 Formatting
    34m 45s
  2. Functions
    43m 28s
  3. Tables
    46m 40s
  4. Graphics
    40m 44s
  5. Printing
    24m 5s
  6. Review
    9m 2s

What will you learn

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


No prerequisites are necessary for this path.

Register for FREE. Get your Pluralsight IQ.

You’ll get unlimited access to adaptive skill assessments that help you validate your skills in as little as 5 minutes, and you'll get to see the Pluralsight platform first-hand.