Microsoft 365 Training - Cayman Islands

Managing Microsoft Teams MS700 Course Outline

Module 1: Explore Microsoft Teams

• Introduction
• Explore Capabilities in Microsoft Teams
• Explore Microsoft Teams Integration with Microsoft 365
• Explore Microsoft Teams Integration with Microsoft Power Platform
• Illustrate Microsoft Teams Architecture
• Describe Microsoft Teams with Microsoft 365 Groups
• Describe Microsoft Teams with SharePoint and OneDrive
• Describe Microsoft Teams with Exchange
• Understand Microsoft Teams Certified Solutions

Module 2: Plan and Deploy Microsoft Teams

• Introduction
• Designate Teams Admin Roles
• Understand Teams Management Tools
• Plan for Teams Rollout
• Plan for Teams Adoption
• Plan for Teams Licensing
• Deploy Microsoft Teams Clients

Module 3: Implement Lifecycle Management and Governance for Microsoft Teams

• Introduction
• Plan for Lifecycle Management
• Plan for Teams Governance
• Manage Microsoft 365 Groups Creation
• Configure Microsoft 365 Groups Expiration Policy
• Configure Microsoft 365 Groups Naming Policy
• Plan Policy Assignment for Users and Groups
• Create and Manage Policy Packages
• Manage Teams Preview Features Using Teams Update Policies
• Create and Manage Teams Templates and Template Policies

Module 4: Monitor Your Microsoft Teams Environment

• Introduction
• Monitor Microsoft Teams Usage Reports
• Monitor Microsoft 365 Usage Reports
• Interpret Microsoft Adoption Score
• Manage User Access with Azure Active Directory Access Reviews
• Monitor the Microsoft 365 Network Connectivity Dashboard
• Manage Teams Notifications and Alerts
• Manage Feedback Policies

Module 5: Manage Access for External Users

• Introduction
• Understand Features in Azure Active Directory
• Work with External Users in Microsoft Teams
• Manage Access for External Users
• Manage External Collaboration in Microsoft 365
• Manage External Access in Microsoft Teams
• Manage Guest Access in Microsoft Teams
• Manage File Sharing in SharePoint and OneDrive

Module 6: Implement Security for Microsoft Teams

• Introduction
• Configure Conditional Access and Multifactor Authentication for Microsoft Teams
• Configure Safe Attachments for Microsoft Teams
• Configure Safe Links for Microsoft Teams
• Examine the Defender for Cloud Apps
• Monitor Security Reports for Microsoft Teams
• Plan and Configure Enhanced Encryption Policies

Module 7: Implement Compliance for Microsoft Teams

• Introduction
• Create and Manage Sensitivity Labels
• Create and Manage Retention Policies
• Create and Manage Data Loss Prevention Policies
• Deploy Communication Compliance
• Enable Scoped Directory Search
• Create Information Barrier Policy
• Create Security and Compliance Alerts for Microsoft Teams

Module 8: Plan and Configure Network Settings for Microsoft Teams

• Introduction
• Examine Network Requirements for Microsoft Teams
• Plan for Network Deployment Using Network Planner
• Configure Network Ports and Protocols for Microsoft Teams
• Implement Quality of Service
• Configure Reporting Labels for Location-Enhanced Call Analytics Reports
• Configure Tenant Data for Call Quality Dashboard Reports
• Assess Network Readiness
• Manage Network Topology

Module 9: Create and Manage Teams

• Introduction
• Create Teams
• Create a Team from Existing Resources
• Plan and Create Org-Wide Teams
• Manage Teams
• Manage Users in a Team
• Configure Dynamic Membership
• Archive, Restore, and Delete a Team

Module 10: Manage Collaboration Experiences for Chat and Channels

• Introduction
• Create and Manage Channels in a Team
• Create and Manage Teams Policies for Channels
• Configure Teams Settings
• Create and Manage Messaging Policies
• Manage Channel Moderation
• Manage Access to Channels

Module 11: Manage Apps for Microsoft Teams

• Introduction
• Explore Apps in Microsoft Teams
• Describe Admin Settings for Teams Apps
• Manage Access to Teams Apps at the Organisation Level
• Create and Manage App Permission Policies
• Create and Manage App Setup Policies
• Manage Permissions and Consent for Teams Apps
• Plan and Configure Connectors
• Manage Custom Apps Uploads
• Publish Custom Apps to Microsoft Teams
• Manage Purchasing of Apps in the Microsoft Teams App Store
• Customise the Organisation's App Store
• Customise the Branded Experience of an App

Module 12: Introduction to Teams Meetings and Calling

• Introduction
• Overview of Teams Meetings and Events
• Overview of Teams Phone
• Overview of Auto Attendants and Call Queues
• Overview of Teams Devices

Module 13: Manage Meetings and Events Experiences

• Introduction
• Explore Meetings and Events in Microsoft Teams
• Configure Meeting Settings
• Create and Manage Meeting Policies
• Configure Audio Conferencing
• Create and Manage Meeting Templates and Template Policies
• Create and Manage Meetings Customisation Policies
• Configure Live Events Settings
• Create and Manage Live Events Policies
• Examine Live Events Across Microsoft 365

Module 14: Plan for Microsoft Teams Rooms and Surface Hub

• Introduction
• License Requirements for Microsoft Teams Rooms and Shared Devices
• Differences Between Microsoft Teams Rooms on Android and Windows
• Understand Microsoft Teams Rooms on Surface Hub 2S
• Plan Teams Room Accessories, Components, and Peripherals
• Understand Teams Rooms Management Options

Module 15: Configure, Deploy, and Manage Teams Devices

• Introduction
• Manage Microsoft Teams Phones
• Manage Microsoft Teams Room Systems
• Microsoft Teams Rooms Management Options
• Manage Surface Hub 2S Devices
• Configure Microsoft Teams SIP Gateway
• Manage Microsoft Teams Displays
• Remote Provisioning and Sign-In for Teams Phones
• Update Microsoft Teams Devices Remotely
• Manage Microsoft Teams Device Tags

Module 16: Plan for Teams Phone

• Introduction
• Plan to Deploy Teams Phone
• Plan for Teams Phone PSTN Connectivity
• Determine License Requirements
• Plan for Teams Phone Devices
• Plan and Design Teams Phone Features
• Plan for Voicemail

Module 17: Configure and Deploy Teams Phone

• Introduction
• Configure Emergency Calling for Teams Calling Plans
• Manage and Configure Microsoft PSTN Numbers
• Configure Operator Connect and Teams Phone Mobile
• Configure Teams Phone Policies
• Create and Manage Teams Policies
• Configure Audio Conferencing

Module 18: Configure and Manage Voice Users

• Introduction
• Enable Users for Teams Phone
• Enable Additional Calling Features for Teams Phone
• Enable Users for Teams Phone Mobile

Module 19: Configure Auto Attendants and Call Queues

• Introduction
• Design Call Flows for Auto Attendants and Call Queues
• Configure Auto Attendants and Call Queues
• Deploy a Channel-Based Call Queue
• Configure Resource Accounts
• Configure Microsoft 365 Groups for Voicemail
• Interpret Call Queue Conference Modes
• Interpret Call Queue Routing Methods
• Configure Holidays for Auto Attendants and Call Queues
• Configure Custom Music on Hold

Module 20: Troubleshoot Audio, Video, and Client Issues

• Introduction
• Troubleshoot Teams
• Collect and Identify Logs
• Clear Microsoft Teams Client Cache
• Identify Issues with Call Analytics
• Identify Issues with Call Quality Dashboard
• Use Power BI to Analyse Call Quality Dashboard Data
• Identify Issues with the Direct Routing Health Dashboard

Microsoft 365 Messaging MS203 Course Outline

Module 1: Manage Mail Flow

• Introduction
• Explore Mail Flow in Microsoft Exchange
• Manage Mail Flow in Exchange Server Deployments
• Manage Mail Flow in Exchange Online Deployments
• Manage Mail Flow in Hybrid Exchange Deployments
• Configure Message Transport Options
• Configure SMTP Domains
• Configure Connectors

Module 2: Troubleshoot Mail Flow

• Introduction
• Troubleshoot SMTP Mail Flow
• Troubleshoot Shared Namespace Environments
• Troubleshoot Transport Layer Security Encryption Issues
• Troubleshoot Network-Based Issues
• Monitor Exchange Online with Microsoft Service Health
• Troubleshoot with Alert Policies in Exchange Online

Module 3: Manage Mail Flow Rules

• Introduction
• Explore Mail Flow Rules
• Examine How Mail Flow Rules Work
• Configure Mail Flow Rules

Module 4: Plan for Message Security

• Introduction
• Explore Exchange Online Protection
• Plan Message Routing for Exchange Online Protection
• Examine Message Hygiene Monitoring and Reporting
• Examine Microsoft Purview Message Encryption

Module 5: Manage Anti-Malware and Anti-Spam Policies

• Introduction
• Examine Message Headers and Spam Confidence Levels
• Examine Anti-Spam and Anti-Malware Protection
• Manage Anti-Spam Protection
• Manage Anti-Malware Protection
• Examine Advanced Anti-Spam Features
• Manage Spoofing Protection
• Manage Phishing Protection
• Configure Transport Rules

Module 6: Explore Threat Protection in Microsoft 365 Defender

• Introduction
• Examine Threat Protection in Microsoft 365 Defender
• Explore Using Configuration Analyser to Improve Security Policies
• Examine How Safe Attachments Protect Against Malicious Attachments
• Examine How Safe Links Protects Against Malicious Urls
• Manage Spoof Intelligence
• Manage Anti-Phishing Policies
• Manage the Tenant Allow/Block List in Microsoft 365 Defender
• Examine Attack simulation in Microsoft 365 Defender

Module 7: Explore Messaging Compliance in Microsoft 365

• Introduction
• Examine Message Policy and Compliance
• Explore the Microsoft 365 Permission Model
• Configure Retention Policies
• Run a Message Trace
• Explore Sensitivity Labels
• Manage Inactive Mailboxes

Module 8: Explore Messaging Compliance in Exchange  

• Introduction
• Examine In-Place and Litigation Holds
• Configure Messaging Records Management
• Analyse Message Tracking

Module 9: Manage Exchange Online archiving and auditing

• Introduction
• Plan and Implement in-Place Archiving
• Explore Journaling in Exchange
• Manage Administrator and Mailbox Auditing

Module 10: Manage Content Search

• Introduction
• Design Content Searches
• Manage Content Searches
• Manage eDiscovery Cases

Module 11: Manage Authentication for Messaging

• Introduction
• Examine Password Policy Options
• Explore Self-Service Password Management
• Implement Multifactor Authentication for Exchange
• Plan Password Policies
• Explore Modern Authentication
• Configure Conditional Access Policies

Module 12: Configure Organisational Settings

• Introduction
• Configure Workload Policies and Throttling
• Configure Quota Configurations
• Deploy Microsoft 365 Add-Ins

Module 13: Configure Organisational Sharing

• Introduction
• Examine Exchange Federated Delegation Features
• Examine Exchange Federation Sharing Components
• Plan for Federation Trusts and Certificates
• Implement Organisation Relationships
• Implement Sharing Policies

Module 14: Manage Administrator roles

• Introduction
• Explore Role-Based Access Control
• Examine Management Role Groups
• Examine Built-In Management Role Groups
• Implement Admin Roles for Management Role Assignments
• Troubleshoot Admin Roles
• Explore Privileged Identity Management
• Manage Role Groups in Exchange Online

Module 15: Manage user Roles

• Introduction
• Implement User Roles for Role Assignment Policies
• Implement Management Role Assignment Policies
• Create New Roles, Role Assignments, and Scopes

