Microsoft
Microsoft Office Specialist (MOS) on Microsoft Office 2016
77-725 Word 2016: Core Document Creation, Collaboration, and Communication
Advanced Table Customization in Word 2016
Creating and Formatting Tables in Word 2016
Customizing Options and Using Document Views in Word 2016
Designing and Formatting Illustrations in Word 2016
Formatting Text in Word 2016
Headers, Footers, Page Numbering, and Layout in Word 2016
Maintaining, Protecting, and Reviewing Documents in Word 2016
References, Proofing, Mail Merges, and Forms in Word 2016
Sharing and Collaborating on Documents in Word 2016
Using Illustrations, Styles, and Themes in Word 2016
Using the Navigation Pane and Creating Lists in Word 2016
Working with the Interface and Performing Basic Tasks in Word 2016
Mentoring 77-725 Word 2016: Core Document Creation, Collaboration, and Communication
77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation
Microsoft Excel 2016 Advanced: Accessibility, Transforming Data, and Errors
Microsoft Excel 2016 Advanced: Apps and What-if Analysis
Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms
Microsoft Excel 2016 Essentials: Charts, Tables, and Images
Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks
Microsoft Excel 2016 Essentials: Data Presentation Strategies
Microsoft Excel 2016 Essentials: Formatting Data
Microsoft Excel 2016 Essentials: Formulas and Functions
Microsoft Excel 2016 Intermediate: Customizing Views, Styles, and Templates
Microsoft Office 2016 Intermediate Excel: Creating Custom Visual Effects
Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries
Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts
Microsoft Office 2016 Intermediate Excel: Share, Review, and Collaborate
Microsoft Office 2016 Intermediate Excel: Working with Data
Mentoring 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation
77-729: PowerPoint 2016 Core Presentation Design and Delivery Skills
Constructing and Modifying Tables and Charts in PowerPoint 2016
Creating Photo Albums, Sections, Transitions, and Animations in PowerPoint 2016
Customizing Proofing and Default Options in PowerPoint 2016
Designing Effective PowerPoint Presentations
Exporting Presentations and Compressing Media in PowerPoint 2016
Formatting Text Boxes and Working with Graphic Content in PowerPoint 2016
Introduction to the PowerPoint 2016 Interface and Basic Tasks
Modifying and Formatting Slides in PowerPoint 2016
Sharing and Protecting Presentations in PowerPoint 2016
Using Hyperlinks, Actions, and Comments in PowerPoint 2016
Using Slide Masters and Slide Elements to Optimize Impact
Using Slide Show Presentation Tools in PowerPoint 2016
Working with Graphic, Audio, and Video Content in PowerPoint 2016
77-730: Access 2016 Core Database Management, Manipulation, and Query Skills
Creating Relationships, Queries, Forms and Reports in Access 2016
Introduction to the Access 2016 Interface, Database Management, and Tables
77-731: Outlook 2016 Core Communication, Collaboration and Email Skills
Configuring and Managing Meetings and Notes in Outlook 2016
Configuring Message Options in Outlook 2016
Customizing and Managing Outlook 2016
Formatting E-mail in Outlook 2016
Getting to Know Outlook 2016
Managing Attachments, and Inserting Items and Signatures in Outlook 2016
Managing Automation, Storage, and Tidying Up in Outlook 2016
Managing Contacts, Tasks, and the Calendar in Outlook 2016
Managing Conversations and E-mail in Outlook 2016
Organizing Contacts in Outlook 2016
Using the Calendar to Schedule Appointments, Events, and Tasks in Outlook 2016
Viewing and Configuring Outlook 2016 Backstage Options

Advanced Table Customization in Word 2016

Course Number:
mo_inwo_a03_dt_enus
Lesson Objectives

Advanced Table Customization in Word 2016

  • start the course
  • set row and column sizes and copy or move rows and columns in tables in Word 2016
  • change cell spacing in tables and adjust table cell margins in Word 2016
  • use table AutoFit options to resize table rows or columns automatically in Word 2016
  • perform basic and more advanced sorting of tables in Word 2016
  • set a table header row to repeat on each page of a document in Word 2016
  • break table rows across pages in a Word 2016 document
  • split a table that spans more than one page in Word 2016
  • use formulas to calculate values in tables in Word 2016
  • apply number formatting to formulas and paste formulas in tables in Word 2016
  • convert existing text to a table or convert a table to text in Word 2016
  • position tables within other elements on a page in Word 2016
  • convert text to a table, use a formula to perform a calculation, and perform a basic table sort in Word 2016

Overview/Description
Microsoft Word 2016 makes it easy to integrate tables in documents and to modify them in various ways. In this course, you'll learn how to modify a table and perform both basic and advanced sort operations, manage a table that spans multiple pages of a document, use formulas in a table, convert text to a table and vice versa, and position tables within other page elements in Word 2016. This course is one of a series in the Skillsoft learning path that covers Microsoft Word 2016 for intermediate-level users.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about new features in Word 2016.

Creating and Formatting Tables in Word 2016

Course Number:
mo_bewo_a04_dt_enus
Lesson Objectives

Creating and Formatting Tables in Word 2016

  • start the course
  • create tables and apply quick table layouts in Word 2016
  • add content to tables in Word 2016
  • select tables and table elements in Word 2016
  • adjust column and row sizes automatically in tables in Word 2016
  • split and merge table cells in Word 2016
  • align text vertically or horizontally in table cells in Word 2016
  • change the direction of text in table cells in Word 2016
  • apply different styles to a table in Word 2016
  • distribute column widths and row heights equally in a table in Word 2016
  • display table gridlines and understand their uses in Word 2016
  • create or remove table borders in Word 2016
  • apply shading to table cells in Word 2016
  • use the Border Painter and Border Sampler tools to format table borders in Word 2016
  • create, modify, and format a table, display gridlines, and format the table's borders in Word 2016

Overview/Description
Microsoft Word 2016 provides tools that make it easy to create, format, and manipulate tables. In this course, you'll learn different methods for creating and adjusting tables, applying table styles, and formatting the content in table cells. You'll also learn how to apply shading and borders to tables in Word 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about the new interface and features in Word 2016.

Customizing Options and Using Document Views in Word 2016

Course Number:
mo_bewo_a03_dt_enus
Lesson Objectives

Customizing Options and Using Document Views in Word 2016

  • start the course
  • access and adjust the default AutoRecover settings in Word 2016
  • change the default unit of measurement used in Word 2016
  • locate and edit user information, and understand the effects of doing this, in Word 2016
  • change the default location for saving documents in Word 2016
  • set the number of recently used documents and the number of unpinned folders to display in Word 2016
  • customize the list of recently used documents in Word 2016
  • add commands to the Quick Access Toolbar and change its default position in Word 2016
  • use various methods to zoom in or out of a Word 2016 document
  • use different document views in Word 2016
  • use the ribbon to switch between different documents in Word 2016
  • work with a document that opens in Protected mode in Word 2016
  • change a range of default settings and use different document views in Word 2016

Overview/Description
Microsoft Word 2016 enables users to change a number of default settings to suit their preferences and to view documents in different ways. In this course, you'll learn how to access and change various program defaults, for example to control how Word 2016 saves and lists documents. You'll also learn how to zoom in or out of documents, change document views to suit different purposes, and navigate easily between documents in Word 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about the new interface and features in Word 2016.

Designing and Formatting Illustrations in Word 2016

Course Number:
mo_inwo_a02_dt_enus
Lesson Objectives

Designing and Formatting Illustrations in Word 2016

  • start the course
  • add shadows and reflections to pictures in Word 2016
  • apply a glow, soft edges, and 3-D formatting or rotation to an object in Word 2016
  • remove the background of an image in Word 2016
  • apply color saturation, tone, and recolor options to a picture in Word 2016
  • change image brightness and contrast, and soften or sharpen images, in Word 2016
  • apply picture styles, effects, and layouts to pictures in Word 2016
  • change an existing shape and apply shape styles and effects in Word 2016
  • modify the layout of shapes in SmartArt in Word 2016
  • apply SmartArt layouts and styles, add new shapes, and use the Text pane for SmartArt in Word 2016
  • apply chart layouts and styles, and add additional chart elements, in Word 2016
  • switch the layout of chart rows and columns, and select and edit chart data, in Word 2016
  • add and remove column formatting, and add column breaks, in Word 2016
  • select the correct pagination option when working with paragraphs in a Word 2016 document
  • insert new page and continuous section breaks in Word 2016
  • apply transparency and a picture style and layout to a picture, and add an element to a chart in Word 2016

Overview/Description
Enhance Word 2016 documents with decorative, professional looking illustrations using the Format and Design ribbons dedicated to Shapes, Pictures, Charts, Textboxes, WordArt and SmartArt. In addition, focus on compressing illustrations This course addresses more complex formatting using Word 2016. Some of these skills, for instance, section breaks and pagination options, are beneficial when working with large documents which require complex formatting. This course is one of a series in the Skillsoft learning path that covers Microsoft Word 2016 for intermediate-level users.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about new features in Word 2016.

Formatting Text in Word 2016

Course Number:
mo_bewo_a02_dt_enus
Lesson Objectives

Formatting Text in Word 2016

  • start the course
  • apply fonts and different font sizes to text, and set a default font, in Word 2016
  • apply a range of effects to text and change its case in Word 2016
  • use the Format Painter to copy existing formatting to other text in a Word 2016 document
  • alter the spacing between characters in a Word 2016 document
  • justify and align text in a Word 2016 document
  • add symbols and special characters to text in Word 2016
  • apply built-in styles to text in a Word 2016 document
  • modify an existing text style and apply character and paragraph style options in Word 2016
  • create and apply a new text style in Word 2016
  • adjust line spacing in a Word 2016 document
  • adjust paragraph spacing in a Word 2016 document
  • indent paragraphs in different ways in Word 2016
  • create a dropped cap and configure its settings in a Word 2016 document
  • remove all formatting from a document in Word 2016
  • change the formatting, style, and spacing of text in a Word 2016 document

