Microsoft 365 Training - Cuba

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
• Using Named Ranges in Formulas (Exercise)
• Using Formulas That Span Multiple Worksheets
• Entering a Formula Using Data in Multiple Worksheets (Exercise)
• Functions: IF and IFS
• Using the IF Function (Exercise)
• Functions: AND and OR
• Functions: NOT
• Functions: SWITCH
• Functions: COUNTIF, AVERAGEIF, and SUMIF
• Functions: PMT and NPER
• Using the PMT Function (Exercise)
• Functions: TEXTJOIN and CONCAT
• Using the TEXTJOIN Function (Exercise)
• Text Functions
• Creating Ordinal Numbers (Exercise)
• Date and Time Functions
• Using Date Functions (Exercise)

Module 2: Working with Lists

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

Module 3: Visualizing Your Data

• Chart Basics
• Tools for Editing Charts
• Using the Chart Design Tool Tab (Exercise)
• The Format Tool Tab
• Using the Three Chart Buttons
• The Format Task Pane
• Useful Charts
• Line and Area Charts
• Hierarchy Charts
• Statistic Charts
• Other Charts
• Combo Charts
• Using Recommended Charts
• Sparklines
• Inserting and Customizing Sparklines (Exercise)
• Add and Format Objects
• Working with Shapes
• 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
• Creating and Modifying a Table in Excel (Exercise)
• Structured References
• Convert a Table to a Range

Module 5: Advanced Formatting

• Cell Styles
• Working with Cell Styles (Exercise)
• Conditional Formatting
• Conditional Formatting: Highlight Cells Rules
• Conditional Formatting: Top/Bottom Rules
• Conditional Formatting: Data Bars, Color Scales, and Icon Sets
• Conditional Formatting: Create a New Rule
• Removing Conditional Formatting
• Using Conditional Formatting (Exercise)

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: Configure and Manage Products and Inventory in Dynamics 365 Supply Chain Management

• Get Started with Dynamics 365 Supply Chain Management
• Configure and Work with Inventory Management in Dynamics 365 Supply Chain Management
• Use Inventory Reports in Dynamics 365 Supply Chain Management
• Create Products and Product Masters in Dynamics 365 Supply Chain Management
• Create Bill of Materials in Dynamics 365 Supply Chain Management

Module 2: Configure and Use Discrete Manufacturing in Dynamics 365 Supply Chain Management

• Get Started with Production Control in Dynamics 365 Supply Chain Management
• Get Started with Discrete Manufacturing in Dynamics 365 Supply Chain Management
• Configure Discrete Manufacturing in Dynamics 365 Supply Chain Management
• Work with the Costing Sheet in Dynamics 365 Supply Chain Management
• Work with Capacity Planning and Scheduling in Dynamics 365 Supply Chain Management
• Work with Manufacturing Execution in Dynamics 365 Supply Chain Management
• Get Started with Product Configuration in Dynamics 365 Supply Chain Management

Module 3: Configure and Use Process Manufacturing in Dynamics 365 Supply Chain Management

• Get Started with Production Control in Dynamics 365 Supply Chain Management
• Configure Process Manufacturing in Dynamics 365 Supply Chain Management
• Configure Formulas for Process Manufacturing in Dynamics 365 Supply Chain Management
• Identify and Configure Batch Attributes for Process Manufacturing in Dynamics 365 Supply Chain Management
• Work with Commodity Pricing and Compliance in Dynamics 365 Supply Chain Management

Module 4: Set Up Engineering Change Management for Dynamics 365 Supply Chain Management

• Get Started with Engineering Change Management for Dynamics 365 Supply Chain Management
• Set Up Versioned Products in Dynamics 365 Supply Chain Management
• Configure Engineering Change Management for Dynamics 365 Supply Chain Management
• Convert an Existing Product to an Engineering Product in Dynamics 365 Supply Chain Management

Module 5: Manage Product Version Information in Dynamics 365 Supply Chain Management

• Manage a Discrete Product BOM and Route for Versioned Products in Dynamics 365 Supply Chain Management
• Request and Follow Up with Product Changes in Dynamics 365 Supply Chain Management
• Manage Changes in Formulas and Their Ingredients in Dynamics 365 Supply Chain Management

Module 6: Configure and Use Lean Manufacturing in Dynamics 365 Supply Chain Management

• Get Started with Production Control in Dynamics 365 Supply Chain Management
• Get Started with Lean Manufacturing in Dynamics 365 Supply Chain Management
• Configure Lean Manufacturing in Dynamics 365 Supply Chain Management
• Create and Process Fixed Kanbans in Dynamics 365 Supply Chain Management
• Create and Process Event Kanban Rules in Dynamics 365 Supply Chain Management
• Create and Process Scheduled Kanbans in Dynamics 365 Supply Chain Management
• Configure Activity-Based Subcontracting and Production Flow Costing in Dynamics 365 Supply Chain Management

Module 7: Use Warehouse Management in Manufacturing in Dynamics 365 Supply Chain Management

• Configure Warehouse Management in Dynamics 365 Supply Chain Management
• Warehouse Implementation Experience in Dynamics 365 Supply Chain Management
• Inbound Warehouse Operations Using Dynamics 365 Supply Chain Management
• Outbound Warehouse Operations Using Dynamics 365 Supply Chain Management
• Execute Across Warehouse Operations in Dynamics 365 Warehouse Management
• Warehouse Management Mobile Device Configuration Using Dynamics 365 Supply Chain Management
• Use Warehouse Management for Manufacturing in Dynamics 365 Supply Chain Management