Module 16: Analyse Role-Based Permissions

• Introduction
• Explore the Use of Split Permissions
• Explore the Use of Multiple-Forest Permissions
• Explore the Differences in Permissions

Module 17: Explore the Different Types of Exchange Recipients

• Introduction
• Explore Recipient Types
• Explore Resource Mailboxes
• Explore Shared Mailboxes
• Explore Linked Mailboxes
• Explore Groups
• Explore Public Folders

Module 18: Create and Manage Exchange Recipients

• Introduction
• Manage Mailbox Settings
• Manage Resource Mailboxes
• Manage Shared Mailboxes
• Create and Manage Mail Contacts and Mail Users
• Manage Permissions for Recipients
• Create and Manage Groups
• Create and Manage Public Folders

Module 19: Manage Email Addresses, Lists, and Resources

• Introduction
• Explore Address Lists
• Create and Manage Address Lists
• Examine Address Book Policies
• Configure Offline Address Books
• Examine Email Address Policies

Module 20: Explore Exchange Hybrid Deployment Requirements

• Introduction
• Examine the Connection Options for Exchange to Microsoft 365
• Explore the Components of a Hybrid Deployment
• Explore Azure Active Directory Connect
• Examine the Microsoft 365 Identity Options for a hybrid Exchange Deployment
• Compare Exchange Delegated Federation and Open Authentication

Module 21: Plan and Configure a Hybrid Deployment Using the Hybrid Configuration Wizard

• Introduction
• Plan for Exchange hybrid configuration
• Examine Organisation Configuration Transfer
• Examine Exchange Modern Hybrid and the Hybrid Agent
• Review Mail Flow Options for a hybrid Deployment
• Prepare to Run the Hybrid Configuration Wizard
• Examine Hybrid deployment Best Practices

Module 22: Plan Mailbox Migrations

• Introduction
• Explore Migration Options to Exchange Online
• Determine which Migration Option to Use
• Update DNS During a Microsoft 365 Migration

Module 23: Run Mailbox Migrations

• Introduction
• Plan an IMAP Migration
• Run an IMAP Migration
• Move Mailboxes using an IMAP Migration
• Plan a Cross-Tenant Migration
• Prepare Source Objects for a Cross-Tenant Migration

Module 24: Troubleshoot Hybrid Deployments

• Introduction
• Troubleshoot Directory Synchronisation
• Troubleshoot Pass-Through Authentication and Single sign-on
• Troubleshoot Transport with Exchange Online
• Troubleshoot Client Access in Coexistence
• Troubleshoot the Mailbox Replication Service

Microsoft Excel Associate MO200​ Course Outline

Module 1: Manage worksheets and workbooks

• Import Data into Workbooks
  • Import Data from .txt files
  • Import Data from .csv files
• Navigate within Workbooks
  • Search for Data within a Workbook
  • Navigate to Named Cells, Ranges, or Workbook Elements
  • Insert and Remove Hyperlinks
• Format Worksheets and Workbooks
  • Modify Page Setup
  • Adjust Row Height and Column Width
  • Customise Headers and Footers
• Customise Options and Views
  • Customise the Quick Access Toolbar
  • Display and Modify Workbook Content in Different Views
  • Freeze Worksheet Rows and Columns
  • Change Window Views
  • Modify Basic Workbook Properties
  • Display Formulas
• Configure Content for Collaboration
  • Set a Print Area
  • Save Workbooks in Alternative File Formats
  • Configure Print Settings
  • Inspect Workbooks for Issues

Module 2: Manage Data Cells and Ranges

• Manipulate Data in Worksheets
  • Paste Data by Using Special Paste Options
  • Fill Cells by Using Auto Fill
  • Insert and Delete Multiple Columns or Rows
  • Insert and Delete Cells
• Format Cells and Ranges
  • Merge and Unmerge Cells
  • Modify Cell Alignment, Orientation, and Indentation
  • Format Cells by Using Format Painter
  • Wrap Text Within Cells
  • Apply Number Formats
  • Apply Cell Formats from the Format Cells Dialog Box
  • Apply Cell Styles
  • Clear Cell Formatting
• Define and Reference Named Ranges
  • Define a Named Range
  • Name a Table
• Summarise Data Visually
  • Insert Sparklines
  • Apply Built-in Conditional Formatting
  • Remove Conditional Formatting

Module 3: Manage Tables and Table Data

• Create and Format Tables
  • Create Excel Tables from Cell Ranges
  • Apply Table Styles
  • Convert Tables to Cell Ranges
• Modify Tables
  • Add or Remove Table Rows and Columns
  • Configure Table Style Options
  • Insert and Configure Total Rows
• Filter and Sort Table Data
  • Filter Records
  • Sort Data by Multiple Columns

Module 4: Perform Operations by Using Formulas and Functions

• Insert References
  • Insert Relative, Absolute, and Mixed References
  • Reference Named Ranges and Named Tables in Formulas
• Calculate and Transform Datas
  • Perform Calculations by Using the AVERAGE(), MAX(), MIN(), and SUM() functions
  • Count Cells by Using the COUNT(), COUNTA(), and COUNTBLANK() Functions
  • Perform Conditional Operations by Using The IF() Function
• Format and Modify Text
  • Format Text by Using RIGHT(), LEFT(), and MID() Functions
  • Format Text by Using UPPER(), LOWER(), and LEN() Functions
  • Format Text by Using the CONCAT() and TEXTJOIN() Functions

Module 5: Manage Charts

• Create Charts
  • Create Charts
  • Create Chart Sheets
• Modify Charts
  • Add Data Series to Charts
  • Switch Between Rows and Columns in Source Data
  • Add and Modify Chart Elements
• Format Charts
  • Apply Chart Layouts
  • Apply Chart Styles
  • Add Alternative Text to Charts for Accessibility

Microsoft Word MO100 Certification Course Outline

Module 1: Manage Documents

• Navigate within Documents
  • Search for Text
  • Link to Locations within Documents
  • Move to Specific Locations and Objects in Documents 
  • Show and Hide Formatting Symbols and Hidden Text
• Format Documents
  • Set Up Document Pages
  • Apply Style Sets
  • Insert and Modify Headers and Footer
  • Configure Page Background Elements
• Save and Share Documents
  • Save Documents in Alternative File Formats
  • Modify Basic Document Properties
  • Modify Print Settings
  • Share Documents Electronically
• Inspect Documents for Issues
  • Locate and Remove Hidden Properties and Personal Information
  • Locate and Correct Accessibility Issues
  • Locate and Correct Compatibility Issues

Module 2: Insert and Format Text, Paragraphs, and Sections

• Insert Text and Paragraphs
  • Find and Replace Text
  • Insert Symbols and Special Characters
• Format Text and Paragraphs
  • Apply Text Effects
  • Apply Formatting by Using Format Painter
  • Set Line and Paragraph Spacing and Indentation
  • Apply Built-In Styles to Text
  • Clear Formatting
• Create and Configure Document Sections
  • Format Text in Multiple Columns
  • Insert Page, Section, and Column Breaks
  • Change Page Setup Options for a Section

Module 3: Manage Tables and Lists

• Create Tables
  • Convert Text to Tables
  • Convert Tables to Text
  • Create Tables by Specifying Rows and Columns
• Modify Tables
  • Sort Table Data
  • Configure Cell Margins and Spacing
  • Merge and Split Cells
  • Resize Tables, Rows, and Columns
  • Split Tables
  • Configure a Repeating Row Header
• Create and Modify Lists
  • Format Paragraphs as Numbered and Bulleted Lists
  • Change Bullet Characters and Number Formats
  • Define Custom Bullet Characters and Number Formats
  • Increase and Decrease List Levels
  • Restart and Continue List Numbering
  • Set Starting Number Values

Module 4: Create and Manage References

• Create and Manage Reference Elements
  • Insert Footnotes and Endnotes
  • Modify Footnote and Endnote Properties
  • Create and Modify Bibliography Citation Sources
  • Insert Citations for Bibliographies
• Create and Manage Reference Tables
  • Insert Tables of Contents
  • Customise Tables of Content
  • Insert Bibliographies

Module 5: Insert and Format Graphic Elements

• Insert Illustrations and Text Boxes
  • Insert Shapes
  • Insert Pictures
  • Insert 3D Models
  • Insert SmartArt Graphics
  • Insert Screenshots and Screen Clippings
  • Insert Text Boxes
• Format Illustrations and Text Boxes
  • Apply Artistic Effects
  • Apply Picture Effects and Picture Styles
  • Remove Picture Background
  • Format Graphic Elements
  • Format SmartArt Graphics
  • Format 3D Models
• Add Text to Graphic Elements
  • Add and Modify Text in Text Boxes
  • Add and Modify Text in Shapes
  • Add and Modify SmartArt Graphic Content
• Modify Graphic Elements
  • Position Objects
  • Wrap Text Around Objects
  • Add Alternative Text to Objects for Accessibility

Module 6: Manage Document Collaboration

• Add and Manage Comments
  • Add Comments
  • Review and Reply to Comments
  • Resolve Comments
  • Delete Comments
• Manage Change Tracking
  • Track Changes
  • Review Tracked Changes
  • Accept and Reject Tracked Changes
  • Lock and Unlock Change Tracking

Microsoft Word Expert MO101 Training Course Outline

Module 1: Manage Document Options and Settings

• Manage Documents and Templates
  • Modify Existing Document Templates
  • Manage Document Versions
  • Compare and Combine Multiple Documents
  • Link to External Document Content
  • Enable Macros in a Document
  • Customise the Quick Access Toolbar
  • Display Hidden Ribbon Tabs
  • Change the Normal Template Default Font
• Prepare Documents for Collaboration
  • Restrict Editing
  • Protect Documents by Using Passwords
• Use and Configure Language Options
  • Configure Editing and Display Languages
  • Use Language-Specific Features

Module 2: Use Advanced Editing and Formatting Features

• Find, Replace, and Paste Document Content
  • Find and Replace Text by Using Wildcards and Special Characters
  • Find and Replace Formatting and Styles
  • Apply Paste Options
• Configure Paragraph Layout Options
  • Configure Hyphenation and Line Numbers
  • Set Paragraph Pagination Options
• Create and Manage Styles
  • Create Paragraph and Character Styles
  • Modify Existing Styles
  • Copy Styles to Other Documents or Templates

Module 3: Create Custom Document Elements

• Create and Modify Building Blocks
  • Create QuickParts
  • Manage Building Blocks
• Create Custom Design Elements
  • Create Custom Colour Sets
  • Create Custom Font Sets
  • Create Custom Themes
  • Create Custom Style Sets
• Create and Manage Indexes
  • Mark Index Entries
  • Create Indexes
  • Update Indexes
• Create and Manage Tables of Figures
  • Insert Figure and Table Captions
  • Configure Caption Properties
  • Insert and Modify a Table of Figures

Module 4: Use Advanced Word Features

• Manage Forms, Fields, and Controls
  • Add Custom Fields
  • Modify Field Properties
  • Insert Standard Content Controls
  • Configure Standard Content Controls
• Create and Modify Macros
  • Record Simple Macros
  • Name Simple Macros
  • Edit Simple Macros
  • Copy Macros to Other Documents or Templates
• Perform Mail Merges
  • Manage Recipient Lists
  • Insert Merged Fields
  • Preview Merge Results
  • Create Merged Documents, Labels, and Envelopes

Proofpoint Training Course Outline

Module 1: Introduction to Proofpoint Essentials

• What is Proofpoint Essentials?
• Accessing the User Interface
  • Logging In
  • Resetting or Changing the Administrative Password
  • Using the Homepage
• Navigating the Interface

Module 2: Managing Your Account