Overview/Description
Microsoft Word 2016 provides a range of options for formatting and styling text. In this course, you'll learn how to create professional-looking documents by controlling the font and size settings, style, alignment, and spacing of both characters and paragraphs. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about the new interface and features in Word 2016.

Headers, Footers, Page Numbering, and Layout in Word 2016

Course Number:
mo_bewo_a05_dt_enus
Lesson Objectives

Headers, Footers, Page Numbering, and Layout in Word 2016

  • start the course
  • add a header or footer to a document in Word 2016
  • insert page numbers, document properties, images, or Quick Parts in a header or footer in Word 2016
  • adjust header and footer margins in Word 2016
  • include an alignment tab in a header or footer in Word 2016
  • apply a different header or footer to the first page of a document in Word 2016
  • apply different headers or footers to sections within a document in Word 2016
  • choose and apply page numbering options in Word 2016
  • insert the date and time in a Word 2016 document
  • add a page border to one or all pages in a Word 2016 document
  • adjust the page border in a Word 2016 document
  • add a blank page to a document and force a page break in Word 2016
  • insert a cover page in a Word 2016 document
  • apply predefined or custom margins and set gutter options in Word 2016
  • set the vertical alignment of a page in Word 2016 and understand how this affects orientation and section breaks
  • add a footer to all the pages in document, start numbering from the second page, and insert a cover page in Word 2016

Overview/Description
Headers and footers, as well as appropriate page layout, play an important role in making documents look professional. In this course, you'll learn about all the options for creating headers and footers, adding page numbering and the date and time, and creating custom page layouts for documents in Word 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about the new interface and features in Word 2016.

Maintaining, Protecting, and Reviewing Documents in Word 2016

Course Number:
mo_inwo_a04_dt_enus
Lesson Objectives

Maintaining, Protecting, and Reviewing Documents in Word 2016

  • start the course
  • arrange documents side by side and apply synchronous scrolling in Word 2016
  • add, modify, show or hide, and remove comments in Word 2016
  • use the Reviewing pane and list different contributors in Word 2016
  • enable or disable the tracking of changes and accept or reject changes in a document in Word 2016
  • set a password to restrict others from disabling tracking and use advanced tracking options in Word 2016
  • compare different versions of a document and combine revisions from multiple authors in Word 2016
  • allow only certain types of formatting and editing in a Word 2016 document
  • add and remove password protection for a document in Word 2016
  • protect a document by marking it as a final version in Word 2016
  • delete and recover draft versions of documents in Word 2016
  • add and edit document properties in Word 2016
  • use synchronous scrolling when viewing documents side by side, add a comment, display document contributors, and apply editing restrictions to all but a specific paragraph of a document in Word 2016

Overview/Description
Microsoft Word 2016 makes it possible for multiple contributors to collaborate in reviewing documents, as well as providing features that help protect documents from unwanted changes. In this course, you'll learn how to use comments, check document revisions, track document changes, and combine or compare revisions in different document versions. You'll also learn how to protect a document from specific types of changes, manage draft versions, and alter document properties. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for intermediate-level users.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about new features in Word 2016

Mentoring 77-725 Word 2016: Core Document Creation, Collaboration and Communication

Lesson Objectives

Mentoring 77-725 Word 2016: Core Document Creation, Collaboration and Communication

  • Create and manage documents
  • Format text, paragraphs, and sections
  • Create tables and lists
  • Create and manage references
  • Insert and format graphic elements

Overview/Description
Skillsoft Mentors are available to help students with their studies for exam 77-725 Word 2016: Core Document Creation, Collaboration and Communication. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.

Target Audience
Individuals who are studying the associated Skillsoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

References, Proofing, Mail Merges, and Forms in Word 2016

Course Number:
mo_inwo_a05_dt_enus
Lesson Objectives

References, Proofing, Mail Merges, and Forms in Word 2016

  • start the course
  • insert hyperlinks to web sites, documents, and bookmarks in Word 2016 documents
  • add and modify endnotes or footnotes in Word 2016
  • create, modify, and update a table of contents for a document in Word 2016
  • insert citations or citation placeholders in Word 2016 documents
  • use citations to add a bibliography to a Word 2016 document
  • create and work with a master document and subdocuments in Word 2016, and understand the document levels in Outline view
  • configure options for checking spelling and grammar in Word 2016
  • enable automatic correction of spelling and grammar and configure exceptions in Word 2016
  • set AutoFormat options and use the math AutoCorrect option to replace text as you type in Word 2016
  • use a wizard to perform a mail merge in Word 2016
  • manually perform a mail merge in Word 2016
  • add the Developer tab to the ribbon and identify the form controls it provides in Word 2016
  • construct a basic form and add and modify legacy form controls in Word 2016
  • insert a hyperlink to a specific heading in a document, create a table of contents, and configure an exception for the AutoFormat feature in Word 2016

Overview/Description
Microsoft Word 2016 provides sophisticated options for adding references to documents, automatically correcting documents, performing mail merges, and constructing forms. In this course, you'll learn how to add references such as hyperlinks, citations, a table of contents, and a bibliography to a document. You'll also learn how to configure automatic text correction and formatting, how to perform a mail merge, and how to construct a basic form and add controls to it in Word 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for intermediate-level users.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about new features in Word 2016.

Sharing and Collaborating on Documents in Word 2016

Course Number:
mo_inwo_a06_dt_enus
Lesson Objectives

Sharing and Collaborating on Documents in Word 2016

  • start the course
  • share a document with others via OneDrive from within Word 2016
  • share a document using e-mail from within Word 2016
  • share Word 2016 documents in the PDF and XPS formats
  • allow collaboration on a document by sharing it to the cloud from within Word 2016
  • set up a document for viewing in a web browser from within Word 2016
  • use instant messaging to send a document from within Word 2016
  • set up and register a blog account and post a document directly to the blog from within Word 2016
  • record a macro and assign it to a command button in Word 2016
  • add items to the Quick Parts Gallery and modify them in Word 2016
  • access the Quick Parts Gallery and save a selection to the AutoText quick part in Word 2016
  • use the internal search facility in Word 2016 to search for topics and images
  • download apps for Word 2016 from the Microsoft Store Online
  • share a document as a blog post and present a document online via a link in Word 2016

Overview/Description
Microsoft Word 2016 includes several useful options for sharing and collaborating on documents, and for speeding up a range of routine tasks. In this course, you'll learn many different ways of sharing Word 2016 documents. You'll also learn how to create and use macros and reusable pieces of content called Quick Parts, about the internal search facility in Word 2016, and about downloading useful apps from the Microsoft Store Online. This course is one of a series in the Skillsoft learning path that covers Microsoft Word 2016 for intermediate-level users.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about new features in Word 2016

Using Illustrations, Styles, and Themes in Word 2016

Course Number:
mo_inwo_a01_dt_enus
Lesson Objectives

Using Illustrations, Styles, and Themes in Word 2016

  • start the course
  • work with pictures in Word 2016
  • add available screenshots or screen clippings you create to documents in Word 2016
  • insert text boxes, WordArt, and charts in Word 2016 documents
  • add shapes and SmartArt to a document and use the Lock Drawing mode in Word 2016
  • control how text wraps around shapes and pictures in Word 2016
  • rearrange objects in Word 2016
  • compress and crop pictures in Word 2016
  • add text to an existing shape and use the drawing canvas to control drawing elements in Word 2016
  • use special paste options to paste a copied object as a picture or to create a link in Word 2016
  • import external objects and text using the Text from File option in Word 2016
  • apply built-in and custom styles to text in Word 2016
  • apply predefined and custom themes to documents in Word 2016
  • add a page background, apply transparency settings, and create a watermark in Word 2016
  • add a screen clipping and text boxes to a Word 2016 document, paste a link, and crop and compress a picture in Word 2016

Overview/Description
You can add several types of illustrations, such as pictures, screen clippings, shapes, charts, and WordArt, to documents in Microsoft Word 2016. You can also enhance documents by adding properly positioned text, along with attractive formatting and page backgrounds. In this course, you'll learn how to insert and work with different types of graphic and text content, how to use special paste options, and how to apply styles, themes, and backgrounds to Word 2016 documents. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for intermediate-level users.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about new features in Word 2016

Using the Navigation Pane and Creating Lists in Word 2016

Course Number:
mo_bewo_a06_dt_enus
Lesson Objectives

Using the Navigation Pane and Creating Lists in Word 2016

  • start the course
  • use the Navigation pane to create interactive outlines and to navigate to specific content in a Word 2016 document
  • find and replace specific content in a Word 2016 document
  • use the Go To feature to move to specific parts of a Word 2016 document
  • highlight all instances of specific text in a Word 2016 document
  • search an entire Word 2016 document or specific parts of it for particular text
  • replace font attributes throughout a document in Word 2016
  • create bulleted lists using predefined or custom symbols and layout in Word 2016
  • create numbered lists, using predefined or custom formats, in Word 2016
  • create and modify multilevel lists in Word 2016
  • create tabbed lists in Word 2016 and choose whether to show document markers and hidden elements
  • create a tabbed list using different tabs and set tab positions and leaders in Word 2016
  • remove, replace, or reset tabs in Word 2016
  • navigate to specific content, find and replace fonts, and create tabbed and multilevel lists in Word 2016