Module 8: Configure Asset Management for Dynamics 365 Supply Chain Management

• Get Started with Asset Management for Dynamics 365 Supply Chain Management
• Set Up Functional Locations in Asset Management for Dynamics 365 Supply Chain Management
• Set Up Assets in Asset Management for Dynamics 365 Supply Chain Management
• Set Up Work Orders in Asset Management for Dynamics 365 Supply Chain Management
• Set Up Maintenance Requests in Asset Management for Dynamics 365 Supply Chain Management

Module 9: Work with Asset Management for Dynamics 365 Supply Chain Management

• Get Started with Asset Management for Dynamics 365 Supply Chain Management
• Work with Functional Locations in Asset Management for Dynamics 365 Supply Chain Management
• Work with Assets in Asset Management for Dynamics 365 Supply Chain Management
• Manage Maintenance Requests in Asset Management for Dynamics 365 Supply Chain Management
• Create and Manage Work Orders in Asset Management for Dynamics 365 Supply Chain Management
• Schedule Work Orders in Asset Management for Dynamics 365 Supply Chain Management
• Use Controls and Reports in Asset Management for Dynamics 365 Supply Chain Management
• Use Preventive and Reactive Maintenance in Asset Management for Dynamics 365 Supply Chain Management
• Work with Capacity Planning in Asset Management for Dynamics 365 Supply Chain Management
• Register and Report Consumption in Asset Management for Dynamics 365 Supply Chain Management
• Work with Warranties in Asset Management for Dynamics 365 Supply Chain Management
• Work with Maintenance Budgets in Asset Management for Dynamics 365 Supply Chain Management

Module 10: Configure and Manage Procurement and Vendors in Dynamics 365 Supply Chain Management

• Configure and Perform the Procure-to-Purchase Process in Dynamics 365 Supply Chain Management
• Configure and Manage Vendor Collaboration in Dynamics 365 Supply Chain Management
• Process Purchase Orders in Dynamics 365 Supply Chain Management
• Configure and Work with Quality Control and Quality Management in Dynamics 365 Supply Chain Management
• Configure and Use Agreements in Dynamics 365 Supply Chain Management
• Configure and Use Intercompany Trade in Dynamics 365 Supply Chain Management

Module 11: Configure and Manage Sales and Customers in Dynamics 365 Supply Chain Management

• Configure and Manage the Order to Cash Process in Dynamics 365 Supply Chain Management
• Configure and Use Agreements in Dynamics 365 Supply Chain Management
• Configure and Use Intercompany Trade in Dynamics 365 Supply Chain Management

Module 12: Master Planning in Dynamics 365 Supply Chain Management

• Configure and Use Built-In Master Planning in Dynamics 365 Supply Chain Management
• Use Planning Optimisation in Dynamics 365 Supply Chain Management
• Demand-Driven Material Requirements Planning in Dynamics 365 Supply Chain Management

Microsoft Loop Training Course Outline

Module 1: Introduction to Microsoft Loop

• What is Microsoft Loop?
• Evolution of Collaboration Tools
• Elements of Loop
• Copilot for Microsoft 365 in Loop

Module 2: Modern Co-Creation of Microsoft Loop App

• Organise Your Project
• Stay in Sync with Microsoft Loop
• Stay in Control with Notifications
• Stay in the Loop Across Devices
• Unlock New Possibilities with Copilot in Loop

Module 3: Microsoft Loop Components

• Microsoft Teams
• Outlook
• Word for the Web
• Whiteboard

Module 4:  Loop Access

• Loop for Work Accounts
• Loop App Public Preview Grace Period
• Loop and Microsoft storage
• Loop for Personal Accounts
• Loop and Microsoft Storage

Module 5: Manage Loop Workspace

• Requirements
  • License Requirements
  • WebSocket Connections
• Microsoft 365 Groups for Cloud Policy
  • Settings Management in the Microsoft Admin Center
  • Settings Management in Cloud Policy

Microsoft Clarity for Web Analysis Training Course Outline

Module 1: Introduction to Microsoft Clarity

• What is Clarity?
• Why Should I Use Clarity?
• How can Clarity help?
• Where can I Use Clarity?
• Installing Clarity

Module 2: Clarity for Mobile Apps

• Installation
• Heatmaps
• Session Recordings
• Insights Dashboard
• Filters
• Privacy
• SDK Changelog

Module 3: Clarity Live Extension – Plugin

• Clarity Features Dock
• How to Install the Extension?
• How to Use the Extension?

Module 4: Copilot in Clarity

• Overview
• Session Insights
• Heatmaps Insights
• Grouped Sessions Insights

Module 5: Heatmaps in Clarity

• What is a Heatmap?
• Heatmaps Features
• Click Maps
• Scroll Maps
• Area Maps
• Conversion Maps
• Heatmaps Compare
• Switch Screenshots
• Regular Expressions
• Sharing
• Download
• Troubleshooting Heatmaps

Module 6: Session Recordings in Clarity

• Recordings Dock
• Recordings Overview
• Session List
• Inline Player
• Clarity Labels
• Live Recordings
• Visitor Profile
• Sharing
• Download
• Troubleshooting Recordings

Module 7: Insights in Clarity

• Insights Dock
• Insights Overview
• Dashboard Overview
• Behavioural Insights Metrics
• E-commerce Insights
• Content Insights
• Sharing
• Download
• Troubleshooting Dashboard

Module 8: Microsoft Clarity Filters

• Filters Dock
• Filters Overview
• Exclusion Filters
• Custom Tags
• Path Filters
• Regular Expressions
• Segments