• Update Your Profile
• Loading Users
  • Active Directory Sync
  • Azure Active Directory Sync
  • CSV Upload

Module 3: Managing Users and Groups

• Understanding Roles
  • Managing Users
  • Managing Groups
  • Export Users
  • Configuration Options for Users and Groups

Module 4: Accessing Additional Features

• Using Email Logs
  • Searching Logs
  • Advanced Search Options
  • Viewing Search Results
  • Actions
  • Report as False Negative
  • Hide Email from Logs
• Reports
  • Steps to Create a Report
  • Steps to Export a Report
  • Steps to Schedule a Report for Weekly Delivery

Module 5: Archive

• Configuring Proofpoint Essentials Archive
• Using the Proofpoint Essentials Archive
  • Who can Search the Archive?
  • Viewing Search Results
  • Redeliver
  • Forward
  • Export

Microsoft Excel Expert MO201​ Course Outline

Module 1: Manage Workbook Options and Settings

• Manage Workbooks
  • Copy Macros Between Workbooks
  • Reference Data in Other Workbooks
  • Enable Macros in a Workbook
  • Manage Workbook Versions
• Prepare Workbooks for Collaboration
  • Copy Macros Between Workbooks
  • Reference Data in Other Workbooks
  • Enable Macros in a Workbook
  • Manage Workbook Versions
• Use and Configure Language Options
  • Configure Editing and Display Languages
  • Use Language-Specific Features

Module 2: Manage and Format Data

• Fill Cells Based on Existing Data
  • Fill Cells by Using Flash Fill
  • Fill Cells by Using Advanced Fill Series Option
• Format and Validate Data
  • Create Custom Number Formats
  • Configure Data Validation
  • Group and Ungroup Data
  • Calculate Data by Inserting Subtotals and Totals
  • Remove Duplicate Records
• Apply Advanced Conditional Formatting and Filtering
  • Create Custom Conditional Formatting Rules
  • Create Conditional Formatting Rules That Use Formulas
  • Manage Conditional Formatting Rules

Module 3: Create Advanced Formulas and Macros

• Perform Logical Operations in Formulas

• Perform Logical Operations by Using Nested Functions

• Look Up Data by Using Functions
  • Look up Data by Using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() Functions
• Use Advanced Date and Time Functions
  • Reference Date and Time by Using the NOW() and TODAY() Functions
  • Calculate Dates by Using the WEEKDAY() and WORKDAY() Functions
• Perform Data Analysis
  • Summarise Data From Multiple Ranges by Using the Consolidate Feature
  • Perform What-if Analysis by Using Goal Seek and Scenario Manager
  • forecast data by using the AND(), IF(), and NPER() Functions
  • Calculate Financial Data by Using the PMT() Function
• Troubleshoot Formulas
  • Trace Precedence and Dependence
  • Monitor Cells and Formulas by Using the Watch Window
  • Validate Formulas by Using Error Checking Rules
  • Evaluate Formulas
• Create and Modify Simple Macros
  • Record Simple Macros
  • Name Simple Macros
  • Edit Simple Macros

Module 4: Manage Advanced Charts and Tables

• Create and Modify Advanced Charts
  • Create and Modify Dual Axis Charts
  • Create and Modify Charts Including Box and Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall Charts
• Create and Modify Pivot Tables
  • Create PivotTables
  • Modify Field Selections and Options
  • Create Slicers
  • Group PivotTable Data
  • Add Calculated Fields
  • Format Data
• Create and Modify Pivot Charts
  • Create PivotTables
  • Modify Field Selections and Options
  • Create Slicers
  • Group PivotTable Data
  • Add Calculated Fields
  • Format Data

Microsoft PowerPoint MO300​ Training Course Outline

Module 1: Manage Presentations

• Modify Slide Masters, Handout Masters, and Note Masters
  • Change the Slide Master Theme or Background
  • Modify Slide Master Content
  • Create Slide Layouts
  • Modify Slide Layouts
  • Modify the Handout Master
  • Modify the Notes Master
• Change Presentation Options and Views
  • Change Slide Size
  • Display Presentations in Different Views
  • Set Basic File Properties
• Configure Print Settings for Presentations
  • Print All or Part of a Presentation
  • Print Notes Pages
  • Print Handouts
  • Print in Colour, Grayscale, or Black and White
• Configure and Present Slide Shows
  • Create Custom Slide Shows
  • Configure Slide Show Options
  • Rehearse Slide Show Timing
  • Set Up Slide Show Recording Options
  • Present Slide Shows by Using Presenter View
• Prepare Presentations for Collaboration
  • Mark Presentations as Final
  • Protect Presentations by Using Passwords
  • Inspect Presentations for Issues
  • Add and Manage Comments
  • Preserve Presentation Content
  • Export Presentations to Other Formats

Module 2: Manage Slides

• Insert Slides
  • Import Word Document Outlines
  • Insert Slides from Another Presentation
  • Insert Slides and Select Slide Layouts
  • Insert Summary Zoom Slides
  • Duplicate Slides
• Modify Slides
  • Hide and Unhide Slides
  • Modify Individual Slide Backgrounds
  • Insert Slide Headers, Footers, and Page Numbers
• Order and Group Slides
  • Create Sections
  • Modify Slide Order
  • Rename Sections

Module 3: Insert and Format Text, Shapes, and Images

• Format Text
  • Apply Formatting and Styles to Text
  • Format Text in Multiple Columns
  • Create Bulleted and Numbered Lists
• Insert Links
  • Insert Hyperlinks
  • Insert Section Zoom Links and Slide Zoom Links
• Insert and Format Images
  • Resize and Crop Images
  • Apply Built-In Styles and Effects to Images
  • Insert Screenshots and Screen Clippings
• Insert and Format Graphic Elements
  • Insert and Change Shapes
  • Draw by Using Digital Ink
  • Add Text to Shapes and Text Boxes
  • Resize Shapes and Text Boxes
  • Format Shapes and Text Boxes
  • Apply Built-In Styles to Shapes and Text Boxes
  • Add Alt Text to Graphic Elements for Accessibility
• Order and Group Objects on Slides
  • Order Shapes, Images, and Text Boxes
  • Align Shapes, Images, and Text Boxes
  • Group Shapes and Images
  • Display Alignment Tools

Module 4: Insert Tables, Charts, SmartArt, 3D Models, and Media

• Insert and Format Tables
  • Create and Insert Tables
  • Insert and Delete Table Rows and Columns
  • Apply Built-In Table Styles
• Insert and Modify Charts
  • Create and Insert Charts
  • Modify Charts
• Insert and Format SmartArt Graphics
  • Insert SmartArt Graphics
  • Convert Lists to SmartArt Graphics
  • Add and Modify SmartArt Graphic Content
• Insert and Modify 3D Models
  • Insert 3D Models
  • Modify 3D Models
• Insert and Manage Media
  • Insert Audio and Video Clips
  • Create and Insert Screen Recordings
  • Configure Media Playback Options

Module 5: Apply Transitions and Animations

• Apply and Configure Slide Transitions
  • Apply Basic And 3D Slide Transitions
  • Configure Transition Effects
• Animate Slide Content
  • Animate Text and Graphics Elements
  • Animate 3d Models
  • Configure Animation Effects
  • Configure Animation Paths
  • Reorder Animations on a Slide
• Set Timing for Transitions
  • Set Transition Effect Duration
  • Configure Transition Start and Finish Options

Microsoft Outlook 2019 MO400 Training Course Outline

Module 1: Manage Outlook Settings and Processes

• Customise Outlook Settings
  • Change the Display of Messages, Calendar Items, Contact Records, and Tasks
  • Add Accounts
  • Configure Automatic Replies
• Configure Mail Settings
  • Specify Default Fonts for New Messages and Responses
  • Customise Reply Message Settings
  • Create, Assign, and Modify Signatures
• Perform Search Operations
  • Create Search Folders
  • Search for Messages, Calendar Items, Contacts, and Tasks
  • Search by Using Advanced Find
• Print and Save Information
  • Print Message, Calendar, Contact, and Task Information
  • Save Message Attachments
  • Preview Message Attachments
  • Save Messages in Alternative Formats

Module 2: Manage Messages

• Create Messages
  • Add or Remove Message Attachments
  • Designate Recipients by Using Courtesy Copy (Cc) and Blind Courtesy Copy (Bcc)
  • Use @Mention to Get Someone’s Attention
  • Forward and Reply to Messages
  • Flag Outgoing Messages for Follow Up
  • Set the Importance and Sensitivity of Outgoing Messages
• Insert Message Content
  • Insert Hyperlinks
  • Insert Images
  • Add Signatures to Individual Messages
• Organise and Manage Messages
  • Sort Messages
  • Create Folders
  • Move Messages Between Folders
  • Categorise Messages
  • Flag Received Messages
  • Ignore Conversations
  • Change the Display of Messages

Module 3: Manage Schedules

• Create and Manage Calendars
  • Set Calendar Work Times
  • Manage Multiple Calendars
• Create Appointments, Meetings, and Events
  • Create Recurring Calendar Items
  • Cancel Meetings
  • Create Calendar Items from Messages
  • Set Calendar Item Times and Time Zones
  • Set Up Meetings by Using the Scheduling Assistant
  • Set Availability for Calendar Items
• Organise and Manage Appointments, Meetings, and Events
  • Forward Calendar Items
  • Configure Reminders
  • Invite Meeting Participants
  • Respond to Invitations
  • Update Individual or Recurring Calendar Items

Module 4: Manage Contacts and Tasks

• Create and Manage Contact Records
  • Import Contacts from External Sources
  • Edit Contact Information
  • Share Contacts
• Create and Manage Contact Groups
  • Create and Delete Contact Groups
  • Add Contacts to Existing Contact Groups
  • Update Contacts Within Contact Groups
  • Delete Contact Group Members
• Create and Manage Tasks
  • Create and Manage Tasks

Advanced Microsoft Excel 2019 55270AC Course Outline

Module 1: Using PivotTables

• How PivotTables Work?
• Timeline Filters
• Inserting Slicers
• Grouping Data
• Calculated Fields
• PivotCharts
• Working with PivotTables

Module 2: Advanced Functions

• Function Syntax
• ROWS, COLUMNS, INDEX, and XMATCH
• Arrays and Array Formulas
• Getting Unique Values
• SORT, FILTER, and SORTBY
• Lookup Functions
• Using the XLOOKUP Function
• LET Function
• TRANSPOSE Function

Module 3: Auditing Workbooks

• Inspecting a Workbook
• Tracing Precedents and Dependents
• Tracing Precedents and Dependents Practice
• Watch Window
• Evaluating Formulas
• Error Checking

Module 4: Data Tools

• Importing Data from online source
• Converting Text to Columns
• Converting Text to Columns
• Importing Files
• Importing Text Files
• Linking to External Data
• Controlling Calculation Options
• Data Validation
• Using Data Validation
• Consolidating Data
• Consolidating Data
• What-If Analysis
• Using Goal Seek

Module 5: Recording and Using Macros

• Recording Macros
• Recording a Macro
• Running Macros
• Editing Macros
• Adding Macros to the Quick Access Toolbar
• Adding a Macro to the Quick Access Toolbar

Module 6: Working with Others

• Comments and Notes
• Protecting Worksheets and Workbooks
• Password Protecting a Workbook
• Marking a Workbook as Final
• Other Sharing Concerns

Microsoft 365 Administrator Training MS102 Course Outline

Module 1: Configure your Microsoft 365 Experience

• Microsoft 365 Cloud Environment
• Microsoft 365 Organisational Profile
• Tenant Subscriptions in Microsoft 365
• Integrate Microsoft 365 With Customer Engagement Apps
• Complete Your Tenant Configuration in Microsoft 365