Overview/Description
In Microsoft Word 2016, the Navigation pane makes it easy to find and navigate to specific content. In this course, you'll learn about the options it provides for finding and replacing specific items or attributes in a document. You'll also learn how to create professional-looking bulleted, numbered, and tabbed lists in Word 2016 documents. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about the new interface and features in Word 2016.

Working with the Interface and Performing Basic Tasks in Word 2016

Course Number:
mo_bewo_a01_dt_enus
Lesson Objectives

Working with the Interface and Performing Basic Tasks in Word 2016

  • start the course
  • identify different parts of the Word 2016 interface and their functions
  • recognize new features of the Word 2016 interface
  • create new documents, open existing documents, and navigate between documents in Word 2016
  • create documents based on templates in Word 2016
  • select text in different ways and cut, copy, and paste text in Word 2016 documents
  • convert documents from previous versions of Word and understand the implications of doing this in Word 2016
  • save a document as a template or a web page in Word 2016
  • check document spelling and grammar in Word 2016
  • choose basic print settings in Word 2016
  • specify which pages to print and set document properties before printing in Word 2016
  • set document orientation and collation and duplex options before printing a document in Word 2016
  • set the paper size and adjust document margins for printing in Word 2016
  • choose settings for printing background colors and images in Word 2016
  • set the number of pages of a document to print per sheet of paper in Word 2016
  • create a basic Word 2016 document, check spelling and grammar, and apply print settings in Word 2016

Overview/Description
Available in Microsoft's newest office productivity suite, Microsoft Word 2016 makes it easy to create, manipulate, and work with documents. In this course, you'll learn how to get started with Word 2016. The course provides an overview of the Word 2016 interface and its new features, and demonstrates how to use Word 2016 to create, proofread, save, and print documents. This course is one of a series in the SkillSoft learning path that covers Microsoft Word 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Word and more experienced Word users who want to learn about the new interface and features in Word 2016.

Mentoring 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

Lesson Objectives

Mentoring 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation

  • Create and manage worksheets and workbooks
  • Manage data cells and ranges
  • Create tables
  • Perform operations with formulas and functions
  • Create charts and objects

Overview/Description
Skillsoft Mentors are available to help students with their studies for exam 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation. You can reach them by entering a Mentored Chat Room or by using the Email My Mentor service.

Target Audience
Individuals who are studying the associated Skillsoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Microsoft Excel 2016 Advanced: Accessibility, Transforming Data, and Errors

Course Number:
mo_adve_a03_dt_enus
Lesson Objectives

Microsoft Excel 2016 Advanced: Accessibility, Transforming Data, and Errors

  • start the course
  • check for accessibility issues in Microsoft Excel 2016
  • modify the tab order between workbook elements in Microsoft Excel 2016
  • prepare a workbook for internationalization in Microsoft Excel 2016
  • adjust a workbook to ensure accessibility and optimal tab order
  • use Get & Transform to pull together data from different sources in Microsoft Excel 2016
  • use the unpivot columns feature to transform data in Microsoft Excel 2016
  • run the error checker in Microsoft Excel 2016
  • trace errors in Microsoft Excel 2016
  • troubleshoot formulas using the evaluate formula tool in Microsoft Excel 2016
  • use Microsoft Excel 2016 transform features to work with data, and check it for errors

Overview/Description
Microsoft Excel 2016 makes ensuring Workbooks are accessible to all who need to use them very easy. This course covers using the accessibility checker to identify accessibility issues, altering the tab order, and making sure a workbook is modified appropriately for use in other jurisdictions. The course also covers transforming data and checking your work for errors.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Excel 2016 Advanced: Apps and What-if Analysis

Course Number:
mo_adve_a01_dt_enus
Lesson Objectives

Microsoft Excel 2016 Advanced: Apps and What-if Analysis

  • start the course
  • add an add-in for Microsoft Excel 2016 to your Microsoft account
  • insert and manage an add-in in Microsoft Excel 2016
  • use Goal Seek to find required input values in Microsoft Excel 2016
  • determine a value based on a number of variables using Solver in Microsoft Excel 2016
  • create and compare scenarios using scenario manager in Microsoft Excel 2016
  • create a summary report of scenarios in a Microsoft Excel 2016 Worksheet
  • merge scenarios in Microsoft Excel 2016
  • create a single variable data table in Microsoft Excel 2016
  • create a two-variable data table in Microsoft Excel 2016
  • use Goal Seek, Scenario Manager, and Data Tables to try different values in Microsoft Excel 2016

Overview/Description
Microsoft Excel 2016 is a very powerful data analysis tool, but its functionality can be enhanced even further using third-party applications. This course covers how to find, install, and manage apps. It also covers What-if analysis, where Excel offers a number of ways of exploring how altering inputs can affect the outcome of calculations.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms

Course Number:
mo_adve_a02_dt_enus
Lesson Objectives

Microsoft Excel 2016 Advanced: Power Pivot, Custom Formatting, Fills, and Forms

  • start the course
  • configure Power Pivot and import data into a Microsoft Excel 2016 Workbook
  • create a PivotTable using Power Pivot in Microsoft Excel 2016
  • create and populate a PivotTable using Power Pivot in Microsoft Excel 2016
  • create a custom number format in Microsoft Excel 2016
  • create a custom date and time format in Microsoft Excel 2016
  • create a custom accounting format in Microsoft Excel 2016
  • create a custom fill series in Microsoft Excel 2016
  • create custom conditional formatting rules in Microsoft Excel 2016
  • modify custom conditional formatting rules in Microsoft Excel 2016
  • apply complex filtering criteria to data in Microsoft Excel 2016
  • use custom formats, filters, and fill series when working with data in Microsoft Excel 2016

Overview/Description
Using Power Pivot in Microsoft Excel 2016, you can pull together huge amounts of data from different sources and analyze it. In this course, you will learn how to use Power Pivot, which was formerly an add-in and is now a feature of Excel 2016. This course also covers the creation of custom and conditional formatting and filters, as well as custom fills.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel; and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Excel 2016 Essentials: Charts, Tables, and Images

Course Number:
mo_beel_a05_dt_enus
Lesson Objectives

Microsoft Excel 2016 Essentials: Charts, Tables, and Images

  • start the course
  • create a table in Microsoft Excel 2016
  • modify an existing table in Microsoft Excel 2016
  • create a chart in Microsoft Excel 2016
  • modify an existing chart in Microsoft Excel 2016
  • style a chart with a quick style in Microsoft Excel 2016
  • add images to a worksheet in Microsoft Excel 2016
  • add screenshot and screen clippings to a worksheet in Microsoft Excel 2016
  • modify an image using Microsoft Excel 2016 tools
  • add headers and footers to a Microsoft Excel 2016 workbook
  • add tables and charts to a worksheet in Microsoft Excel 2016
  • add images, headers, and footers in Microsoft Excel 2016

Overview/Description
Using tables, charts, and images in Excel 2016, you can create attractive and well-organized representations of worksheet and workbook data. These elements can be easily inserted into your workbook and customized as necessary. In this course, you will learn how to effectively use and customize tables and charts in Excel 2016. You will also learn how to use headers and footers to add additional information to your work.

Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification

Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks

Course Number:
mo_beel_a01_dt_enus
Lesson Objectives

Microsoft Excel 2016 Essentials: Creating, Editing, and Saving Workbooks

  • start the course
  • create Microsoft Excel 2016 workbooks and open existing documents
  • recognize the different parts of the Microsoft Excel 2016 interface
  • add data to a Microsoft Excel 2016 worksheet
  • cut, copy, and paste data in Microsoft Excel 2016
  • delete or hide cell, row, and column data in Microsoft Excel 2016
  • create and customize worksheets in Microsoft Excel 2016
  • add properties information to a Microsoft Excel 2016 document
  • save a workbook in Microsoft Excel 2016
  • save a workbook to an online location in Microsoft Excel 2016
  • configure Excel 2016 worksheets and workbooks for printing
  • export Excel 2016 document data in different formats
  • create an Excel 2016 document, add data to it, enter property information, and save it

Overview/Description
Microsoft Excel 2016 makes it easy to create worksheets and workbooks, and to manage and manipulate data. In this course, you will learn how to cut, copy, and paste data; navigate between data cells and worksheets; and customize your Excel workspace. You will also learn about creating and opening workbooks, moving data around in Excel 2016, organizing worksheets, and saving and exporting data.

Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification

Microsoft Excel 2016 Essentials: Data Presentation Strategies

Course Number:
mo_beel_a03_dt_enus
Lesson Objectives

Microsoft Excel 2016 Essentials: Data Presentation Strategies

  • start the course
  • copy data using Auto Fill in Microsoft Excel 2016
  • fill a series using Auto Fill in Microsoft Excel 2016
  • complete data lists using Flash Fill in Microsoft Excel 2016
  • create a hyperlink in an Excel 2016 workbook
  • modify an existing hyperlink in an Excel 2016 workbook
  • apply conditional formatting using Quick Analysis in Microsoft Excel 2016
  • create custom conditional formatting rules in Microsoft Excel 2016
  • create and edit basic sparklines in Microsoft Excel 2016
  • create custom sparklines in Microsoft Excel 2016
  • use hyperlinks, conditional formatting, and sparklines to customize the look of your data in Microsoft Excel 2016

Overview/Description
Microsoft Excel 2016 gives you many options for improving the presentation of your data. In this course, you will learn about adding visual impact to your data using Sparklines, linking to different locations using hyperlinks, and creating custom formatting rules. You will learn about the many tools Excel 2016 provides for visually enhancing the appearance of your data.

Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification

Microsoft Excel 2016 Essentials: Formatting Data

Course Number:
mo_beel_a02_dt_enus
Lesson Objectives

Microsoft Excel 2016 Essentials: Formatting Data

  • start the course
  • apply formatting to different types of numerical data in Microsoft Excel 2016
  • format text data in Microsoft Excel 2016
  • create custom text and numerical formats in Microsoft Excel 2016
  • apply borders and fills to cells in Microsoft Excel 2016
  • apply cell styles to your data in Microsoft Excel 2016
  • create a custom cell style in Microsoft Excel 2016
  • use the Format Painter tool to copy formatting in Microsoft Excel 2016
  • insert and resize columns and rows in Microsoft Excel 2016
  • alter the alignment, indentation, and orientation of cell data in Microsoft Excel 2016
  • merge and split cell data in Microsoft Excel 2016
  • apply a cell style, format numbers and text, and modify the positioning of data in Microsoft Excel 2016

Overview/Description
Making your data look good is easy in Microsoft Excel 2016. You can format numbers and text, and apply styles to make your data stand out. In this course, you will learn how to create custom formatting and styles, and copy formatting from cell to cell. In addition to formatting and styling data in Excel 2016, you will learn how to position the data in your spreadsheet.

Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification

Microsoft Excel 2016 Essentials: Formulas and Functions

Course Number:
mo_beel_a04_dt_enus
Lesson Objectives

Microsoft Excel 2016 Essentials: Formulas and Functions

  • start the course
  • create basic formulas in Microsoft Excel 2016
  • recognize Microsoft Excel 2016 formula operators
  • recognize the order of operations in Microsoft Excel 2016
  • create named cell ranges in Microsoft Excel 2016
  • use named cell ranges in formulas in Microsoft Excel 2016
  • use the SUM function to calculate totals in Microsoft Excel 2016
  • calculate the AVERAGE, COUNT, MIN, and MAX of a column or row of numbers in Microsoft Excel 2016
  • use the AND, OR, and NOT functions in Microsoft Excel 2016
  • apply conditional logic using the IF function in Microsoft Excel 2016
  • handle errors using IFERROR in Microsoft Excel 2016
  • create a formula and named cell range and use functions to perform calculations in Microsoft Excel 2016

Overview/Description
Microsoft Excel 2016 allows you to perform complex calculations on your workbook data. Being able to use formulas to complete calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. In this course, you will learn about the basic concepts and terminology associated with formulas and functions. You will learn about the various ways of referring to cells and cell ranges, and how to use basic functions including logical and IF-type functions.

Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification

Microsoft Excel 2016 Intermediate: Customizing Views, Styles, and Templates

Course Number:
mo_inel_a01_dt_enus
Lesson Objectives

Microsoft Excel 2016 Intermediate: Customizing Views, Styles, and Templates

  • start the course
  • modify default display options in Excel 2016
  • select workbook view options in Excel 2016
  • select window view options in Excel 2016
  • modify the Quick Access Toolbar layout in Excel 2016
  • modify the ribbon layout in Excel 2016
  • modify default column and row settings in Excel 2016
  • create and modify custom templates in Excel 2016
  • create custom color formats in Excel 2016
  • create and modify cell styles in Excel 2016
  • create custom form fields in Excel 2016
  • configure appropriate views, layout, and visual elements in Excel 2016

Overview/Description
Making the Microsoft Excel 2016 environment look exactly the way you want it to is easy. In this course, you will learn how to configure how you want a workbook and the work area itself to appear. You will also learn how to add and customize templates and styles to really make Excel 2016 work for you.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Office 2016 Intermediate Excel: Creating Custom Visual Effects

Course Number:
mo_inel_a02_dt_enus
Lesson Objectives

Microsoft Office 2016 Intermediate Excel: Creating Custom Visual Effects

  • start the course
  • add a text box to a Microsoft Excel 2016 worksheet
  • modify the look of a text box in Microsoft Excel 2016
  • add shapes and lines to a worksheet in Microsoft Excel 2016
  • insert SmartArt into a Microsoft Excel 2016 worksheet
  • edit SmartArt you have added to a Microsoft Excel 2016 worksheet
  • add text, shapes, and SmartArt to a Microsoft Excel 2016 worksheet
  • use WordArt and images to create watermarks in Microsoft Excel 2016
  • apply a theme to a Worksheet in Microsoft Excel 2016
  • modify and save a theme in Microsoft Excel 2016
  • convert text to columns in Microsoft Excel 2016
  • apply a theme and a watermark to a Microsoft Excel 2016 worksheet

Overview/Description
A picture may paint a thousand words but Microsoft Excel 2016 makes adding both words and pictures to your workbooks very straightforward. In this course, you will learn how to insert and style text boxes, shapes, and SmartArt. You will also learn about applying and customizing themes and watermarks.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries

Course Number:
mo_inel_a04_dt_enus
Lesson Objectives

Microsoft Office 2016 Intermediate Excel: Macros and Advanced Queries

  • start the course
  • configure macro security settings in Microsoft Excel 2016
  • run a macro in Microsoft Excel 2016
  • record a simple macro in Microsoft Excel 2016
  • run a custom macro from an interface element in Microsoft Excel 2016
  • create a macro in Microsoft Excel 2016
  • use the NOW and TODAY functions in Microsoft Excel 2016
  • use the DATE function in Microsoft Excel 2016
  • use the NETWORKDAYS function in Microsoft Excel 2016
  • use TRANSPOSE to alter a worksheet in Microsoft Excel 2016
  • look up data using the VLOOKUP and HLOOKUP functions in Microsoft Excel 2016
  • look up data using the LOOKUP function in Microsoft Excel 2016
  • use the IF function with other functions in Microsoft Excel 2016
  • use SUMIFS, AVERAGEIFS, and COUNTIFS in Microsoft Excel 2016
  • perform advanced queries in Microsoft Excel 2016

Overview/Description
Using macros in Excel 2016 lets you save time when performing repetitive tasks. This course covers the options available when you are running macros, and also how to create your own custom macros. You will also learn about advanced functions that allow you to perform calculations using date and time, how to look up data, and how to perform advanced conditional queries.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts

Course Number:
mo_inel_a05_dt_enus
Lesson Objectives

Microsoft Office 2016 Intermediate Excel: PivotTables and Advanced Charts

  • start the course
  • create a PivotTable in Microsoft Excel 2016
  • modify the data in a PivotTable in Microsoft Excel 2016
  • alter the look of your PivotTable in Microsoft Excel 2016
  • filter PivotTable data with slicers in Microsoft Excel 2016
  • use recommended charts to create a PivotChart in Microsoft Excel 2016
  • use PivotTable data to create a PivotChart in Microsoft Excel 2016
  • alter the data in a PivotChart in Microsoft Excel 2016
  • add trendlines to a chart in Microsoft Excel 2016
  • create a dual axis chart in Microsoft Excel 2016
  • create a chart template from an existing chart in Microsoft Excel 2016
  • present data in PivotTables and PivotCharts

Overview/Description
In Microsoft Excel 2016, PivotTables and PivotCharts let you dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In this course, you will also learn how to use advanced chart features like trendlines and dual axis charts.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Office 2016 Intermediate Excel: Share, Review, and Collaborate

Course Number:
mo_inel_a06_dt_enus
Lesson Objectives

Microsoft Office 2016 Intermediate Excel: Share, Review, and Collaborate

  • start the course
  • sign in to Microsoft Excel 2016 and add a OneDrive service
  • share and publish your work in Microsoft Excel 2016
  • work with others on the same document in Microsoft Excel 2016
  • link to data in another Workbook in Microsoft Excel 2016
  • add and manage connections to an Access database in Microsoft Excel 2016
  • apply different levels of protection to your Microsoft Excel 2016 Workbook
  • manage multiple Workbooks in Microsoft Excel 2016
  • manage changes in a Microsoft Excel 2016 Workbook
  • add and modify comments in a Microsoft Excel 2016 workbook
  • run a spellcheck on a Microsoft 2016 Workbook
  • share and review a workbook in Microsoft Excel 2016

Overview/Description
Microsoft Excel 2016 provides a number of tools that allow you to share your work with others, and collaborate on Excel projects. With your Microsoft account, you can access services that facilitate online collaboration, and link to data in other workbooks and even databases. In this course, you will also learn about reviewing Excel documents and how to convey your thoughts on a document to others.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016

Microsoft Office 2016 Intermediate Excel: Working with Data

Course Number:
mo_inel_a03_dt_enus
Lesson Objectives

Microsoft Office 2016 Intermediate Excel: Working with Data

  • start the course
  • sort data alphabetically and numerically in Microsoft Excel 2016
  • sort data by cell or font color in Microsoft Excel 2016
  • configure a custom sort in Microsoft Excel 2016
  • create data summaries using groups in Microsoft Excel 2016
  • calculate subtotals and grand totals in Microsoft Excel 2016
  • filter data in Microsoft Excel 2016
  • refine data filters in Microsoft Excel 2016
  • create a custom filter in Microsoft Excel 2016
  • implement basic data validation in a Microsoft Excel 2016 worksheet
  • apply advanced data validation in Microsoft Excel 2016
  • search a workbook to find and replace data in Microsoft Excel 2016
  • sort, group, filter, and validate data in Microsoft Excel 2016

Overview/Description
Microsoft Excel 2016 gives you a number of options for sorting and organizing data. In this course, you will learn about basic alphabetical and numerical sorts through color sorting and custom configured sorts. The course also covers grouping, filtering, searching, and ensuring valid data is entered.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016.

