Microsoft 2016 Training Materials Bundle

1 x Excel 2016 Part 1: Performing Calculations

1 x Excel 2016 Part 1: Modifying a Worksheet

1 x Excel 2016 Part 1: Formatting a Worksheet

1 x Excel 2016 Part 1: Printing Workbook Contents

1 x Excel 2016 Part 1: Managing Large Workbooks

1 x Excel 2016 Part 1: Customizing the Excel Environment

1 x Excel 2016 Part 2 - Enhancing Workbooks

1 x Excel 2016 Part 2 - Inserting Graphics

1 x Excel 2016 Part 2 - Analyzing Data with PivotTables, Slicers, and PivotCharts

1 x Excel 2016 Part 2 - Visualizing Data with Charts

1 x Excel 2016 Part 2 - Organizing Worksheet Data with Tables

1 x Excel 2016 Part 2 - Analyzing Data with Logical and Lookup Functions

1 x Excel 2016 Part 2 - Creating Advanced Formulas

1 x Excel 2016 PowerPivot: Getting Started With Power Pivot

1 x Excel 2016 PowerPivot: Distributing PowerPivot Data

1 x Excel 2016 PowerPivot: Using Dax Functions In Power Pivot

1 x Excel 2016 PowerPivot: Creating PowerPivot Reports

1 x Excel 2016 PowerPivot: Manipulating PowerPivot Data

1 x PowerPoint 2016 Part 1: Getting Started with PowerPoint

1 x PowerPoint 2016 Part 1: Developing a PowerPoint Presentation

1 x PowerPoint 2016 Part 1: Performing Advanced Text Editing

1 x PowerPoint 2016 Part 1: Adding Graphical Elements to Your Presentation

1 x PowerPoint 2016 Part 1: Modifying Objects in Your Presentation

1 x PowerPoint 2016 Part 1: Adding Tables to Your Presentation

1 x PowerPoint 2016 Part 1: Adding Charts to Your Presentation

1 x PowerPoint 2016 Part 1: Preparing to Deliver Your Presentation

1 x PowerPoint 2016 Part 2 - Securing And Distributing A Presentation

1 x PowerPoint 2016 Part 2 - Customizing A Slide Show

1 x PowerPoint 2016 Part 2 - Collaborating On A Presentation

1 x PowerPoint 2016 Part 2 - Working With Media And Animations

1 x PowerPoint 2016 Part 2 - Adding Smartart To A Presentation

1 x PowerPoint 2016 Part 2 - Customizing Design Templates

1 x PowerPoint 2016 Part 2 - Modifying The Powerpoint Environment

1 x Word 2016 Part 1 - Getting Started with Word

1 x Word 2016 Part 1 - Editing a Document

1 x Word 2016 Part 1 - Formatting Text and Paragraphs

1 x Word 2016 Part 1 - Adding Tables

1 x Word 2016 Part 1 - Managing Lists

1 x Word 2016 Part 1 - Inserting Graphic Objects

1 x Word 2016 Part 1 - Controlling Page Appearance

1 x Word 2016 Part 1: Proofing a Document

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course explores the commands on the Review tab, including spell check, the Research pane, and the thesaurus. Components of making a document accessible and how to check accessibility are also covered.

1 x Word 2016 Part 1: Customizing the Word Environment

Course Length: 16 Weeks Course Hours: 8 ________________________________________________________________________ Course Overview In this course, students will learn how to customize the Microsoft Word interface, modify save options, and manage other file types.

1 x Word 2016 Part 2: Using Macros

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course looks at automating tasks using macros.

1 x Word 2016 Part 2: Using Mail Merge

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course focuses on performing a mail merge. Information is also provided on creating a data source and merging envelopes and labels.

1 x Word 2016 Part 2: Using Templates

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course explores how to create, modify, and manage templates.

1 x Word 2016 Part 2: Controlling Text Flow

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________   Course Overview This course covers four main techniques for controlling text flow: setting paragraph options, using section breaks, formatting text as columns, and linking text boxes.

1 x Word 2016 Part 2: Inserting Content Using Quick Parts

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________   Course Overview This course takes a closer look at Building Blocks, particularly Quick Parts and fields.

1 x Word 2016 Part 2: Creating Custom Graphic Elements

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview Several other types of graphics are covered in this course, including text boxes, shapes, WordArt, and SmartArt.

1 x Word 2016 Part 2: Using Images in a Document

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course will cover resizing images, adjusting image appearance, and integrating pictures and text. Adding screenshots and videos to a document are also discussed.

1 x Word 2016 Part 2: Customizing Formats Using Styles and Themes

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course focuses on creating and modifying text, list, and table styles. Applying and customizing document themes will also be covered.

1 x Word 2016 Part 2: Working with Tables and Charts

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________   Course Overview To begin the course, students will learn how to work with tables by sorting data, controlling cell layout, and performing calculations. Students will also learn how to create and modify charts.

1 x Word 2016 Part 3: Collaborating On Documents

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course begins with a look at modifying user information and sharing documents. We also take a look at working with comments and comparing document changes. The course concludes with reviewing a document, merging document changes and coauthoring documents.

1 x Word 2016 Part 3: Simplifying And Managing Long Documents

1 x Word 2016 Part 3: Managing Document Versions

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This final course focuses on creating, comparing, and combining document versions by using Microsoft Office SharePoint Server with Microsoft Word 2016.

1 x Word 2016 Part 3: Adding Reference Marks And Notes

Course Length: 16 Weeks Course Hours: 8 ________________________________________________________________________ Course Overview This course explores how to annotate documents with reference tools, such as captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations, and bibliographies.

1 x Word 2016 Part 3: Securing A Document

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview This course covers how to suppress information from a document, set editing restrictions, add a digital signature to a document, and restrict document access.

1 x Word 2016 Part 3: Forms

Course Length: 16 Weeks Course Hours: 24 ________________________________________________________________________ Course Overview In this course, students will learn how to create, and manipulate forms. Techniques for saving and exporting form data are also covered.

1 x Outlook 2016 Part 1: Getting Started with Outlook 2016

1 x Outlook 2016 Part 1: Customizing the Outlook Environment

1 x Outlook 2016 Part 1: Working with Tasks and Notes

1 x Outlook 2016 Part 1: Managing Your Contacts

1 x Outlook 2016 Part 1: Managing Your Calendar

1 x Outlook 2016 Part 1: Managing Your Messages

1 x Outlook 2016 Part 1: Reading and Responding to Messages

1 x Outlook 2016 Part 1: Composing Messages