Module 2: Manage Users, Licenses, and Mail Contacts in Microsoft 365

• User Identity Model for Your Organisation
• Create User Accounts in Microsoft 365
• Manage User Account Settings in Microsoft 365
• Manage User Licenses in Microsoft 365
• Recover Deleted User Accounts in Microsoft 365
• Perform Bulk User Maintenance in Azure Active Directory
• Create and Manage Guest Users
• Create and Manage Mail Contacts

Module 3: Manage Groups in Microsoft 365

• Examine Groups in Microsoft 365
• Create and Manage Groups in Microsoft 365
• Create Dynamic Groups Using Azure Rule Builder
• Create A Microsoft 365 Group Naming Policy
• Create Groups in Exchange Online and SharePoint Online

Module 4: Add a Custom Domain in Microsoft 365

• Plan A Custom Domain for Your Microsoft 365 Deployment
• Plan the DNS Zones for A Custom Domain
• Plan the DNS Record Requirements for A Custom Domain
• Create A Custom Domain in Microsoft 365

Module 5: Configure Client Connectivity to Microsoft 365

• Examine How Automatic Client Configuration Works
• DNS Records Required for Client Configuration
• Configure Outlook Clients
• Troubleshoot Client Connectivity

Module 6: Configure Administrative Roles in Microsoft 365

• Microsoft 365 Permission Model
• Explore the Microsoft 365 Admin Roles
• Assign Admin Roles to Users in Microsoft 365
• Delegate Admin Roles to Partners
• Manage Permissions Using Administrative Units in Azure Active Directory
• Elevate Privileges Using Azure AD Privileged Identity Management
• Best Practices When Configuring Administrative Roles

Module 7: Manage Tenant Health and Services in Microsoft 365

• Health of Your Microsoft 365 Services
• Monitor Tenant Health Using Microsoft 365 Adoption Score
• Monitor Tenant Health Using Microsoft 365 Usage Analytics
• Develop an Incident Response Plan
• Request Assistance from Microsoft

Module 8: Deploy Microsoft 365 Apps for Enterprise

• Microsoft 365 Apps for Enterprise Functionality
• App Compatibility by Using the Readiness Toolkit
• Complete A Self-Service Installation of Microsoft 365 Apps for Enterprise
• Deploy Microsoft 365 Apps for Enterprise with Microsoft Configuration Manager
• Microsoft 365 Apps for Enterprise from The Cloud
• Microsoft 365 Apps for Enterprise from A Local Source
• Manage Updates to Microsoft 365 Apps for Enterprise
• Explore the Update Channels for Microsoft 365 Apps for Enterprise
• Manage Cloud Apps Using the Microsoft 365 Apps Admin Centre

Module 9: Analyse your Microsoft 365 Workplace Data using Microsoft Viva Insights

• Examine the Analytical Features of Microsoft Viva Insights
• Personal Insights
• Team Insights
• Explore Organisation Insights
• Advanced Insights

Module 10: Explore Identity Synchronisation

• Identity Models for Microsoft 365
• Authentication Options for The Hybrid Identity Model
• Directory Synchronisation

Module 11: Prepare for Identity Synchronisation to Microsoft 365

• Introduction
• Plan Your Azure Active Directory Deployment
• Prepare for Directory Synchronisation
• Choose your Directory Synchronisation Tool
• Plan for Directory Synchronisation using Azure AD Connect
• Plan for Directory Synchronisation Using Azure AD Connect Cloud Sync

Module 12: Implement Directory Synchronisation tools

• Introduction
• Configure Azure AD Connect Prerequisites
• Configure Azure AD Connect
• Monitor Synchronisation Services Using Azure AD Connect Health
• Configure Azure AD Connect Cloud Sync Prerequisites
• Configure Azure AD Connect Cloud Sync

Module 13: Manage Synchronised Identities

• Introduction
• Manage Users with Directory Synchronisation
• Manage Groups with Directory Synchronisation
• Use Azure AD Connect Sync Security Groups to Help Maintain Directory Synchronisation
• Configure Object Filters for Directory Synchronisation
• Troubleshoot Directory Synchronisation

Module 14: Manage Secure User Access in Microsoft 365

• Introduction
• Manage User Passwords
• Enable Pass-Through Authentication
• Enable Multifactor Authentication
• Enable Password less Sign-In with Microsoft Authenticator
• Explore Self-Service Password Management
• Explore Windows Hello for Business
• Implement Azure AD Smart Lockout
• Implement Conditional Access Policies
• Explore Security Defaults in Azure AD
• Investigate Authentication Issues Using Sign-In Logs

Module 15: Examine Threat Vectors and Data Breaches

• Introduction
• Explore Today's Work and Threat Landscape
• Examine How Phishing Retrieves Sensitive Information
• Examine How Spoofing Deceives Users and Compromises Data Security
• Compare Spam and Malware
• Examine Account Breaches
• Examine Elevation of Privilege Attacks
• Examine How Data Exfiltration Moves Data Out of Your Tenant
• Examine How Attackers Delete Data From your Tenant
• Examine How Data Spillage Exposes Data Outside your Tenant
• Examine Other Types of Attack

Module 16: Explore the Zero Trust Security Model

• Introduction
• Examine the Principles and Components of the Zero Trust model
• Plan for a Zero Trust Security Model in your Organisation
• Examine Microsoft's Strategy for Zero Trust Networking
• Adopt a Zero Trust approach

Module 17: Explore Security Solutions in Microsoft 365 Defender

• Introduction
• Enhance your email security using Exchange Online Protection and Microsoft Defender for Office 365
• Protect Your Organisation's Identities Using Microsoft Defender for Identity
• Protect Your Enterprise Network Against Advanced Threats Using Microsoft Defender for Endpoint
• Protect Against Cyber-Attacks Using Microsoft 365 Threat Intelligence
• Provide Insight into Suspicious Activity Using Microsoft Cloud App Security
• Review the Security Reports in Microsoft 365 Defender

Module 18: Examine Microsoft Secure Score

• Introduction
• Explore Microsoft Secure Score
• Assess your Security Posture with Microsoft Secure Score
• Improve Your secure Score
• Track your Microsoft Secure Score History and Meet your Goals

Module 19: Examine Privileged Identity Management

• Introduction
• Explore Privileged Identity Management in Azure AD
• Configure Privileged Identity Management
• Audit Privileged Identity Management
• Explore Microsoft Identity Manager
• Control Privileged Admin Tasks using Privileged Access Management

Module 20: Examine Azure Identity Protection

• Introduction
• Explore Azure Identity Protection
• Enable the Default Protection Policies in Azure Identity Protection
• Explore the Vulnerabilities and Risk Events Detected by Azure Identity Protection
• Plan your Identity Investigation

Module 21: Exchange Online Protection

• Examine the Anti-Malware Pipeline
• Detect Messages with Spam or Malware using Zero-hour Auto Purge
• Anti-Spoofing Protection Provided by Exchange Online Protection
• Other Anti-Spoofing Protection
• Outbound Spam Filtering

Module 22: Microsoft Defender for Office 365

• Climb the Security Ladder from EOP to Microsoft Defender for Office 365
• Expand EOP Protections by Using Safe Attachments and Safe Links
• Manage Spoofed Intelligence
• Outbound Spam Filtering Policies
• Unblock Users from Sending Email

Module 23: Manage Safe Attachments

• Protect Users from Malicious Attachments by Using Safe Attachments
• Create Safe Attachment Policies using Microsoft Defender for Office 365
• Create Safe Attachments Policies using PowerShell
• Modify an Existing Safe Attachments Policy
• Create a Transport Rule to Bypass a Safe Attachments Policy
• Examine the End-User Experience with Safe Attachments

Module 24: Manage Safe Links

• Protect Users from Malicious URLs by Using Safe Links
• Create Safe Links Policies using Microsoft 365 Defender
• Create Safe Links Policies using PowerShell
• Modify an Existing Safe Links Policy
• Create a Transport Rule to Bypass a Safe Links Policy
• Examine the End-User Experience with Safe Links

Module 25: Explore Threat Intelligence in Microsoft 365 Defender

• Microsoft Intelligent Security Graph
• Alert Policies in Microsoft 365
• Run Automated Investigations and Responses
• Threat Hunting with Microsoft Threat Protection
• Advanced Threat Hunting in Microsoft 365 Defender
• Threat Analytics in Microsoft 365
• Threat Issues using Microsoft Defender Reports

Module 26: Implement App Protection by Using Microsoft Defender for Cloud Apps

• Microsoft Defender Cloud Apps
• Microsoft Defender for Cloud Apps
• File Policies in Microsoft Defender
• Manage and Respond to Alerts in Microsoft Defender
• Cloud Discovery in Microsoft Defender for
• Troubleshoot Cloud Discovery in Microsoft Defender

Module 27: Implement Endpoint Protection by Using Microsoft Defender

• Microsoft Defender for Endpoint
• Microsoft Defender for Endpoint in Microsoft Intune
• Onboard Devices in Microsoft Defender for Endpoint
• Manage Endpoint Vulnerabilities with Microsoft Defender Vulnerability Management
• Manage Device Discovery and Vulnerability Assessment
• Reduce Threat and Vulnerability Exposure

Module 28: Implement Threat Protection by Using Microsoft Defender

• Microsoft Defender for Office 365 Protection Stack
• Investigate Security Attacks by Using Threat Explorer
• Identify Cybersecurity Issues by Using Threat Trackers
• Prepare for Attacks with Attack Simulation

Module 29: Data Governance Solutions in Microsoft Purview

• Data Governance and Compliance in Microsoft Purview
• Protect Sensitive Data with Microsoft Purview Information Protection
• Govern Organisational Data Using Microsoft Purview Data Lifecycle Management
• Minimise Internal Risks with Microsoft Purview Insider Risk Management
• Microsoft Purview eDiscovery Solutions

Module 30: Archiving and Records Management in Microsoft 365

• Archive Mailboxes in Microsoft 365
• Enable Archive Mailboxes in Microsoft 365
• Microsoft Purview Records Management
• Implement Microsoft Purview Records Management
• Restore Deleted Data in Exchange Online
• Restore Deleted Data in SharePoint Online

Module 31: Retention in Microsoft 365

• Retention by Using Retention Policies and Retention Labels
• Compare Capabilities in Retention Policies and Retention Labels
• Scope of Retention Policy
• Principles of Retention
• Implement Retention Using Retention Policies, Retention Labels, and eDiscovery Holds
• Restrict Retention Changes by Using Preservation Lock

Module 32: Microsoft Purview Message Encryption

• Microsoft Purview Message Encryption
• Configure Microsoft Purview Message Encryption
• Define Mail Flow Rules to Encrypt Email Messages
• Add Organisational Branding to Encrypted Email Messages
• Microsoft Purview Advanced Message Encryption

Module 33: Compliance in Microsoft 365

• Plan for Security and Compliance in Microsoft 365
• Plan Your Beginning Compliance Tasks in Microsoft Purview
• Manage Your Compliance Requirements with Compliance Manager
• Examine the Compliance Manager Dashboard
• Analyse the Microsoft Compliance Score

Module 34: Implement Microsoft Purview Insider Risk Management

• Insider Risk Management
• Plan for Insider Risk Management
• Insider Risk Management Policies
• Create Insider Risk Management Policies
• Investigate Insider Risk Management Activities and Alerts
• Insider Risk Management Cases

Module 35: Implement Microsoft Purview Information Barriers

• Microsoft Purview Information Barriers
• Configure Information Barriers in Microsoft Purview
• Examine Information Barriers in Microsoft Teams
• Examine Information Barriers in OneDrive
• Examine Information Barriers in SharePoint