Constructing and Modifying Tables and Charts in PowerPoint 2016

Course Number:
mo_bepw_a05_dt_enus
Lesson Objectives

Constructing and Modifying Tables and Charts in PowerPoint 2016

  • start the course
  • insert or draw a table and add an Excel spreadsheet to a slide in PowerPoint 2016
  • customize and apply table styles in PowerPoint 2016
  • add shading, borders, and effects to tables in PowerPoint 2016
  • split and merge cells and distribute column widths and row heights equally in tables in PowerPoint 2016
  • align text and change its direction in table cells in PowerPoint 2016
  • show or hide table gridlines and save a table as an image in PowerPoint 2016
  • insert charts of different types in slides in PowerPoint 2016
  • enter chart data and apply a quick layout to a chart in PowerPoint 2016
  • swap the row and column data in a chart in PowerPoint 2016
  • add elements to a chart and edit and format individual chart elements in PowerPoint 2016
  • apply a predefined color scheme and style to a chart in PowerPoint 2016
  • resize, copy, move, or delete charts in PowerPoint 2016
  • remove a data series and add data from a selected data source to a chart in PowerPoint 2016
  • insert and modify a chart, add and format a table, and merge and split cells in the table in PowerPoint 2016

Overview/Description
Tables and charts make some types of data much easier to present and explain, adding to the impact of a presentation. In this course, you'll learn how to add tables and different types of charts to presentation slides, and how to change their structure and appearance in Microsoft PowerPoint 2016. This course is one of a series in the Skillsoft learning path that covers Microsoft PowerPoint 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft PowerPoint and more experienced PowerPoint users who want to learn about the new interface and features in PowerPoint 2016

Creating Photo Albums, Sections, Transitions, and Animations in PowerPoint 2016

Course Number:
mo_inpw_a01_dt_enus
Lesson Objectives

Creating Photo Albums, Sections, Transitions, and Animations in PowerPoint 2016

  • start the course
  • create, organize, and format a photo album in PowerPoint 2016
  • apply a picture layout, frame shape, and theme to a photo album in PowerPoint 2016
  • create and rename sections in a PowerPoint 2016 presentation
  • expand, collapse, and remove sections in a presentation in PowerPoint 2016
  • add built-in animations of different types to a slide and customize the animations in PowerPoint 2016
  • add and customize built-in animations in PowerPoint 2016
  • modify animations and apply text effects to animations in PowerPoint 2016
  • configure an animation using the Animation pane and set animation triggers in PowerPoint 2016
  • add and modify transitions in PowerPoint 2016
  • create, format, and modify a photo album, and add an animation and a transition to a presentation in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 enables users to create and organize attractive photo albums, navigate a presentation easily using sections, and add a range of motion effects to slides. In this course, you'll learn how to add photos and captions to an album and customize their order and appearance; work with, rename, and remove sections in a presentation; and add and modify both animations and transitions in PowerPoint 2016. This course is one of a series in the Skillsoft learning path that covers Microsoft PowerPoint 2016 for intermediate-level users.

Target Audience
Users who have some familiarity with Microsoft PowerPoint and want to extend their knowledge of new and more sophisticated features in Microsoft PowerPoint 2016.

Customizing Proofing and Default Options in PowerPoint 2016

Course Number:
mo_inpw_a04_dt_enus
Lesson Objectives

Customizing Proofing and Default Options in PowerPoint 2016

  • start the course
  • set proofing options in PowerPoint 2016
  • configure the way PowerPoint 2016 checks spelling and grammar
  • launch the spell checker, use the thesaurus, perform a smart lookup, and set translation and language options in PowerPoint 2016
  • create a custom dictionary and add entries to it in PowerPoint 2016
  • enable the AutoCorrect feature and configure exceptions in PowerPoint 2016
  • configure AutoFormat and Math AutoCorrect options in PowerPoint 2016
  • configure the automatic recovery of presentations in PowerPoint 2016
  • embed fonts in a presentation in PowerPoint 2016
  • add to or modify default user information and change the default location where files are saved in PowerPoint 2016
  • set basic and advanced document properties in PowerPoint 2016
  • change the default number of recent documents listed in PowerPoint 2016
  • modify the Quick Access Toolbar in PowerPoint 2016
  • use the Touch/Mouse icon and add it to the Quick Access Toolbar in PowerPoint 2016
  • configure AutoFormat settings, modify default user information, set a document property, and modify the Quick Access Toolbar in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 includes options for customizing its default behavior, including the ways it checks and corrects text. You can also edit the default information and properties associated with presentation files. In this course, you'll learn how to set proofing and language options, configure automatic text correction, set file information and properties, and customize the Quick Access Toolbar in PowerPoint 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for intermediate-level users.

Target Audience
Users who have some familiarity with Microsoft PowerPoint and want to extend their knowledge of new and more sophisticated features in Microsoft PowerPoint 2016.

Designing Effective PowerPoint Presentations

Course Number:
mo_bppw_a01_dt_enus
Lesson Objectives

Designing Effective PowerPoint Presentations

  • start the course
  • describe how to design and present an effective PowerPoint 2016 presentation
  • identify PowerPoint 2016 design tools and presentation add-ons for speedy design
  • describe the presentation process when designing PowerPoint 2016 presentations
  • recognize the role of the presenter in imparting PowerPoint 2016 presentation content effectively
  • apply design principles that help ensure long-term retention of your message in PowerPoint 2016
  • create a clear message and establish credibility in a PowerPoint 2016 presentation
  • recognize how to deliver a message clearly and effectively in a PowerPoint 2016 presentation
  • fully engage with and persuade your audience when delivering a PowerPoint 2016 presentation
  • describe how the brain processes visual input and what this implies for effective slide design in PowerPoint 2016
  • make effective use of sound and images in PowerPoint 2016 presentations
  • use guides, alignment, and grouping to create a professional PowerPoint 2016 presentation
  • use color to increase the effectiveness of PowerPoint 2016 presentations
  • apply consistent styles to slides in PowerPoint 2016
  • identify the Gestalt principles and how visual input is received by humans
  • apply best practices for designing and delivering a PowerPoint 2016 presentation

Overview/Description
To be effective, a presentation has to capture your audience's attention and deliver a compelling message. In this course, you'll learn design principles for creating engaging presentations in PowerPoint 2016. You'll also learn how to ensure your message is clear and persuasive, and how to use sound, images, color, and styles to optimize the visual impact that a presentation has on your audience. This course is one of a series in the SkillSoft learning path that covers best practices when using PowerPoint 2016.

Target Audience
Anyone who is familiar with the PowerPoint 2016 interface and tools and want to improve their presentation design and communication skills.

Exporting Presentations and Compressing Media in PowerPoint 2016

Course Number:
mo_inpw_a06_dt_enus
Lesson Objectives

Exporting Presentations and Compressing Media in PowerPoint 2016

  • start the course
  • convert a presentation to PDF or XPS format in PowerPoint 2013
  • save a presentation as a video and adjust its properties in PowerPoint 2013
  • package a presentation for CD in PowerPoint 2013
  • edit slide content in Word and automatically update a PowerPoint 2016 presentation with the changes
  • export a presentation in an earlier PowerPoint format in PowerPoint 2013
  • export a presentation in the OpenDocument format in PowerPoint 2013
  • export a presentation as a template in PowerPoint 2013
  • export a presentation so it automatically opens as a slide show in PowerPoint 2013
  • export a set of slides as a picture presentation in PowerPoint 2013
  • export slides as image files in PowerPoint 2013
  • save a presentation in any supported file type in PowerPoint 2013
  • set default image size and quality settings for presentations in PowerPoint 2013
  • compress images in PowerPoint 2013
  • compress media files and optimize them for compatibility with other systems using PowerPoint 2013
  • save a presentation as a video, export it as a picture presentation, and crop and compress images in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 makes it easy to export presentations for a wide range of purposes. In this course, you'll learn about all the main ways and file formats in which you can export presentations. You'll also learn how to configure default image quality settings, how to compress images, and how to optimize the compatibility of a presentation with other systems. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for intermediate-level users.

Target Audience
Users who have some familiarity with Microsoft PowerPoint and want to extend their knowledge of new and more sophisticated features in Microsoft PowerPoint 2016.

Formatting Text Boxes and Working with Graphic Content in PowerPoint 2016

Course Number:
mo_bepw_a03_dt_enus
Lesson Objectives

Formatting Text Boxes and Working with Graphic Content in PowerPoint 2016

  • start the course
  • insert text boxes and apply fills to them in PowerPoint 2016
  • change the internal margins of text boxes in PowerPoint 2016
  • modify the borders of text boxes in PowerPoint 2016
  • align text boxes and their contents, wrap text, and convert text to columns in PowerPoint 2016
  • add shape effects to text boxes in PowerPoint 2016
  • specify formats for a text box and set the default format in PowerPoint 2016
  • adjust text box size and position and automatically fit text to a text box in PowerPoint 2016
  • send objects forward or back in PowerPoint 2016
  • align, group, and rotate objects in PowerPoint 2016
  • use the Selection and Visibility pane to show, hide, or manipulate objects in PowerPoint 2016
  • resize objects and reset objects to their original state in PowerPoint 2016
  • apply predefined artistic effects, picture effects, and picture layouts in PowerPoint 2016
  • apply styles and add and modify object borders in PowerPoint 2016
  • add and adjust a text box, display text in columns, rotate a picture, apply a picture style, and apply picture effects in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 provides a wide range of tools for adding text and graphic content to slides, and for arranging and altering this content to produce presentations that are professional, creative, and highly polished. In this course, you'll learn how to insert, position, resize, and format both text and graphics on PowerPoint slides. You'll also learn how to arrange and manipulate the objects on a slide, and how to apply a range of artistic effects and styles, to both text and graphic elements. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft PowerPoint and more experienced PowerPoint users who want to learn about the new interface and features in PowerPoint 2016.

