logo

Microsoft Office – Level 2 (MB5925)

This Microsoft Office 2019/365 course bundle covers the intermediate usage of Microsoft Office 2019 and 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 Office 2019/365 suite of tools.

Microsoft

A preferential rate (-15%) applies to the regular cost for non-profit organizations, as well as the government sector. In addition, you can benefit from additional advantages through a corporate agreement when you need to train several people or teams in your company. Contact us for details.

Public class

Duration: 
4 days / 28 hours

Private class

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

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

Contact us for more information on pricing::

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

130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3
www.eccentrix.ca