Module 36: Microsoft Purview Data Loss Prevention

• Examine Data Loss Prevention
• Endpoint Data Loss Prevention
• Examine DLP Policies
• View DLP Policy Results
• DLP Reports

Module 37: Implement Microsoft Purview Data Loss Prevention

• Plan to Implement Microsoft Purview Data Loss Protection
• Implement Microsoft Purview's Default DLP Policies
• Design a Custom DLP Policy
• Create a Custom DLP Policy from Template
• Configure Email Notifications for DLP Policies
• Configure Policy Tips for DLP Policies

Module 38: Implement Data Classification of Sensitive Information

• Data Classification
• Implement Data Classification in Microsoft 365
• Explore Trainable Classifiers
• Create and Retrain a Trainable Classifier
• View Sensitive Data Using Content Explorer and Activity Explorer
• Detect Sensitive Information Documents Using Document Fingerprinting

Module 39: Sensitivity Labels

• Manage Data Protection Using Sensitivity Labels
• What Sensitivity Labels Can Do?
• Sensitivity Label's Scope
• Apply Sensitivity Labels Automatically
• Sensitivity Label Policies

Module 40: Implement Sensitivity Labels

• Plan Your Deployment Strategy for Sensitivity Labels
• Requirements to Create a Sensitivity Label
• Create Sensitivity Labels
• Publish Sensitivity Labels
• Remove and Delete Sensitivity Labels

Intermediate Microsoft Excel 2019 M55269 Training Course Outline

Module 1: Common Functions

• Using Named Ranges in Formulas
• Entering a Formula Using Data in Multiple Worksheets
• IF and IFS
• AND and OR
• NOT
• SWITCH
• COUNTIF, AVERAGEIF, and SUMIF
• PMT and NPER
• TEXTJOIN and CONCAT
• Text Functions
• Creating Ordinal Numbers
• Date and Time Functions

Module 2: Working with Lists

• What is a List of Data?
• Removing Duplicates from a List
• Sorting Data in a List
• Filtering Data in a List
• Adding Subtotals to a List

Module 3: Visualising Your Data

• Chart Basics
• Tools for Editing Charts
• The Format Tool Tab
• Line and Area Charts
• Hierarchy Charts
• Statistic Charts
• Combo Charts
• Using Recommended Charts
• Sparklines
• Add and Format Objects
• Working with Icons
• Working with SmartArt
• Using the Quick Analysis Tool

Module 4: Working with Tables

• Format Data as a Table
• Table Design Tool Tab
• Formatting Individual Cells
• Selecting Table Rows and Columns
• Modifying a Table in Excel
• Structured References
• Convert a Table to a Range

Module 5: Advanced Formatting

• Cell Styles
• Conditional Formatting
• Highlight Cells Rules
• Top/Bottom Rules
• Data Bars, Color Scales, and Icon Sets
• Create a New Rule
• Removing Conditional Formatting

Introduction to Microsoft Project 2019: Getting Started M55288 Course Outline

Module 1: Components of a Project

• Project Components
• Demo and Exercise Projects Used in This Course
• Mapping a Project
• Exercise: Mapping a Project

Module 2: Getting Around Microsoft Project

• Starting Project
• The Ribbon
• Exercise: Understanding the Ribbon
• The Backstage view
• Exercise: Open and Save a Project
• Project Information
• Exercise: Enter Project Information
• Recent
• Tour of the Quick Access Toolbar
• Exercise: Add and Delete Commands from the Quick Access Toolbar
• Basic Formatting

Module 3: Calendars

• Project Start Date
• Exercise: Set the Start Date
• Creating a Project Calendar
• Connecting a Calendar to a Project
• Formatting the Timeline to Match a Custom Calendar
• Exercise: Create and Link a Project Calendar

Module 4: Working with Tasks

• Creating a Task
• Entering Durations
• Exercise: Enter Tasks and Durations
• Scheduling Tasks
• Exercise: Set a Task to Manual Scheduling
• Milestone Tasks
• Exercise: Add a Milestone Task
• Linking Tasks
• Exercise: Link Tasks
• Adding Notes to Tasks
• Add a Note to a Task
• Add a Calendar to a Task
• Exercise: Optional Follow-up Exercise: Add to Your Map

Module 5: Creating and Working with Resources

• Resource Sheet
• Exercise: Enter Work, Material, and Cost Resources
• Assigning Resources to Tasks
• Exercise: Assign Resources to Tasks

Module 6: Managing a Project

• Viewing a Project
• Reviewing and Adjusting a Project
• Exercise: Review the Project
• Setting a Baseline
• Viewing the Baseline
• Exercise: Set and View a Baseline
• Recording Progress
• Exercise: Record Progress
• Reporting on Projects
• Exercise: Create a Report
• Sending Data to Excel
• Exercise: Send Data to Excel

Microsoft Project 2019: Digging Deeper 55289A Course Outline

Module 1: Starting a Project from an Existing Project, Excel Workbook, or SharePoint Task List

• Starting a Project
• Exercise: Starting a Project

Module 2: Advanced Methods for Managing Tasks and Resources

• Manage Tasks and Resources
• Exercise: Change the Task Dependency
• Understanding Elapsed versus Actual Time Settings
• Setting Task Constraints
• Exercise: Creating a Task Constraint
• Splitting and Delaying Tasks
• Exercise: Splitting a Task Using the Gantt Chart View
• Delaying a Task: Using a Gantt Chart View
• Exercise: Delaying a Task: Using a Gantt Chart View
• Using the Task Inspector
• Exercise: Viewing the Task Inspector
• Analysing Critical Tasks and the Critical Path
• Exercise: Viewing the Critical Path
• Using Lag Time and Lead Time
• Exercise: Set Lag and Lead Time
• Analysing Task Assignments
• Exercise: Adding a Note through the Assignment Information Dialog Box
• Using the Team Planner
• Exercise: Displaying a Team Planner and Apply Formatting
• Using a Resource Pool and Sharing Resources
• Exercise: Sharing a Resource Pool
• Managing Resource Availability and Pay Rates
• Exercise: Changing a Pay Rate

Module 3: Managing the Project with Advanced Techniques

• Using Leveling to Solve Resource Overallocations
• Exercise: Using Leveling to Solve Resource Overallocations: Using the Gantt Chart View
• Amending Tasks
• Exercise: To Amend Tasks
• Understanding Baseline and Interim Plans
• Exercise: Setting Additional Baselines
• Analysing Project Costs and Creating Budgets
• Exercise: Creating Budgets

Module 4: Formatting and Customising Views

• Customising the Gantt Chart
• Exercise: Customising the Gantt Chart Using Gantt Chart View
• Creating a Custom View
• Exercise: Creating a Custom View
• Applying Filters
• Exercise: Applying Filters
• Using Work Breakdown Structure (WBS) Codes
• Exercise: Using Work Breakdown Structure (WBS) Codes

Module 5: Reporting

• Creating Visual Reports
• Exercise: Creating a Visual Report
• Editing Reports
• Exercise: Editing a Report

Module 6: Working with Templates

• Using Subproject within a Project
• Using Subprojects within a Project
• Using the Organiser to Maintain Templates
• Exercise: Using the Organiser

Module 7: Project Cloud

• Using the Cloud
• Exercise: Using the Cloud 

Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI M55164 Course Outline

Module 1: Power View

• Exploring the Power View Interface
• Visualising Power View Reports
• Working with Tables
• Understanding Aggregations
• Utilising Matrix
• Configuring Drill Through
• Using Cards
• Applying Filters
• Creating Charts
• Examining Tiles
• Adding Slicers to Reports
• Theming Reports
• Lab: Power View

Module 2: PowerPivot

• Exploring the PowerPivot Interface
• Loading Data
• Examining Relationships
• Configuring Calculated Columns and Calculated Fields
• Creating PivotTables
• Understanding DAX
• Utilising DAX Functions
• Using KPIs
• Working with Hierarchies
• Managing Perspectives
• Lab: PowerPivot

Module 3: Power Query

• Exploring The Power Query Interface
• Loading Data
• Managing Modifications
• Examining Data Cleaning
• Lab: Power Query

Module 4: Power Map

• Exploring The Power Map Interface
• Using Bing Maps
• Examining Map Data
• Reviewing Map Types and Presentation
• Lab: Power Map

Module 5: Introduction to Power BI

• Introducing Power BI
• Explaining Excel and Power BI
• Examining Data Sources
• Querying with Natural Language
• Lab: Introduction to Power BI

PowerPivot for End Users 50433B Training Course Outline

Module 1: PowerPivot Introduction

• PowerPivot Introduction

Lab

• Installing PowerPivot

Module 2: PowerPivot Data Sources

• Supported Data Sources

Lab

• Loading Data Sources
• Cleaning Data
• Creating Relationships

Module 3: PowerPivot Functions

• PowerPivot Expressions

Lab

• Create a Time Table
• Using DATE Functions
• Using TIME INTELLIGENCE Functions
• Using STATISTICAL Functions
• Using VALUE Functions
• Using LOGICAL and INFORMATION Functions
• Using TEXT Functions

Module 4: Building Reports Using PowerPivot

• PowerPivot Reports

Lab

• Creating Reports

Module 5: PowerPivot for SharePoint 2010

• Reports and Email
• PowerPivot for SharePoint 2010

Lab

• Installing PowerPivot for SharePoint 2010
• Configuring PowerPivot for SharePoint 2010

Microsoft 365 Certified Collaboration Communications Systems Engineer Associate Training Course Outline

Module 1 Introduction to Collaboration Communications Systems Engineering

• What is Collaboration Communications Systems Engineering?
• Networking Fundamentals for Collaboration Communications Systems
• Voice and Video Protocols for Collaboration Communications Systems
• Designing and Implementing Collaboration Communications Systems
• Troubleshooting and Maintenance of Collaboration Communications Systems
• Security and Compliance for Collaboration Communications Systems
• Advanced Topics in Collaboration Communications Systems Engineering

 Module 2: Introduction to Collaboration Communications Systems

• Overview of Collaboration Communications Systems
• Understanding the Components of Collaboration Communications Systems
• Designing Collaboration Communications Systems
• Implementing Collaboration Communications Systems
• Troubleshooting Collaboration Communications Systems
• Security and Compliance in Collaboration Communications Systems
• Managing Collaboration Communications Systems
• Advanced Collaboration Communications Systems
• Integrating Collaboration Communications Systems with Other Systems
• Best Practices for Collaboration Communications Systems

 Module 3: Networking Fundamentals

• Introduction to Networking
• Network Topologies
• Network Protocols
• Network Security
• Network Troubleshooting
• Network Performance Monitoring
• Network Design and Architecture
• Network Virtualisation
• Network Automation
• Network Management Tools and Techniques

 Module 4: Voice over IP (VoIP)

• VoIP Network Monitoring
• VoIP Network Management
• VoIP Billing and Accounting
• VoIP Interoperability and Integration
• Introduction to VoIP
• VoIP Protocols and Standards
• VoIP Network Design and Architecture
• VoIP Security
• VoIP Quality of Service
• VoIP Troubleshooting and Maintenance

 Module 5: Unified Communications

• Introduction to Unified Communications
• Overview of Voice over IP (VoIP)
• Understanding SIP Protocols
• Implementing VoIP Networks
• Configuring VoIP Gateways
• Troubleshooting VoIP Networks
• Managing VoIP Security
• Integrating Unified Communications with Other Systems
• Designing and Deploying Unified Communications Solutions
• Managing Unified Communications Systems

 Module 6: Video Conferencing

