Using Microsoft Office 2016

Paths

Using Microsoft Office 2016

Authors: Heather Fitzpatrick, Patricia Ciszek, J. Peter Bruzzese, Alan Wright, Diane McSorley, Heather Ackmann, 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 Heather Fitzpatrick

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 365
  2. What's New in Word 2016
  3. What's New in Excel 2016
  4. What's New in PowerPoint 2016
  5. What's New in OneNote 2016
  6. What's New in Outlook 2016
  7. What's New in Access 2016
  8. What's New in Visio 2016
  9. What's New in Project 2016
  10. What's New in Publisher 2016
  11. What's New in Skype for Business
  12. What's New in Outlook on the Web
  13. What's New in Delve
  14. What's New in Sway

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 31m

1h 31m

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 Started
  2. Working with Documents
  3. Formatting Text and Paragraphs

Excel 2016 for Windows and Mac: Essentials

by Pluralsight

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 Excel
  2. Data Entry Techniques
  3. Managing Lists with Excel 2016
  4. Calculating with Formulas and Functions
  5. Formatting Worksheets
  6. Printing Worksheets

Using Office PowerPoint (2016)

by Heather Ackmann

Apr 13, 2016 / 2h 59m

2h 59m

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 Started
  2. Working with Presentations
  3. Working with Text, Tables, and Formatting Options
  4. Working with Pictures, Shapes, Objects, Charts, and SmartArt
  5. Transitions, Animations, Hyperlinks, and Actions
  6. Working with Video and Audio in PowerPoint 2016
  7. Setting up and Running a SlideShow

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 2016
  2. Working with Email
  3. Managing Mail
  4. Working with the Calendar
  5. Working with Contacts
  6. Working with Tasks
  7. Other Items

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 Started
  2. Better Using Tools in OneNote
  3. Sharing OneNote

Microsoft Access (2016)

by Patricia Ciszek

Jun 27, 2016 / 4h 26m

4h 26m

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 2016
  2. Working with Tables
  3. Fields and Queries
  4. Advanced Queries and Form Building
  5. Formatting and Printing
  6. Working with Data

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 2016
  2. Creating a Plan
  3. Working with Resources
  4. Managing Your Budget and Timeline
  5. Finding and Viewing Information
  6. Introduction to Reporting
  7. Creating Custom Reports, Tables, Fields, and Templates
  8. Master Projects

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 Publisher
  2. Editing Tips and Tricks
  3. Save and Publish Your Project

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 2016
  2. Shapes, Stencils, and Templates
  3. Tools
  4. Text
  5. Printing
  6. Sharing
  7. Tips

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 Started
  2. Sway: Create Something New
  3. Sway: Grab Attention with Content
  4. Sway: Polish and Publish Your Storyline

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

Using Skype for Business

by Pluralsight

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

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. Styles
  2. Advanced Formatting
  3. Word Tools

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 Formatting
  2. Functions
  3. Tables
  4. Graphics
  5. Printing
  6. Review
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
Learning Paths

Using Microsoft Office 2016

  • Number of Courses15 courses
  • Duration34 hours
  • Skill IQ available Skill IQ

Microsoft Office is a suite of cross-compatible applications and services that include programs for word processing, spreadsheets, presentations, information management, note-taking, project management, diagrams, and more. Being well-versed in Microsoft Office is a must for many business environments. This path will cover the essential information needed to be proficient in each one of the applications, as well as some advanced techniques in the more popular applications.

Courses in 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 Heather Fitzpatrick
  • 1h 35m Duration
  •  (64)

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
  • 1h 31m Duration
  •  (44)

Excel 2016 for Windows and Mac: Essentials

  • by Pluralsight
  • 2h 53m Duration
  •  (97)

Using Office PowerPoint (2016)

  • by Heather Ackmann
  • 2h 59m Duration
  •  (38)

Using Outlook (2016)

  • by Shari Oswald
  • 3h 20m Duration
  •  (39)

OneNote 2016

  • by Heather Fitzpatrick
  • 1h 8m Duration
  •  (78)

Microsoft Access (2016)

  • by Patricia Ciszek
  • 4h 26m Duration
  •  (46)

Project 2016 for Business Professionals

  • by Diane McSorley
  • 4h 25m Duration
  •  (65)

Using Publisher 2016

  • by Shari Oswald
  • 1h 2m Duration

Using Visio (2016)

  • by Alan Wright
  • 2h 48m Duration
  •  (40)

Using Office Sway (2016)

  • by Heather Fitzpatrick
  • 38m Duration
  •  (27)

Using Office Delve 365 (2016)

  • by Heather Fitzpatrick
  • 33m Duration
  •  (18)

Using Skype for Business

  • by Pluralsight
  • 1h 7m Duration
  •  (37)

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
  • 2h 23m Duration
  •  (18)

Excel 2016 for Power Users

  • by Diane McSorley
  • 3h 18m Duration
  •  (103)

Learn with the best

Heather Fitzpatrick
Heather Fitzpatrick
Heather Fitzpatrick’s interest in technology began while studying biology at Daytona State College. Through 12 years of delivering training she has earned active certifications: Microsoft Office Specialist (MOS) Master, Microsoft Technology Associate (MTA), ITIL and has been a Microsoft Certified Trainer (MCT) since 2010. In 2012 Microsoft appointed her MCT Regional Lead for the Eastern United States. 
Patricia Ciszek
Patricia Ciszek
Patricia Ciszek, Microsoft Office Instructor, has worked with the ONLC for over 15 years and has been creating video courseware with ClipTraining since 2011. She teaches expert level course content on Microsoft Office solutions.
J. Peter Bruzzese
J. Peter Bruzzese
J. Peter Bruzzese (one of the co-founders of ClipTraining.com) is an Exchange MVP and an internationally published technical author with over a dozen titles to his credit. In addition, he is a Microsoft Certified Trainer (MCT) and a Triple-MCSE and MCITP for Messaging. He has been a technical journalist for 15 years and is the Enterprise Windows columnist for InfoWorld.
Alan Wright
Alan Wright
Alan Wright has worked professionally in and around IT for over 10 years. He has provided enterprise-level support in the Detroit, Michigan, area and continues to provide software and hardware support for small business and residential users.
Diane McSorley
Diane McSorley
Diane McSorley is a Microsoft Certified Trainer with expertise in teaching beginner to expert levels in multiple applications, Microsoft technical course, and CompTIA courses.
Heather Ackmann
Heather Ackmann
Heather Ackmann is an accomplished instructor with a decade of teaching experience, helping students at the high school, college, and adult levels in a variety of topics. Specializing in Microsoft Office computer applications, she is a Microsoft Office Certified Master and holds a degree in English and Secondary Education.
Shari Oswald
Shari Oswald
Shari majored in Business Administration and minored in Communication at the University of Colorado. She has over 12 years of training experience in the areas of Leadership, Team Building, and Personal Development in addition to a wide range of computer software programs and operating systems.

Join our learners and upskill
in leading technologies