Microsoft Office 2019/365 – Level 2 (MB5925)

Module 1: Excel - Working with Functions

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

Module 2: Excel - Working with Lists

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

Module 3: Excel - Analyzing Data

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

Module 4: Excel - Visualizing Data with Charts

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

Module 5: Excel - Using PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data

Module 6: Power Point - Customizing Design Templates

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

Module 7: Power Point - Adding Tables

• Create a Table
• Format a Table
• Insert a Table from Other Microsoft Office Applications

Module 8: Power Point - Adding Charts

• Create a Chart
• Format a Chart
• Insert a Chart from Microsoft Excel

Module 9: Power Point - Working with Media

• Add Audio to a Presentation
• Add Video to a Presentation
• Add a Screen Recording

Module 10: Power Point - Building Advanced Transitions and Animations

• Use the Morph Transition
• Customize Animations

Module 11: Power Point - Collaborating on a Presentation

• Review a Presentation
• Co-author a Presentation

Module 12: Power Point - Customizing Presentation Delivery

• Enhance a Live Presentation
• Record a Presentation
• Set Up a Slide Show

Module 13: Power Point - Modifying Presentation Navigation

• Divide a Presentation into Sections
• Add Links
• Create a Custom Slide Show

Module 14: Power Point - Securing and Distributing a Presentation

• Secure a Presentation
• Create a Video or a CD

Module 15: Word - 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

Module 16: Word - Customizing Formats Using Styles and Themes

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

Module 17: Word - Inserting Content Using Quick Parts

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

Module 18: Word - Using Templates to Automate Document Formatting

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

Module 19: Word - Controlling the Flow of a Document

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

Module 20: Word - 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 21: Word - Using Mail Merge to Create Letters, Envelopes, and Labels

• Use Mail Merge
• Merge Data for Envelopes and Labels

Module 22: Outlook - Modifying Message Properties and Customizing Outlook

• Insert Hyperlinks and Symbols
• Modify Message Properties
• Add Email Accounts to Outlook
• Customize Outlook Options

Module 23: Outlook - Organizing, Searching, and Managing Messages

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

Module 24: Outlook - Managing Your Mailbox

• Manage Junk Email Options
• Manage Your Mailbox Size

Module 25: Outlook - Automating Message Management

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

Module 26: Outlook - Working with Calendar Settings

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

Module 27: Outlook - Managing Contacts

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

Module 28: Outlook - Sharing Outlook Items

• Assign and Manage Tasks
• Share Your Calendar
• Share Your Contacts

Module 29: Outlook - Managing Outlook Data Files

• Use Archiving to Manage Mailbox Size
• Work with Outlook Data Files