• Introduction to Video Conferencing
• Video Conferencing Protocols
• Video Conferencing Network Design
• Video Conferencing Security
• Video Conferencing Troubleshooting
• Video Conferencing Quality of Service
• Video Conferencing System Administration
• Video Conferencing System Integration
• Video Conferencing System Maintenance
• Video Conferencing System Performance Optimisation

 Module 7: Collaboration Tools

• Introduction to Collaboration Tools
• Understanding the Benefits of Collaboration Tools
• Evaluating Collaboration Tools
• Implementing Collaboration Tools
• Managing Collaboration Tools
• Troubleshooting Collaboration Tools
• Security Considerations for Collaboration Tools
• Integrating Collaboration Tools with Other Systems
• Best Practices for Collaboration Tools
• Advanced Collaboration Tools Features and Capabilities

 Module 8: System Design and Implementation

• Introduction to System Design and Implementation
• System Design Processes and Methodologies
• System Design Documentation
• System Architecture and Design
• System Design and Implementation Strategies
• System Design and Implementation Tools
• System Design and Implementation Testing
• System Design and Implementation Maintenance
• System Design and Implementation Security
• System Design and Implementation Troubleshooting

 Module 9: Troubleshooting and Maintenance

• Introduction to Troubleshooting and Maintenance
• Understanding the System Architecture
• Identifying and Resolving Common Issues
• Troubleshooting Network Connectivity Issues
• Troubleshooting Voice Quality Issues
• Troubleshooting Video Quality Issues
• Troubleshooting System Performance Issues
• Understanding System Maintenance Procedures
• Implementing System Upgrades and Patches

 Module 10: Security and Compliance

• Understanding Security and Compliance Regulations
• Implementing Security and Compliance Policies
• Risk Management Strategies
• Network Security and Firewall Configuration
• Data Encryption and Access Control
• Auditing and Monitoring Systems
• Disaster Recovery and Business Continuity Planning
• Security and Compliance Best Practices
• Troubleshooting Security and Compliance Issues
• Security and Compliance in Cloud Computing

 Module 11: Advanced Topics in Collaboration Communications Systems

• Advanced Networking Protocols for Collaboration Communications Systems
• Designing and Implementing Collaboration Communications Systems
• Security and Privacy in Collaboration Communications Systems
• Quality of Service in Collaboration Communications Systems
• Voice and Video Over IP for Collaboration Communications Systems
• Unified Communications and Collaboration Systems
• Cloud-Based Collaboration Communications Systems
• Mobile Collaboration Communications Systems
• Troubleshooting and Maintenance of Collaboration Communications Systems
• Advanced Troubleshooting and Maintenance of Collaboration Communications Systems

Creating and Sharing Interactive Dashboards with PowerPivot, Power View, and SharePoint Server 55103A Training Course Outline

Module 1: Dashboard Principles

• Develop Multiple Dashboards
• Change Deployed Dashboards
• Provide Interactive Help for Your Dashboards
• Monitor Dashboard Utilisation
• Methods for Gathering User Requirements

Module 2: Sourcing the Data

• Importing Data
• Relating Data
• Enriching Data
• Time Calculations

Module 3: Creating the Excel Dashboard

• Tabular Data
• Visual Data
• Linked Tables

Module 4: Adding Interactivity

• Adding Drill through
• Using Slicers and Timelines

Module 5: Sharing with SharePoint Excel Services

• Deploy to SharePoint
• Data Synchronisation Strategies in SharePoint

Microsoft Certified Dynamics 365 Supply Chain Management Functional Consultant Expert Training Course Outline

Module 1: Create Products and Product Masters in Dynamics 365 Supply Chain Management

• Configure and Manage Products and Inventory in Dynamics 365 Supply Chain Management
• Introduction
• Product Information Workspace
• Concept of a Product
• Create Products
• Set up Unit Conversions
• Batch Disposition Codes
• Default Order Settings
• Define Products as not Stocked
• Create Product Masters with Variants
• Variant Specific Sales Tax Groups
• Gain Productivity by using the Variant Suggestions Page
• Create and Set Up Category Hierarchies and Attributes
• Set up Item Pricing
• Lab - Create a Product and Product Master

Module 2: Create Bill of Materials in Dynamics 365 Supply Chain Management

• Introduction
• Work with the BOM Designer
• BOM and Formula Versions
• BOM Line Types
• BOM Levels
• Exercise - Create a BOM in the BOM Designer

Module 3: Get Started with Discrete Manufacturing in Dynamics 365 Supply Chain Management

• Introduction
• Discrete Manufacturing Life Cycle
• Master Planning and Planned Production Orders
• Bills of Materials
• Working with BOM and Item Configurations
• Create a Bill of Materials
• Production Orders
• Exercise - Create a Simple BOM without a Version
• Exercise - Create a BOM in the BOM Designer
• Exercise - Create a BOM with a Version
• Exercise - Create and Process a Production Order

Module 4: Work with Commodity Pricing and Compliance in Dynamics 365 Supply Chain Management

• Configure Commodity Pricing
• Configure Product Compliance
• Exercise - Set up Commodity Pricing
• Exercise - Set up Pricing Calculation
• Exercise - Create Price Data and Update Agreements
• Exercise - Product Compliance

Module 5: Configure Process Manufacturing in Dynamics 365 Supply Chain Management

• Introduction
• Process Manufacturing Item Types
• Production Type Setup
• Set up Packaging and Batch Attributes
• Shelf life Related Setup
• Item Model Group, Product Compliance, and Approved Vendors
• Catch Weight
• Transaction Adjustments
• Catch Weight Item Handling Policy
• Supported Scenarios
• Catch Weight Tags
• Configure Approved Vendors
• Exercise - Create an Approved Vendor List
• Exercise - Create and use a Partial Visibility Catch Weight Item
• Exercise - Use Catch Weight Items
• Exercise - Create Process Activities for Lean Manufacturing

Module 6: Get Started with Engineering Change Management for Dynamics 365 Supply Chain Management

• Introduction
• Overview of Features
• End-to-end Walkthrough of Features
• Exercise - Set up Demo Data for the Sample Scenario
• Exercise - Create a New Engineering Product
• Exercise - Release an Engineering Product to a Local Company
• Exercise - Review and Accept the Product Before you Release it in the Local Company
• Exercise - Use the Product in Transactions in the Local Company
• Exercise - Add the Engineering Product to a Sales Order
• Exercise - Request Changes in the Engineering Product
• Exercise - Make Changes to the Product by using an Engineering Change Order
• Exercise - Release the Changed Product

Module 7: Set up Versioned Products in Dynamics 365 Supply Chain Management

• Introduction
• Create an Engineering Organization
• Create Nomenclature for Product Versions
• Create Product Version Number Rules
• Create Product Dimension Groups by using the Version Dimension
• Create Product Life Cycle States
• Engineering Attributes
• Product Readiness Policies
• Product Release Policies
• Create Engineering Categories
• Exercise - Create a Product Readiness Policy

Module 8: Configure Engineering Change Management for Dynamics 365 Supply Chain Management

• Introduction
• Set up Engineering Change Severities
• Set up Severity Rule Sets
• Set up Product Owners
• Engineering Workflows
• Exercise - Create a Severity Rule

Module 9: Request and Follow Up with Product Changes in Dynamics 365 Supply Chain Management

• Introduction
• Engineering Change Requests
• Engineering Change Orders
• Exercise - Create an Engineering Change Request

Module 10: Set up Configurable Products in Dynamics 365 Supply Chain Management

• Introduction
• Product Configurator Concepts and Terminology
• Elements of a Product Configuration Model
• Scenario
• Product Model Components
• Exercise - Set up Components
• Create a Product Configuration Model
• Expression Constraints
• Calculations for Product Configuration
• BOMs and Routes
• Configuration Rules
• Sales Price Models
• Exercise - Create a Product Configuration Model
• Exercise - Add Components and Constraints to a Configuration Model

Module 11: Validate and Release Product Configuration Models in Dynamics 365 Supply Chain Management

• Introduction
• Extra Configuration Model Options
• Improve Product Configuration Performance
• Validate and Test a Product Configuration Model
• Configuration Templates
• Configuration Model Versions
• Release a Product Configuration Model
• Exercise - Release a Product Configuration Model

Module 12: Work with Configurable Products in Dynamics 365 Supply Chain Management

• Introduction
• Configurable Product Use Cases
• Intercompany and Multiple Site Considerations
• Extend a Product Configuration Model through the API
• Add a Configurable Product to a Sales Order Line
• Exercise - Add a Configurable Product to a Sales Order Line

Module 13: Work with the Costing Sheet in Dynamics 365 Supply Chain Management

• Introduction
• Costing Versions
• Cost Groups
• Calculation Groups
• Costing Sheets
• BOM Calculations
• BOM Measurements
• BOM Reports
• Lab - Analyze BOM Costs by using the Costing Sheet

Module 14: Configure Formulas for Process Manufacturing in Dynamics 365 Supply Chain Management

• Introduction
• Formulas, Formula Lines, and Formula Versions
• Formula Features
• Approve and Activate Formulas and Formula Versions
• Use Step Consumption
• Coproducts
• By-products
• Burden Allocation
• Planning Items
• Exercise - Copy and Modify Formula Versions
• Exercise - Create and Update a Scalable Formula
• Exercise - Create a Percentage-Based Formula
• Exercise - Create a Step Consumption Formula
• Exercise - Create Co-Products and by-Products
• Exercise - Create a New Formula with a Version from the Released Products Page

Module 15: Get Started with Production Control in Dynamics 365 Supply Chain Management

• Introduction
• Core Concepts in Production Control
• Understand Unified Manufacturing
• Manufacturing Principles
• Overview of the Production Process and Production Life Cycle
• Set up and Manage Production-Related Reservations
• Reset the Status of a Production Order
• Batch Orders
• Discrete Manufacturing
• Process Manufacturing
• Lean Manufacturing
• Configure Production Control for Unified Manufacturing
• Capacity Planning
• Integration between the General Ledger and the Production Control Modules
• IoT Intelligence and Insights
• Describe the Value Proposition for Mixed-Reality Guides for Production Floor Workers
• Lab - Explore Production Control

Module 16: Use Warehouse Management for Manufacturing in Dynamics 365 Supply Chain Management

• Production Input Location
• Production Output Location
• Staging and Order Picking
• Release BOM and Formula Lines to the Warehouse
• Automatically Rewave to add Unfulfilled Lines to New Waves
• Cross-Docking
• Planned Cross Docking
• Visibility into Material Exceptions
• Lab - Work with Warehouse Management in Manufacturing

Module 17: Work with Manufacturing Execution in Dynamics 365 Supply Chain Management

• Introduction
• Understand the Manufacturing Executions
• Identify Roles in Manufacturing Execution
• Planning Consideration for Manufacturing Execution
• Configure Manufacturing Execution
• Setup Time and Attendance for Manufacturing Execution Processes
• Control Production with Manufacturing Execution
• Create and Process Report as Finished Journals with Co-Products and by-Products
• Calculate and Approve Raw Time Registrations
• Report as Finished from the Job Card Device
• Lab - Manufacturing Execution

Module 18: Get Started with Asset Management for Dynamics 365 Supply Chain Management

• Overview and Benefits
• Asset Management Terminology and Concepts
• Functional Locations and Assets
• Assets and Work Orders
• Use the Asset Management Mobile Workspace
• Asset Management Integration Capabilities
• Integrate Asset Management with Dynamics 365 Guides

Module 19: Schedule Work Orders in Asset Management for Dynamics 365 Supply Chain Management

• Introduction
• Configure Workers for Work Order Scheduling
• Schedule and Dispatch Work Orders
• Calculate Capacity Load on Scheduled Work Orders
• Lab - Set up a Preferred Worker, and Schedule A Work Order

