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.

This four-day training is composed of four parts:

Microsoft 365 Excel: Part 2 (ME55142)

This course builds upon the foundational knowledge presented in the Microsoft 365 Excel: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Microsoft 365 PowerPoint: Part 2 (MP5614)

Microsoft PowerPoint provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time.

Microsoft 365 Word: Part 2 (MW55415)

Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.

Microsoft 365 Outlook: Part 2 (MO55194)

This course builds upon the foundational knowledge presented in the Microsoft 365 Outlook: Part 1 course and will help you customize a communication system well-suited to your work style.

You can purchase an individual part of this certification track - contact us for the details.

Public class

4 days / 28 hours

Private class

Virtual classroom
Minimum no. of participants: 6
4 days / 28 hours
Price on request
English or French
Training plan: 

Microsoft 365 Excel: Part 2 (ME55142)

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

Microsoft 365 PowerPoint: Part 2 (MP5614)

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

Microsoft 365 Word: Part 2 (MW55413)

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

Microsoft 365 Outlook: Part 2 (MO55194)

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
  • Course material accessible in electronic format
  • Certificate of attendance (on request)

Contact us for more information on pricing::

Office: 1-888-718-9732
E-mail: info@eccentrix.ca

130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3