Microsoft Office 2016 – Level 2 (MB5812)

Module 1: Working with Functions

• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

Module 2: Working with Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Module 3: Analyzing Data

• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Module 4: Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

Module 5: Using PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers

Module 6: Modifying the PowerPoint Environment

• Customize the User Interface
• Set PowerPoint 2016 Options

Module 7: Customizing Design Templates

• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master

Module 8: Adding SmartArt and Math Equations to a Presentation

• Create SmartArt
• Modify SmartArt
• Write Math Equations

Module 9: Working with Media and Animations

• Add Audio to a Presentation
• Add Video to a Presentation
• Customize Animations and Transitions

Module 10: Collaborating on a Presentation

• Review a Presentation
• Store and Share Presentations on the Web

Module 11: Customizing a Slide Show

• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation

Module 12: Securing and Distributing a Presentation

• Secure a Presentation
• Broadcast a Slide Show
• Create a Video or a CD

Module 13: Organizing Content Using Tables and Charts

• Sort Table Data
• Control Cell Layout
• Perform Calculations in a Table
• Create a Chart
• Add an Excel Table to a Word Document (Optional)

Module 14: Customizing Formats Using Styles and Themes

• Create and Modify Text Styles
• Create Custom List or Table Styles
• Apply Document Themes

Module 15: Inserting Content Using Quick Parts

• Insert Building Blocks
• Create and Modify Building Blocks
• Insert Fields Using Quick Parts

Module 16: Using Templates to Automate Document Formatting

• Create a Document Using a Template
• Create and Modify a Template
• Manage Templates with the Template Organizer

Module 17: Controlling the Flow of a Document

• Control Paragraph Flow
• Insert Section Breaks
• Insert Columns
• Link Text Boxes to Control Text Flow

Module 18: Simplifying and Managing Long Documents

• Insert Blank and Cover Pages
• Insert an Index
• Insert a Table of Contents
• Insert an Ancillary Table
• Manage Outlines
• Create a Master Document

Module 19: Using Mail Merge to Create Letters, Envelopes, and Labels

• The Mail Merge Feature
• Merge Envelopes and Labels

Module 20: Modifying Messages and Setting Global Options

• Insert Advanced Characters and Objects
• Modify Message Settings and Options
• Configure Global Outlook Options
• Customize the Outlook Interface

Module 21: Organizing, Searching, and Managing Messages

• Group and Sort Messages
• Filter and Manage Messages
• Search Outlook Items

Module 22: Managing Your Mailbox

• Use the Junk E-Mail Filter to Manage Messages
• Manage Your Mailbox

Module 23: Automating Message Management

• Use Automatic Replies
• Use the Rules Wizard to Organize Messages
• Create and Use Quick Steps

Module 24: Working with Calendar Settings

• Set Advanced Calendar Options
• Create and Manage Additional Calendars
• Manage Meeting Responses

Module 25: Managing Contacts

• Import and Export Contacts
• Use Electronic Business Cards
• Forward Contacts

Module 26: Managing Activities by Using Tasks

• Assign and Manage Tasks

Module 27: Sharing Workspaces with Others

• Delegate Access to Outlook Folders
• Share Your Calendar
• Share Your Contacts

Module 28: Managing Outlook Data Files

• Use Archiving to Manage Mailbox Size
• Back Up Outlook Items
• Change Data File Settings