Module 20: Configure and Perform the Procure-To-Purchase Process in Dynamics 365 Supply Chain Management

• Introduction
• Procurement Scenario
• Overview of the Procure-to-Purchase Process
• Set up Procurement Categories
• Use Procurement Catalogs
• Create a Purchase Requisition
• Create and Process a Request for Quotation
• Create Purchase Orders
• Vendor Categories and Catalogs
• Evaluate a Vendor and put a Vendor on hold

Module 21: Configure Activity-Based Subcontracting and Production Flow Costing in Dynamics 365 Supply Chain Management

• Overview of Subcontracting and Production Flow Costing
• Subcontracting Capabilities
• Subcontracting a Vendor
• Subcontracting Service
• Create and Process Subcontracting Purchase Orders
• Transfer Activities as Subcontracting Activities
• Subcontracting as an Alternate Resource
• Cost Accounting of Subcontracted Services
• Subcontracting Cost Flow
• Backflush Costing
• Products and Material in Work in Progress
• Standard Cost
• Costing Lean Manufacturing
• Calculation of Standard Cost
• Calculate Unused Quantities
• Calculation of Production Variances to Standard Cost
• Ledger Entries Created from Processing a Production Flow
• Exercise - Set up a Default Vendor and Create a Purchase Agreement
• Exercise - Create a Work Cell for Subcontracting
• Exercise - Create an Activity-Based Subcontracting Rule
• Exercise - Create and Schedule Kanbans for Subcontracting
• Exercise - Process and Transfer Jobs

Module 22: Configure and Use Agreements in Dynamics 365 Supply Chain Management

• Introduction
• Work with Trade Agreements
• Create Sales Agreements
• Create Purchase Agreements
• Configure Trade Allowance Management
• Configure Brokerage Contract Management
• Configure Royalty Contract Management
• Configure Vendor Rebates
• Rebate Management Module
• Service Management
• Exercise - Create a Purchase Agreement
• Exercise - Generate and Process Customer Rebates
• Exercise - Create Trade Agreements

Module 23: Work with Capacity Planning and Scheduling in Dynamics 365 Supply Chain Management

• Introduction
• Scheduling Options
• Split a Production Order
• Operations Scheduling
• Job Scheduling
• Scheduling Options from the Gantt Chart
• Resource Scheduling
• Scrap and Waste
• Exercise - Start a Discrete Production Order
• Exercise - Run a Resource Schedule

Module 24: Set up Master Planning in Dynamics 365 Supply Chain Management

• Introduction
• Master Planning Considerations and Set Up
• Master Planning Parameters Page
• Create a Master Plan
• Coverage Settings
• Action Messages
• Demand Forecasting
• Run Plans and Firm Planned Orders
• Set up and use the Supply Schedule Page
• Exercise - Firm a Planned Order
• Deprecated Master Planning

Module 25: Use Master Planning in Dynamics 365 Supply Chain Management

• Introduction
• Set up Master Planning add-in
• Apply Filters to a Plan
• Master Planning with Demand Forecasts
• Master Planning Support for Capability-Based Resource Allocation
• Priority-Based Planning
• Master Planning and Purchase Trade Agreements
• Set up Supply Chain Calendars
• Safety Margins
• Coverage Time Fences
• Approved Planned Orders
• Generate Planned Production Orders
• Analyze and Approve Planned Orders
• Auto-Firming
• Planning with Negative On-Hand Quantities
• View History and Planning Logs
• Exercise - Set up Purchase Trade Agreement

Module 26: Create and Process Fixed Kanbans in Dynamics 365 Supply Chain Management

• Introduction
• Understand Kanban Boards
• Configure a Fixed Kanban Rule
• Process a Fixed Kanban
• Kanban Quantity Calculations and Circulating Kanbans
• Exercise - Configure a Fixed Quantity Kanban Rule
• Exercise - Fixed Kanban Job Processing

Module 27: Identify and Configure Batch Attributes for Process Manufacturing in Dynamics 365 Supply Chain Management

• Batch Attributes
• Assign and Reserve Batch Attributes
• Products that have an Active Ingredient
• Ingredient Types
• The Batch Balancing Process
• Exercise - Create and Assign Batch Attributes
• Exercise - Record Batch Attributes at Batch Creation
• Exercise - Record Batch Attribute Values by using Quality Orders
• Exercise - Reserve Batch Attributes on Sales Orders

Optimise productivity with Copilot for Microsoft 365 (MS-4004) Course Outline

Module 1: Introduction to Microsoft 365 Copilot

• What is Microsoft 365 Copilot?
• Explore How Microsoft 365 Copilot Works
• Explore the Core Components of Microsoft 365 Copilot
• Examine How Microsoft is Committed to Responsible AI

Module 2: Explore the possibilities with Microsoft 365 Copilot

• Compose and Summarise Documents with Microsoft 365 Copilot in Word
• Summarise and Draft Emails with Microsoft 365 Copilot in Outlook
• Design Captivating Presentations with Microsoft 365 Copilot in PowerPoint
• Analyse and Transform Data with Microsoft 365 Copilot In Excel
• Elevate Productivity with Microsoft 365 Copilot in Teams
• Empower your Workflow with Microsoft 365 Business Chat

Module 3: Optimise and extend Microsoft 365 Copilot

• Examine the Art and Science of Working with AI
• Review Best Practices for using Microsoft 365 Copilot
• Examine How to Build an Effective Prompt
• Review Prompting Best Practices
• Extend Microsoft 365 Copilot

Module 4: Empower your workforce with Microsoft 365 Copilot: Executives Use Case

• Exercise: Synthesize your Communication insights using Business Chat
• Exercise: Summarise Chat and Channel Threads using Microsoft 365 Copilot in Teams
• Exercise: Create a Speech using Microsoft 365 Copilot in Word
• Exercise: Create a Slide Presentation using Microsoft 365 Copilot in PowerPoint

Module 5: Empower your workforce with Microsoft 365 Copilot: Sales use case

• Exercise: Create a Market Research Report using Microsoft 365 Copilot in Loop
• Exercise: Create a Sales Presentation using Microsoft 365 Copilot in PowerPoint
• Exercise: Prepare your Meeting Notes from Emails using Business Chat
• Exercise: Compare Supplier Agreements using Microsoft 365 Copilot in Word

Module 6: Empower your workforce with Microsoft 365 Copilot: IT Use Case

• Exercise: Create a Project Plan using Business Chat
• Exercise: Create a Project Plan Presentation using Microsoft 365 Copilot in PowerPoint
• Exercise: Update a Technical Report using Microsoft 365 Copilot in Word
• Exercise: Draft an Email based on a Technical Report using Microsoft 365 Copilot in Outlook

Module 7: Empower your workforce with Microsoft 365 Copilot: Marketing Use Case

• Exercise: Conduct Market Analysis using Business Chat
• Exercise: Brainstorm Marketing Campaign Ideas using Microsoft 365 Copilot in Loop
• Exercise: Consolidate Multiple Marketing Reports using Microsoft 365 Copilot in Word
• Exercise: Analyse a Market Trend Spreadsheet using Microsoft 365 Copilot in Excel

Module 8: Empower your workforce with Microsoft 365 Copilot: Finance Use Case

• Exercise: Draft an Email to your Insurance Company using Microsoft 365 Copilot in Outlook
• Exercise: Analyse a Financial Spreadsheet using Microsoft 365 Copilot in Excel
• Exercise: Create a Financial Analysis report using Microsoft 365 Copilot in Word
• Exercise: Summarise Financial Results using Microsoft 365 Copilot in Word

Module 9: Empower your workforce with Microsoft 365 Copilot: HR Use Case

• Exercise: Create A Job Description Using Microsoft 365 Copilot in Word
• Exercise: Analyse Resumes and Make a Recommendation Using Microsoft 365 Copilot In Word
• Exercise: Create Interview Questions Using Microsoft 365 Copilot in Loop
• Exercise: Compose an Email Offer Letter Using Microsoft 365 Copilot in Outlook

Module 10: Empower your workforce with Microsoft 365 Copilot: Operations use case

• Exercise: Brainstorm Project Plan Ideas Using Microsoft 365 Copilot in Whiteboard
• Exercise: Draft a Meeting Reply Using Microsoft 365 Copilot in Outlook
• Exercise: Compare Reporting Results Using Microsoft 365 Copilot in Word
• Exercise: Create a Presentation Comparing Heating Systems Using Microsoft 365 Copilot in PowerPoint

Module 11: Empower your workforce with Microsoft 365 Copilot: Challenge Use Case

• Exercise: Create Interview Questions Using Different Copilots
• Exercise: Enhance Your Social Media Marketing Efforts
• Exercise: Enhance Your Project Management Collaboration Skills
• Exercise: Enhance Content Creation and Collaboration Skills

Employee Experience Platform Specialist MS080 Training Course Outline

Module 1: Design Digital Employee Experiences

• Introduction
• Evaluate Current Employee Experiences
• Consider Employee Privacy and Data Requirements
• Assemble Business Stakeholders and Define Goals
• Explore Viva Experience Areas
• Understand Viva Licensing

Module 2: Introduction to the Microsoft Viva Suite

• Introduction to Microsoft Viva
• Understand Viva Apps
• Get Started with Microsoft Viva
• Use Viva to Keep Everyone Informed, Included, and Inspired
• Use Viva to Get Actionable Insights to Foster Well-being and Productivity
• Use Viva to Align People's Work to Team and Organisation Goals
• Use Viva to Help Employees Learn, Grow, and Succeed

Module 3: Introduction to Viva Connections

• Introduction
• What Do Users Experience?
• When to Use Viva Connections?
• What Technical Requirements Must Be Met to Deploy Viva Connections?

Module 4: Design Skilling and Growth Experiences with Viva Learning

• Introduction
• Case Study - Tailwind Traders
• Plan for Viva Learning
• Assemble Viva Learning Admins and Stakeholders
• Understand Content Sources with Viva Learning
• Coordinate Setup and Configuration of Viva Learning
• Develop Adoption Strategies for Viva Learning
• Develop an Org-wide Learning Culture

Module 5: Guided Project - Create Featured Set of Content in Viva Learning

• Introduction to Viva Learning Featured Sets
• Prepare Your Environment
• Exercise - Add Knowledge Administrator and Knowledge Manager
• Exercise - Configure Learning Content Sources
• Exercise - Add SharePoint as a Content Source
• Exercise - Manage Learning Content in SharePoint
• Exercise - Create Featured Content Set

Module 6: Design Productivity and Wellbeing Experiences with Viva Insights

• Introduction
• Measure Workplace Patterns with Viva Insights
• Identify Viva Insights Stakeholders
• Assess Experiences and Define Goals
• Coordinate Setup and Deployment of Viva Insights
• Communication and Adoption Planning
• Knowledge Check

Module 7: Introduction to Microsoft Viva Glint

• What is Viva Glint?
• What Are the Key Benefits of Using Viva Glint?
• How Can Users Across the Organisation Benefit from Using Viva Glint?
• What Are the Survey Types and How Can They Support Engagement?
• How Do I Get Started with Viva Glint?

Module 8: Get to Know Viva Glint’s Approach to Modern Engagement

• Who is Viva Glint and What Makes Us Different?
• What is People Success?
• How Can Leaders Enact a People Success Approach?

Module 9: Learn OKR Essentials with Viva Goals

• Introduction
• What Are OKRs?
• Why OKRs?
• Best Practices for Getting Started with OKRs and Viva Goals

Module 10: Role of an OKR Champion

• Introduction
• Roles and Responsibilities
• How to Communicate About OKRs and Viva Goals with Your Team
• How to Successfully Leverage Resources

