Microsoft 365 Apps – Level 2 (MB5925)

This Microsoft 355 Apps course bundle covers the intermediate usage of Microsoft 365 products, such as Excel, PowerPoint, Word, and Outlook. It provides knowledge on the key topics for users that already use the products and that are interested in learning more in depth the Microsoft 365 Apps suite of tools.

Module 1: 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: 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: Excel - Power Point - Using PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data

Module 1: Customizing Design Templates

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

Module 2: Adding Tables

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

Module 3: Adding Charts

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

Module 4: Working with Media

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

Module 5: Building Advanced Transitions and Animations

• Use the Morph Transition
• Customize Animations

Module 6: Collaborating on a Presentation

• Review a Presentation
• Co-author a Presentation

Module 7: Customizing Presentation Delivery

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

Module 8: Modifying Presentation Navigation

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

Module 9: Securing and Distributing a Presentation

• Secure a Presentation
• Create a Video or a CD

Module 1: 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 2: Customizing Formats Using Styles and Themes

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

Module 3: Inserting Content Using Quick Parts

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

Module 4: Using Templates to Automate Document Formatting

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

Module 5: Controlling the Flow of a Document

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

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

• Use Mail Merge
• Merge Data for Envelopes and Labels

Module 1: Modifying Message Properties and Customizing Outlook

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

Module 2: Organizing, Searching, and Managing Messages

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

Module 3: Managing Your Mailbox

• Manage Junk Email Options
• Manage Your Mailbox Size

Module 4: Automating Message Management

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

Module 5: Working with Calendar Settings

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

Module 6: Managing Contacts

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

Module 7: Sharing Outlook Items

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

Module 8: Managing Outlook Data Files

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