Introduction to the PowerPoint 2016 Interface and Basic Tasks

Course Number:
mo_bepw_a01_dt_enus
Lesson Objectives

Introduction to the PowerPoint 2016 Interface and Basic Tasks

  • start the course
  • identify the different parts of the PowerPoint 2016 interface
  • recognize key new features in PowerPoint 2016
  • create and open presentations in PowerPoint 2016
  • create a presentation using a template in PowerPoint 2016
  • save a presentation as a template in PowerPoint 2016
  • set slide size and orientation in PowerPoint 2016
  • work with presentations from a previous version of PowerPoint in PowerPoint 2016
  • compress pictures, add tags to a presentation, and save a presentation in a required format
  • set basic print options in PowerPoint 2016
  • set a print layout and print quality, and choose to print a frame, comments, and inking in PowerPoint 2016
  • choose a printer, check printer properties, and preview a presentation before printing it in PowerPoint 2016
  • customize the status bar and use different presentation views in PowerPoint 2016
  • view the ruler, gridlines, guides, and slide notes, and zoom in or out of a presentation in PowerPoint 2016
  • switch between presentations and arrange windows in PowerPoint 2016
  • create a presentation based on a template, add presentation content, and preview and save a presentation in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 makes it easy to create professional presentations that make an impact. In this course, you'll learn about the new interface and key new features introduced in PowerPoint 2016. You'll also learn how to perform a range of basic tasks so you can get started with using PowerPoint 2016. These tasks include creating and saving presentations, setting up slides, choosing print settings, and viewing presentations in different ways. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft PowerPoint and more experienced PowerPoint users who want to learn about the new interface and features in PowerPoint 2016.

Modifying and Formatting Slides in PowerPoint 2016

Course Number:
mo_bepw_a02_dt_enus
Lesson Objectives

Modifying and Formatting Slides in PowerPoint 2016

  • start the course
  • work with slides in PowerPoint 2016
  • insert an outline from an external source in a presentation in PowerPoint 2016
  • insert saved slides in a presentation in PowerPoint 2016
  • apply and modify a theme, and hide background graphics, in PowerPoint 2016
  • work with themes in PowerPoint 2016
  • apply predefined slide layouts to slides in PowerPoint 2016
  • copy and move text, and apply special paste options, in PowerPoint 2016
  • work with lists in PowerPoint 2016
  • add and work with headers, footers, and slide numbering in PowerPoint 2016
  • indent text and set line and character spacing in PowerPoint 2016
  • set text alignment and direction, and convert text to columns, in PowerPoint 2016
  • work with text effects in PowerPoint 2016
  • convert text into SmartArt in PowerPoint 2016
  • set up a sequence of slides, apply a theme and slide layout, add a header, add and format text, and convert text to SmartArt in PowerPoint 2016

Overview/Description
In Microsoft PowerPoint 2016, you can easily add slides to a presentation, manipulate their order, and use predefined options to give the slides a particular look and feel. Then you can use a range of options to add content to slides and adjust its appearance. In this course, you'll learn how to set up a basic presentation, ordering a sequence of slides and applying a presentation theme and slide layout. You'll also learn how to add and work with slide text, including using creative text effects and converting text into SmartArt. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft PowerPoint and more experienced PowerPoint users who want to learn about the new interface and features in PowerPoint 2016.

Sharing and Protecting Presentations in PowerPoint 2016

Course Number:
mo_inpw_a05_dt_enus
Lesson Objectives

Sharing and Protecting Presentations in PowerPoint 2016

  • start the course
  • check a presentation for hidden properties and personal information before sharing it with others in PowerPoint 2016
  • attach a presentation to an e-mail from within PowerPoint 2016
  • share a presentation via e-mail from a shared location, from within PowerPoint 2016
  • using instant messaging to share a link to a presentation from within PowerPoint 2016
  • send a presentation to OneDrive for sharing with others from within PowerPoint 2016
  • share a presentation to the cloud for collaboration purposes from within PowerPoint 2016
  • use the Office Presentation Service to deliver a PowerPoint 2016 presentation online
  • save slides to a shared location, track and review changes, and choose to receive notifications of slide changes via e-mail in PowerPoint 2016
  • use an Adobe PDF version of a presentation for shared commenting and incorporate the comments in PowerPoint 2016
  • recover unsaved versions of presentations in PowerPoint 2016
  • add and remove password protection for a presentation in PowerPoint 2016
  • protect a document from changes by marking it as read-only in PowerPoint 2016
  • install the Office Mix add-in and use it to create interactive videos in PowerPoint 2016
  • access the Microsoft Store Online, download an app, and use it when creating a presentation in PowerPoint 2016
  • inspect a presentation for personal information and hidden properties, apply password protection, and share the presentation using PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 includes several new features for sharing and collaborating on presentations. In this course, you'll learn how to share a presentation via e-mail, instant messaging, OneDrive, the cloud, or a shared network location. You'll also learn how to protect a presentation from unwanted changes and how to use add-ins and apps within PowerPoint 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for intermediate-level users.

Target Audience
Users who have some familiarity with Microsoft PowerPoint and want to extend their knowledge of new and more sophisticated features in Microsoft PowerPoint 2016.

Using Hyperlinks, Actions, and Comments in PowerPoint 2016

Course Number:
mo_inpw_a02_dt_enus
Lesson Objectives

Using Hyperlinks, Actions, and Comments in PowerPoint 2016

  • start the course
  • identify types of hyperlink options in PowerPoint 2016
  • add a hyperlink to a web site on a graphic or a shape in PowerPoint 2016
  • insert a hyperlink to a new or existing presentation in a PowerPoint 2016 slide
  • insert a hyperlink to a specific heading within the current presentation in PowerPoint 2016
  • insert a hyperlink to the bookmark in PowerPoint 2016
  • modify hyperlinks in PowerPoint 2016
  • work with action links in PowerPoint 2016
  • insert, edit, and delete comments in a presentation in PowerPoint 2016
  • collaborate with others by replying to comments in real time in PowerPoint 2016
  • show, copy, and move comments in PowerPoint 2016
  • compare or combine different presentation versions in PowerPoint 2016
  • use the Pen, Highlighter, Lasso, and Convert to Shapes options to annotate a presentation in PowerPoint 2016
  • customize the Ink tools and apply formatting to annotations in PowerPoint 2016
  • remove annotations in PowerPoint 2016
  • insert hyperlinks in a presentation, add a comment, configure an Inking tool, and annotate a slide in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 makes it possible to link to different types of content and to collaborate with others in reviewing a presentation. In this course, you'll learn how to link to particular content from or within a presentation, and how to set a hyperlink to open or another action to occur when a slide object is clicked or moused over. You'll also learn how to use comments to review a presentation and collaborate with others, and how to use the Inking feature to add and format annotations on presentation slides. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for intermediate-level users.

Target Audience
Users who have some familiarity with Microsoft PowerPoint and want to extend their knowledge of new and more sophisticated features in Microsoft PowerPoint 2016.

Using Slide Masters and Slide Elements to Optimize Impact

Course Number:
mo_bppw_a02_dt_enus
Lesson Objectives

Using Slide Masters and Slide Elements to Optimize Impact

  • start the course
  • use a slide master to reflect company branding in a PowerPoint 2016 presentation
  • create a visual timeline using PowerPoint 2016
  • use charts effectively in PowerPoint 2016
  • distinguish between simple lines and connectors, and use connectors in diagrams in PowerPoint 2016
  • use Lock Drawing Mode to create shapes efficiently in PowerPoint 2016
  • use shapes to maximize impact in a PowerPoint 2016 presentation
  • use PowerPoint 2016 panning and zooming techniques to engage an audience
  • use animation tools to simulate pop-up boxes in PowerPoint 2016
  • control audience attention through timing and layout in PowerPoint 2016
  • recognize best practices for using hyperlinks in PowerPoint 2016 presentations
  • use hyperlinks to capture attention or add interactive elements to a PowerPoint 2016 presentation
  • use Presenter View and speaker notes as presentation aids in PowerPoint 2016
  • control file and image size in a PowerPoint 2016 presentation
  • apply best practices for delivering a PowerPoint 2016 presentation
  • use a slide master and slide elements to maximize the effectiveness of a PowerPoint 2016 presentation

Overview/Description
Proper use of slide masters and slide elements like timelines, charts, shapes, animations, and hyperlinks can simplify the design process and enhance a PowerPoint 2016 presentation. In this course, you'll learn how to create and customize a slide master and how to use a range of elements to add impact to presentation slides. You'll also learn best practices for delivering a presentation. This course is one of a series in the SkillSoft learning path that covers best practices when using PowerPoint 2016.

Target Audience
Anyone who is familiar with the PowerPoint 2016 interface and tools and want to improve their presentation design and communication skills.

Using Slide Show Presentation Tools in PowerPoint 2016

Course Number:
mo_inpw_a03_dt_enus
Lesson Objectives