Copilot for Microsoft 365 for Administrators MS-4006 Training Course Outline

Module 1: Examine the Microsoft 365 Copilot Design

• Introduction
• Examine the Microsoft 365 Copilot Logical Architecture
• Examine the Key Components of Microsoft 365 Copilot
• Explore the Microsoft 365 Copilot Service and Tenant Architecture
• Extend Microsoft 365 Copilot with Plugins and Microsoft Graph Connectors

Module 2: Implement Microsoft 365 Copilot

• Introduction
• Get Ready for Microsoft 365 Copilot
• Prepare Your Data for Searches in Microsoft 365 Copilot
• Protect Your Microsoft 365 Copilot Data with Microsoft 365 Security Tools
• Assign Your Microsoft 365 Copilot Licenses
• Drive Microsoft 365 Copilot Adoption with a Copilot Centre of Excellence

Module 3: Examine Data Security and Compliance in Microsoft 365 Copilot

• Introduction
• Examine How Microsoft 365 Copilot Uses Your Proprietary Business Data
• Examine How Microsoft 365 Copilot Protects Sensitive Business Data
• Examine How Microsoft 365 Copilot Uses Microsoft 365 Isolation and Access Controls
• Examine How Microsoft 365 Copilot Meets Regulatory Compliance Mandates

Module 4: Manage Secure User Access in Microsoft 365

• Introduction
• Examine the Identity and Access Tools Used in Microsoft 365
• Manage User Passwords
• Implement Conditional Access Policies
• Enable Pass-Through Authentication
• Implement Multifactor Authentication
• Explore Passwordless Authentication Options
• Explore Self-Service Password Management
• Implement Microsoft Entra Smart Lockout
• Explore Security Defaults in Microsoft Entra ID
• Investigate Authentication Issues Using Sign-In Logs

Module 5: Manage Permissions, Roles, and Role Groups in Microsoft 365

• Introduction
• Examine the Use of Roles in the Microsoft 365 Permission Model
• Manage Roles Across the Microsoft 365 Ecosystem
• Explore Administrator Roles in Microsoft 365
• Examine Best Practices When Configuring Administrative Roles
• Assign Admin Roles to Users in Microsoft 365
• Delegate Admin Roles to Partners
• Implement Role Groups in Microsoft 365
• Manage Permissions Using Administrative Units in Microsoft Entra ID
• Manage SharePoint Permissions to Prevent Oversharing of Data
• Elevate Privileges Using Microsoft Entra Privileged Identity Management

Module 6: Implement Data Classification of Sensitive Information

• Introduction
• Explore Data Classification
• Implement Data Classification in Microsoft 365
• Explore Trainable Classifiers
• Create and Retrain a Trainable Classifier
• View Sensitive Data Using Content Explorer and Activity Explorer
• Detect Sensitive Information Documents Using Document Fingerprinting

Module 7: Explore Sensitivity Labels

• Introduction
• Manage Data Protection Using Sensitivity Labels
• Explore What Sensitivity Labels Can Do
• Determine a Sensitivity Label's Scope
• Apply Sensitivity Labels Automatically
• Explore Sensitivity Label Policies

Module 8: Implement Sensitivity Labels

• Introduction
• Plan Your Deployment Strategy for Sensitivity Labels
• Enable Sensitivity Labels for Files in SharePoint and OneDrive
• Examine the Requirements to Create a Sensitivity Label
• Create Sensitivity Labels
• Publish Sensitivity Labels
• Remove and Delete Sensitivity Labels

Craft Effective Prompts for Microsoft Copilot for Microsoft 365 MS-4005 Training Course Outline

Module 1: Introduction to Microsoft 365 Copilot

• Introduction
• What is Microsoft 365 Copilot?
• How Microsoft 365 Copilot Works?
• Core Components of Microsoft 365 Copilot
• Examine How Microsoft is Committed to Responsible AI

Module 2: Explore the Possibilities with Microsoft 365 Copilot

• Compose and Summarise Documents with Microsoft 365 Copilot in Word
• Summarise and Draft Emails with Microsoft 365 Copilot in Outlook
• Design Captivating Presentations with Microsoft 365 Copilot in PowerPoint
• Analyse and Transform Data with Microsoft 365 Copilot in Excel
• Elevate Productivity with Microsoft 365 Copilot in Teams
• Empower Your Workflow with Microsoft 365 Business Chat

Module 3: Optimise and Extend Microsoft 365 Copilot

• Examine the Art and Science of Working with AI
• Review Best Practices for Using Microsoft 365 Copilot
• Examine How to Build an Effective Prompt
• Review Prompting Best Practices
• Extend Microsoft 365 Copilot

Module 4: Summarise and Simplify Information with Microsoft 365 Copilot

• Exercise - Follow Along Using Sample Data with Microsoft 365 Copilot
• Simplify and Extract Key Information with Copilot in Word
• Identify Key Information and Summarise with Copilot in PowerPoint
• Spot Trends and Visualise Data with Copilot in Excel
• Highlight Key Decisions and Actions from Teams Meetings
• Catch Up and Prepare for the Week with Copilot in Outlook
• Summarise Information on a Topic with Microsoft 365 Business Chat

Module 5: Create and Draft with Microsoft 365 Copilot

• Introduction to Creating Draft Content with Microsoft 365 Copilot
• Exercise - Follow Along Using Sample Data with Microsoft 365 Copilot
• Draft Cover Letters, Marketing Plans, and Outlines with Microsoft 365 Copilot in Word
• Build New Slides, Agendas, and To-Do Lists with Microsoft 365 Copilot in PowerPoint
• Draft Emails, Replies, and Meeting Agendas with Microsoft 365 Copilot in Outlook
• Brainstorm New Ideas, Lists, and Reports with Microsoft 365 Business Chat

Module 6: Edit and Transform Content with Microsoft 365 Copilot

• Exercise - Follow Along Using Sample Data with Microsoft 365 Copilot
• Write, Organise, and Transform Content Using Microsoft 365 Copilot in Word
• Add Images, Slides, and Organise Your Presentation Using Microsoft 365 Copilot in PowerPoint
• Format, Sort, Filter, and Highlight Data Using Microsoft 365 Copilot in Excel
• Rewrite Messages and Replies for Tone Using Microsoft 365 Copilot in Outlook

Module 7: Ask Questions and Analyse Content with Microsoft 365 Copilot

• Exercise - Follow Along Using Sample Data with Microsoft 365 Copilot
• Ask Microsoft 365 Copilot in Word for Help and Recommendations
• Get Design and Organisation Tips with Microsoft 365 Copilot in PowerPoint
• Analyse and Work with Tables Using Microsoft 365 Copilot in Excel
• Ask Questions About Your Notes Using Microsoft 365 Copilot in OneNote
• Ask About Your Meetings and Messages with Microsoft 365 Copilot in Teams

Microsoft 365 Certified Collaboration Communications Systems Engineer MS721 Training Course Outline

Module 1: Plan and Design Teams Collaboration Communications Systems

• Introduction to Teams Meetings and Calling

• Overview of Teams Meetings and Events
• Overview of Teams Phone
• Overview of Auto Attendants and Call Queues
• Overview of Teams Clients
• Overview of Microsoft Teams Rooms and Phones
• Overview of Microsoft 365 Copilot in Teams Calling, Meetings, and Devices

• Plan for Teams Phone

• Plan to Deploy Teams Phone
• Plan for Teams Phone PSTN Connectivity
• Determine License Requirements
• Plan for Teams Phone Devices
• Plan and Design Teams Phone Features
• Plan for Voicemail

• Plan for Microsoft Teams Rooms and Surface Hub

• Determine License Requirements for Microsoft Teams Rooms and shared Devices
• Understand differences between Microsoft Teams Rooms on Android and Windows
• Understand Microsoft Teams Rooms on Surface Hub 2S
• Understand and Plan Teams Room Accessories, Components, and Peripherals
• Integrate Teams with Third-Party or Existing Conferencing Solutions
• Understand Teams Rooms Management Options

• Plan and Optimise Network Performance for Teams Media

• Understand Teams Network Requirements
• Evaluate Network Specifications
• Design Network for Media Optimisation
• Design and Validate VPN Split Tunneling
• Configure Media Bit Rate for Teams
• Design and Implement QoS

• Configure and Deploy Teams Phone

• Configure Emergency Calling for Teams Calling Plans
• Manage and Configure Microsoft PSTN Numbers
• Configure Operator Connect and Teams Phone Mobile
• Configure Teams Phone Policies
• Create and Manage Teams Policies

• Configure and Deploy Teams Phone with Direct Routing

• Design Direct Routing Call Flows
• Implement SIP Trunking with Direct Routing
• Configure Emergency Calling for Direct Routing
• Extend Teams Direct Routing Infrastructure
• Deploy and Maintain a Survivable Branch Appliance

• Extend Teams Phone with Additional Services

• Understand how Teams Interacts with Additional Services
• Configure Compliance Recording in Teams
• Configure and Integrate a Certified Contact Center in Teams
• Design and Deploy Voice Bots in Teams

Module 2: Manage Teams Collaboration Communications Systems

• Manage Meetings and Events Experiences

• Explore Meetings and Events in Microsoft Teams
• Configure Meeting Settings
• Create and Manage Meeting Policies
• Configure Audio Conferencing
• Create and Manage Meeting Templates and Template Policies
• Create and Manage Meetings Customisation Policies
• Explore Webinars and Town Halls with Teams Premium
• Create and Manage Events Policies
• Explore Immersive Spaces in Teams

• Guided Project - Create and Assign Teams Policies to Meet Business Requirements in Microsoft Teams

• Prepare
• Exercise - Create a Security Group
• Exercise - Create and Assign a Messaging Policy in Teams Admin Center
• Exercise - Create a Meeting Policy and Assign with PowerShell

• Configure and Manage Voice Users

• Enable Users for Teams Phone
• Enable Users for Direct Routing with Teams Phone
• Enable Additional calling Features for Teams Phone
• Enable Users for Teams Phone Mobile

• Configure Auto Attendants and Call Queues

• Design Call Flows for Auto Attendants and Call Queues
• Configure Auto Attendants and Call Queues
• Deploy a Channel-Based Call Queue
• Configure Resource Accounts
• Configure Microsoft 365 Groups for Voicemail
• Interpret Call Queue Conference Modes
• Interpret Call Queue Routing Methods
• Configure Holidays for Auto Attendants and Call Queues
• Configure Custom Music on hold

• Configure, Deploy, and Manage Teams Devices

• Manage Microsoft Teams Phones
• Manage Microsoft Teams Room Systems
• Microsoft Teams Rooms Management Options
• Manage Surface Hub 2S Devices
• Configure Microsoft Teams SIP Gateway
• Manage Microsoft Teams Displays
• Remote Provisioning and Sign in for Teams Phones
• Update Microsoft Teams Devices Remotely
• Manage Microsoft Teams Device Tags

• Guided Project - Prepare Meeting Room Experiences

• Prepare
• Exercise - Create Dynamic Security Group
• Exercise - Configure Security Settings
• Exercise - Create Room Resource Accounts
• Exercise - Configure Mailbox Properties

• Monitor and Troubleshoot Teams Collaboration Communications Systems

• Diagnose and Troubleshoot Phone Number Assignment
• Diagnose and Troubleshoot Teams Client Issues
• Diagnose and Troubleshoot Call Failure and Call Quality Issues
• Report on and Troubleshoot Teams Calls with Call Quality Dashboard
• Diagnose and Troubleshoot Direct Routing Issues
• Troubleshoot and Monitor Teams Devices
• Troubleshoot Teams Meetings and Calling
• Troubleshoot Teams Rooms Devices