microsoft partner logo color
8388  Reviews star_rate star_rate star_rate star_rate star_half

Advanced Microsoft 365 Productivity

This Advanced Microsoft 365 training course teaches attendees more sophisticated techniques to take their Microsoft Teams, PowerPoint, Word, Excel, and Outlook productivity to the next level....

Read More
Duration 2.5 days
Course Code OFC-126
Available Formats Classroom

Overview

This Advanced Microsoft 365 training course teaches attendees more sophisticated techniques to take their Microsoft Teams, PowerPoint, Word, Excel, and Outlook productivity to the next level.

Ascendient Learning welcomes the opportunity to tailor the topics and duration of this class to include only the Microsoft 365 applications and features of interest to your group.

Skills Gained

Attendees learn how to leverage the advanced features of Microsoft 365's components for:

  • Understand MS 365 applications and advantages
  • Become a Teams Advanced User
  • Use the Advanced Features in PowerPoint 365
  • Use the Advanced Features in Word 365
  • Use the Advanced Features in Excel 365
  • Use the Advanced Features in Outlook 365

Prerequisites

Attendees must have taken Ascendient Learning's Microsoft 365 Productivity course or the equivalent experience with Teams, PowerPoint, Word, Excel, and Outlook.

Course Details

Training Materials

All attendees receive quick reference guides on all applications taught.

Software Requirements

  • A full installation of Microsoft 365 and Microsoft Teams
  • Related lab files that Ascendient Learning will provide
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.

Outline

  • Introduction
  • Advanced Microsoft Teams
    • Becoming a Teams Advanced User
    • Using Hidden Chat Features
    • Adding in More Chat Features
    • Taking Teams and Channels to the Next Level
    • File Management on Teams
    • Adding in More Channel Features
    • Knowing when to use SharePoint on a Teams Site
  • Advanced PowerPoint
    • Using Master Views
    • Best Ways to Format Quickly
    • Importing Slides from Another Presentation
    • Working with Pictures and Graphics
    • Working with Sound and Video
    • Using Transitions and Animations Effectively
  • Advanced Word
    • Taking Styles to the Next Level
    • Best Ways to Format Quickly
    • Using Design Templates
    • Using Bookmarks
    • Creating Hyperlinks
    • Working with Long Documents
  • Advanced Excel
    • Using Multiple Worksheets Effectively
    • Advanced Functions (IF, XLOOKUP, SUMIFS, IFERROR)
    • Using Pivot Tables and Pivot Charts
    • Automating Actions with Power Query
    • Automating Actions with Macros
  • Advanced Outlook
    • Organizing Emails by using colors and flags
    • Using Rules
    • Using Quick Steps
    • Using Calendar Effectively
    • Using Contacts Effectively
    • Using Tasks Effectively
  • Conclusion

Schedule

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

I like their training. A lot of material covered. The labs are very good. l learned a lot.

Courseware was effective but would like to have some PDF material on BPML and XPATH

Class was easy to sign up for and ExitCertified provided very good communication

Great company -- easy to sign up and very organized. Loved my teacher and class overall.

The instructor really took his time and made sure I was able to understand the concepts.