Using Slide Show Presentation Tools in PowerPoint 2016

  • start the course
  • set a slide show type and set a slide show to loop continuously in PowerPoint 2016
  • play back audio narrations and laser pointer gestures and show media controls in a slide show in PowerPoint 2016
  • set up the Presenter view in PowerPoint 2016
  • choose which slides to show when presenting a slide show in PowerPoint 2016
  • rehearse a slide show presentation and adjust timings where necessary in PowerPoint 2016
  • create a custom slide show from particular slides within a presentation in PowerPoint 2016
  • access and edit a custom slide show and view the changes in PowerPoint 2016
  • record audio narrations, laser pointer gestures, and slide and animation timings so they can be replayed during a slide show in PowerPoint 2016
  • insert a master slide and choose elements to place in the master layout in PowerPoint 2016
  • modify and format a master slide in PowerPoint 2016
  • hide or show slides when delivering a PowerPoint 2016 presentation
  • create a custom slide show, configure the Presenter view, and add and modify a master slide in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 provides options for controlling all aspects of a slide show, ensuring you can show your audience just the right content at the right times. In this course, you'll learn how to set up and manage slide shows, including controlling slide timing and the playback of audio narration. The course also covers the use of master slides to help ensure consistency throughout a presentation, and options for hiding or showing specific slides when you're delivering a presentation. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for intermediate-level users.

Target Audience
Users who have some familiarity with Microsoft PowerPoint and want to extend their knowledge of new and more sophisticated features in Microsoft PowerPoint 2016.

Working with Graphic, Audio, and Video Content in PowerPoint 2016

Course Number:
mo_bepw_a04_dt_enus
Lesson Objectives

Working with Graphic, Audio, and Video Content in PowerPoint 2016

  • start the course
  • work with SmartArt in PowerPoint 2016
  • recognize how to apply design selections to a SmartArt graphic in PowerPoint 2016
  • change the layout of shapes in a SmartArt graphic and convert SmartArt to text or shapes in PowerPoint 2016
  • apply styles and effects to SmartArt in PowerPoint 2016
  • add locally stored or online images to slides and save objects as pictures in PowerPoint 2016
  • adjust images and apply artistic effects in PowerPoint 2016
  • crop images in different ways in PowerPoint 2016
  • add audio and video content to a presentation in PowerPoint 2016
  • correct and adjust video content, add video styles and effects, and apply styles to audio content in PowerPoint 2016
  • configure video and audio playback options in PowerPoint 2016
  • insert screen recordings, screenshots, and screen clippings in a presentation in PowerPoint 2016
  • add and format SmartArt, insert and modify a video, and add a screen recording to a presentation in PowerPoint 2016

Overview/Description
Microsoft PowerPoint 2016 provides several options for adding images and audio and video content to presentations, and for modifying this content to suit your needs. In this course, you'll learn how to work with SmartArt, how to add, adjust, and crop images, and about predefined artistic effects you can add to images. You'll also learn how to add audio, video, and screenshots or screen recordings to slides in PowerPoint 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft PowerPoint 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft PowerPoint and more experienced PowerPoint users who want to learn about the new interface and features in PowerPoint 2016.

Creating Relationships, Queries, Forms and Reports in Access 2016

Course Number:
mo_beac_a02_dt_enus
Lesson Objectives

Creating Relationships, Queries, Forms and Reports in Access 2016

  • start the course
  • outline the different types of relationships and when they should be applied in Access 2016
  • recognize the rules for creating relationships between tables in an Access 2016 database
  • choose a primary key from table fields and set relationships between tables in Access 2016
  • change form views and edit a form using Design View in Access 2016
  • apply blank forms and quick start templates to an Access 2016 database
  • modify data in a form in Access 2016
  • modify data on a form and delete form records in Access 2016
  • list the different query types available in Access 2016
  • create and run queries in Access 2016
  • create update, make table, and append queries in Access 2016
  • use the Total Column and the Query Setup features in Access 2016
  • modify and preview reports in Access 2016
  • export and import data in different file formats in Access 2016
  • set a relationship between fields, create a parameter query and report, and import data in Access 2016

Overview/Description
Queries, being the heart of Access 2016, allows searching and extraction of information from tables for analysis. In this course, you'll learn how to set primary keys, forming relationships between objects in a database. In addition, this course demonstrates how to design forms and reports for data input, and how to present information in a neat and organized format. In addition, you will learn various methods of exporting and importing data using Access 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.

Introduction to the Access 2016 Interface, Database Management, and Tables

Course Number:
mo_beac_a01_dt_enus
Lesson Objectives

Introduction to the Access 2016 Interface, Database Management, and Tables

  • start the course
  • describe what a database is and the advantages of using a database for different purposes
  • distinguish between data and information and outline key considerations when structuring a database
  • identify new features in Access 2016
  • describe the Access 2016 interface
  • distinguish between database objects such as tables, queries, forms, and reports
  • open, create, and save databases in Access 2016
  • set various database options using the Access 2016 Backstage
  • create a table using Datasheet and Design view in Access 2016
  • switch table views and modify table fields in Access 2016
  • work with table fields and data using the Design and Datasheet view in Access 2016
  • modify table field properties in Access 2016
  • apply sort options and filter types when working with table data in Access 2016
  • create and modify a database in Access 2016

Overview/Description
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.

Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.

Configuring and Managing Meetings and Notes in Outlook 2016

Course Number:
mo_beou_a06_dt_enus
Lesson Objectives

Configuring and Managing Meetings and Notes in Outlook 2016

  • start the course
  • create a meeting request in Outlook 2016
  • create a meeting request from an e-mail message in Outlook 2016
  • edit and cancel a meeting in Outlook 2016
  • accept or decline a meeting request in Outlook 2016
  • respond to a meeting request using the propose new time and e-mail response options in Outlook 2016
  • accept or decline proposed new meeting times in Outlook 2016
  • use the meeting tracking feature in Outlook 2016
  • create notes in Outlook 2016
  • forward and share notes in Outlook 2016
  • add notes to contacts in Outlook 2016
  • create and edit a meeting request and create a note in Outlook 2016

Overview/Description
The Microsoft Outlook 2016 calendar can also be used to schedule meetings in addition to creating events and appointments. In this course, you will learn how to schedule and edit meetings, accept or decline meeting requests, and manage meetings. This course also covers creating and managing notes in Outlook 2016.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Configuring Message Options in Outlook 2016

Course Number:
mo_inou_a02_dt_enus
Lesson Objectives

Configuring Message Options in Outlook 2016

  • start the course
  • insert a table in messages in Outlook 2016
  • insert SmartArt and charts in Outlook 2016 messages
  • insert shapes and screenshots in Outlook 2016
  • insert a hyperlink and Quick Parts in Outlook 2016
  • configure delivery and read receipt options and flag a message for action in Outlook 2016
  • use and configure voting buttons in Outlook 2016
  • configure e-mail importance and sensitivity levels in Outlook 2016
  • configure message delivery options when sending e-mail in Outlook 2016
  • insert a table, shape, and hyperlink and configure tracking and voting options in Outlook 2016

Overview/Description
Basic features and options in Microsoft Outlook 2016 allow you to perform common messaging tasks such as composing, sending, and receiving messages. There are however, many options that allow you to configure how messages are sent. In this course, you will learn about the different types of items that can be added or inserted in a message. This course also covers e-mail tracking and message delivery options.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Customizing and Managing Outlook 2016

Course Number:
mo_inou_a03_dt_enus
Lesson Objectives

Customizing and Managing Outlook 2016

  • start the course
  • create a new view in Outlook 2016
  • create a new view using an existing view in Outlook 2016
  • modify a custom view in Outlook 2016
  • customize the Outlook 2016 ribbon
  • add and use new folders in Outlook 2016
  • use and configure the minimize folder pane option and the ribbon display options in Outlook 2016
  • identify and use the status bar options and configure the reading pane options in Outlook 2016
  • configure general Outlook 2016 options located in backstage view
  • search for items in Outlook 2016 using Instant Search
  • search for items using the Advanced Find search tool in Outlook 2016
  • create and use search folders in Outlook 2016
  • add additional e-mail accounts in Outlook 2016
  • delegate access to an Outlook account in Outlook 2016
  • modify the view, customize the ribbon, and search for items in Outlook 2016

Overview/Description
Microsoft Outlook 2016 includes a variety of management and customization features that allow you to change the way you view and control Outlook to search for items. This course discusses options that allow you to modify, customize, and personalize Outlook. In this course, you will learn how to locate messages and items using Instant Search and Advanced Find, create search folders, add e-mail accounts, and delegate access to an account.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Formatting E-mail in Outlook 2016

Course Number:
mo_inou_a01_dt_enus
Lesson Objectives

Formatting E-mail in Outlook 2016

  • start the course
  • configure e-mail formats for e-mail messages in Outlook 2016
  • save e-mail messages in Outlook 2016
  • use various font options with e-mail messages in Outlook 2016
  • configure and use paragraph settings in e-mail messages in Outlook 2016
  • apply a bullet list, numbered list, and multilevel list to message text in Outlook 2016
  • define new bullet list, numbered lists, and multilevel list in Outlook 2016
  • apply text styles to text in an e-mail message in Outlook 2016
  • create new styles and styles sets in Outlook 2016
  • use and change theme settings in Outlook 2016
  • change e-mail background in Outlook 2016
  • use the proofing options to ensure e-mail accuracy in Outlook 2016
  • use and configure the insights and language options in Outlook 2016
  • configure e-mail message formats, and apply bullets, styles, and message themes in Outlook 2016

Overview/Description
Microsoft Outlook 2016 includes many options and features that help make messages more visually appealing. In this course, you will learn about using different message formats, as well as using and applying formatting options that can be applied to text and backgrounds of e-mail messages. This course also covers how to verify spelling and grammar in messages and use the Insights feature and language options.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016.

Getting to Know Outlook 2016

Course Number:
mo_beou_a01_dt_enus
Lesson Objectives

Getting to Know Outlook 2016

  • start the course
  • identify and use the Outlook quick access toolbar, and the mail view ribbon tabs
  • identify and navigate around the mail view in Outlook 2016
  • identify other available views in Outlook 2016
  • identify and use the new tell me feature in Outlook 2016
  • open and read e-mail messages in Outlook 2016
  • reply to e-mail messages in Outlook 2016
  • forward a message in Outlook 2016
  • create and send a new mail message in Outlook 2016
  • configure message options when composing a new message and adjust the MailTips options in Outlook 2016
  • create and use e-mail templates to compose messages in Outlook 2016
  • save an e-mail message as a draft in Outlook 2016
  • perform the steps to open, reply, and configure e-mail message options in Outlook 2016

Overview/Description
Outlook 2016 is the latest release of Microsoft's primary messaging client. It provides all of the tools necessary for managing e-mail, scheduling tasks, and communication. In this course, you will learn about the basic features and functionalities of Outlook 2016 including a look at how to navigate in Outlook 2016 and view, reply to, and forward e-mail messages. The course also addresses how to create and send new e-mail messages.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Managing Attachments, and Inserting Items and Signatures in Outlook 2016

Course Number:
mo_beou_a03_dt_enus
Lesson Objectives

Managing Attachments, and Inserting Items and Signatures in Outlook 2016

  • start the course
  • preview, open, and download attachments in an e-mail in Outlook 2016
  • attach an Outlook item to an e-mail message in Outlook 2016
  • attach files to e-mail messages in Outlook 2016
  • insert a picture in an e-mail message in Outlook 2016
  • insert a text box and configure text box options in a message in Outlook 2016
  • insert WordArt and configure WordArt options in a message in Outlook 2016
  • insert an embed object in a message
  • insert equations, symbols, and horizontal lines in e-mail messages in Outlook 2016
  • configure and use an e-mail signature in Outlook 2016
  • print e-mail messages in Outlook 2016
  • preview, open, and attach files and pictures, and insert WordArt text in Outlook 2016

Overview/Description
Microsoft Outlook 2016 effectively enables you to work with attachments, attach items, and add signatures to messages. In this course, you will learn about working with attachments, creating and adding signatures, and inserting text options. This course also covers adding symbols to e-mail messages and printing messages in Outlook 2016.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Managing Automation, Storage, and Tidying Up in Outlook 2016

Course Number:
mo_inou_a04_dt_enus
Lesson Objectives

Managing Automation, Storage, and Tidying Up in Outlook 2016

  • start the course
  • create a new rule in Outlook 2016
  • configure a custom rule in Outlook 2016
  • run a rule in Outlook 2016
  • customize and delete rules in Outlook 2016
  • configure out-of-office replies in Outlook 2016
  • configure automatic message reply rules in Outlook 2016
  • ignore specific conversations in Outlook 2016
  • clean up conversations in Outlook 2016
  • configure and use the mailbox cleanup and empty deleted items folder features in Outlook 2016
  • manage junk e-mails in Outlook 2016
  • configure the archive feature in Outlook 2016
  • create and configure data files in Outlook 2016
  • manage rules and conversations and use cleanup tools in Outlook 2016

Overview/Description
Outlook 2016 includes automated features that help users manage the large amounts of messages they receive on a regular basis. In this course, you will learn about working with automation, including creating, running, and creating Outlook rules, and configuring auto-reply rules and out-of-office replies. The course also covers managing conversations and storage, and using cleanup tools in Outlook 2016.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Managing Contacts, Tasks, and the Calendar in Outlook 2016

Course Number:
mo_inou_a05_dt_enus
Lesson Objectives

Managing Contacts, Tasks, and the Calendar in Outlook 2016

  • start the course
  • share an Outlook 2016 calendar with other users
  • share an Outlook 2016 calendar using an e-mail message
  • view and edit calendar share permissions in Outlook 2016
  • create a new Skype meeting in Outlook 2016
  • work with multiple calendars and groups in Outlook 2016
  • configure Outlook 2016 options using the options available in backstage view
  • share Outlook 2016 contacts
  • forward and open shared contacts in Outlook 2016
  • forward a task to another user in Outlook 2016
  • assign an Outlook 2016 task to someone
  • track assigned tasks and send task status reports in Outlook 2016
  • share and e-mail an Outlook calendar, create a calendar group, share a contact, and forward a task in Outlook 2016

Overview/Description
Microsoft Outlook 2016 includes collaboration and management features that allow users to manage their calendars, contacts, and tasks. In this course, you will learn about collaboration including sharing a calendar and using Skype meetings. The course also covers using and managing multiple calendars, sharing and managing contacts, and managing tasks in Outlook 2016.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Managing Conversations and E-mail in Outlook 2016

Course Number:
mo_beou_a02_dt_enus
Lesson Objectives

Managing Conversations and E-mail in Outlook 2016

  • start the course
  • arrange and view inbox items by conversations in Outlook 2016
  • access mail and other items using the people pane in Outlook 2016
  • sort and filter inbox messages using the view arrangement options and filter e-mail options in Outlook 2016
  • delete and restore e-mail messages in Outlook 2016
  • apply color categories to items and edit and create new categories in Outlook 2016
  • apply flags to items and use quick steps to manage mail in Outlook 2016
  • configure the message preview and people pane options in Outlook 2016
  • change the current view and recognize the current view options and settings
  • configure the folder pane view and navigation options
  • change reading pane views and navigation options and configure the to-do pane options
  • add or remove folders in favorites folders list in the navigation pane
  • sort, filter, delete, restore, and apply tags in Outlook 2016

Overview/Description
Microsoft Outlook 2016 allows you to effectively manage and organize your e-mail messages. In this course, you will learn how to arrange and view messages by conversation; use the People Pane to access, sort and filter e-mail; apply color categories; apply flags; and delete and restore messages. The course also covers ways to personalize your Outlook 2016 such as changing message preview settings and adjusting the reading pane and people pane.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016.

Organizing Contacts in Outlook 2016

Course Number:
mo_beou_a04_dt_enus
Lesson Objectives

Organizing Contacts in Outlook 2016

  • start the course
  • access and use the address book in Outlook 2016
  • modify the people view using available views in Outlook 2016
  • add new contacts in Outlook 2016
  • create a new contact group in Outlook 2016
  • edit contacts in Outlook 2016
  • organize contacts using folders in Outlook 2016
  • apply tags to contacts in Outlook 2016
  • export Outlook contacts to a CSV file in Outlook 2016
  • import Outlook contacts from a CSV file in Outlook 2016
  • print an address book in Outlook 2016
  • create a mail merge to create a form letter and send to multiple contacts in Outlook 2016
  • access the address book and create and edit contacts and contact groups in Outlook 2016

Overview/Description
Microsoft Outlook 2016 allows you to work with contacts in a variety of different ways. In this course, you will learn that creating contacts and contact groups allows you to save time by eliminating the need to type out an entire e-mail address each time you create a new message, assign new tasks, or create meeting requests. This course covers the variety of ways you can create contacts and contract groups, access and view contacts, and manage and print contacts.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Using the Calendar to Schedule Appointments, Events, and Tasks in Outlook 2016

Course Number:
mo_beou_a05_dt_enus
Lesson Objectives

Using the Calendar to Schedule Appointments, Events, and Tasks in Outlook 2016

  • start the course
  • access and navigate the calendar in Outlook 2016
  • create an event in Outlook 2016
  • create appointments in Outlook 2016
  • add and view additional calendars in Outlook 2016
  • change calendar appearance in Outlook 2016
  • print a calendar in Outlook 2016
  • create a new task in Outlook 2016
  • edit an existing task in Outlook 2016
  • organize tasks in Outlook 2016
  • apply and manage task views in Outlook 2016
  • print tasks in Outlook 2016
  • access the calendar, create an appointment, create and edit a task, and manage the task view in Outlook 2016

Overview/Description
The Microsoft Outlook 2016 calendar enables you to create events, appointments, and tasks, and schedule meetings. The calendar is fully integrated with the other components of Outlook 2016 and allows you to easily incorporate your contacts and e-mail functionality with the calendar. In this course, you will learn about navigating and using the calendar and creating events, appointments, and tasks. This course also covers how to add additional calendars, change the appearance of the calendar, and print the calendar and tasks.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Viewing and Configuring Outlook 2016 Backstage Options

Course Number:
mo_inou_a06_dt_enus
Lesson Objectives

Viewing and Configuring Outlook 2016 Backstage Options

  • start the course
  • view and access the Info section of the Backstage view in Outlook 2016
  • access open & export Backstage options in Outlook 2016
  • use Save As and Save Attachments Backstage options in Outlook 2016
  • view and access the Office Account settings in Backstage view in Outlook 2016
  • access and use message Info options in Backstage view in a new message in Outlook 2016
  • access mail Outlook Options in Backstage view in Outlook 2016
  • access people and tasks Outlook Options in Backstage view in Outlook 2016
  • access search Outlook Options in Backstage view in Outlook 2016
  • access advanced Outlook Options in Backstage view in Outlook 2016
  • access and configure language and add-in Outlook Options in Outlook 2016
  • recognize Trust Center Outlook Options in Backstage view in Outlook 2016
  • configure the Office background and theme, message arrival settings, and task options, and save all attachments in Outlook 2016

Overview/Description
Outlook 2016's Backstage view has a variety of options and features that allow users to customize, manage, and configure the way Outlook looks. In this course, you will learn about Outlook Backstage view options including Info, Open & Export, Save As, and Office Account. This course also covers the Info options available in the Backstage view of a new e-mail message in Outlook 2016.

Target Audience
End users; business users; IT administrators; business decision makers looking to attain competency in Microsoft Outlook 2016

Close Chat Live