Microsoft 365 Training - Iceland

Manage Microsoft MS700 Teams 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 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

Microsoft PowerPoint MO300​ Training Course Outline

Module 1: Manage Presentations

• Work with Slide Masters and Views

• Modify Slide Master Content and Layouts
• Change the Slide Master Theme or Background
• Use Notes Master and Handout Master

• Presentation Setup and Delivery

• Change Slide Size and Views
• Set Basic File Properties
• Use Presenter View and Rehearse Timings

• Print and Export Presentations

• Print Slides, Notes Pages, and Handouts
• Print in Colour, Grayscale, or B/W
• Export to PDF, Video (MP4)

Module 2: Manage Slides and Layouts

• Insert and Modify Slides

• Add Slides with Layouts
• Duplicate, Hide, or Delete Slides
• Use Slide Zoom and Summary Zoom

• Organise Slides

• Create and Rename Sections
• Reorder Slides Easily
• Apply Backgrounds to Individual Slides

Module 3: Work with Text, Shapes, and Images

• Text Formatting Essentials

• Apply Text Styles and Columns
• Use Bulleted and Numbered Lists

• Insert and Format Visual Elements

• Insert Shapes, Text Boxes, and Images
• Resize, Crop, and Style Images
• Use Smart Guides and Alignment Tools

• Group and Arrange Elements

• Align and Group Objects
• Use Selection and Format Pane

Module 4: Use Charts, SmartArt, Media, and 3D Models

• Insert Data Visuals

• Create and Modify Tables and Charts
• Apply Built-In Styles

• SmartArt and 3D Models

• Convert Lists to SmartArt
• Insert and Resize 3D Models

• Media and Screen Recording

• Insert Audio/Video
• Configure Playback Options

Module 5: Add Transitions, Animations, and Final Touches

• Transitions and Animations

• Apply Slide Transitions
• Animate Text and Objects
• Use Animation Pane and Timings

• Final Enhancements and Collaboration

• Add Hyperlinks and Zoom Links
• Add Comments and Mark as Final

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 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
• Pivot Charts
• 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

• Introduction
• Explore Microsoft 365 Environment
• Configure Organisational Profile
• Manage Tenant Subscriptions
• Integrate with Customer Engagement Apps
• Configure Sharing Settings for SharePoint and OneDrive
• Configure Settings for Microsoft Teams
• Enable Unified Audit Logging
• Complete Tenant Configuration

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

• Introduction
• Determine User Identity Model
• Create User Accounts
• Manage User Account Settings
• Manage User Licenses
• Recover Deleted User Accounts
• Perform Bulk User Maintenance
• Create and Manage Guest Users
• Collaborate with Guests in SharePoint
• Create and Manage Contacts

Module 3: Manage Groups in Microsoft 365

• Introduction
• Examine Groups
• Create and Manage Groups
• Create Dynamic Groups
• Create Group Naming Policy
• Create Groups in Exchange and SharePoint

Module 4: Add a Custom Domain in Microsoft 365

• Introduction
• Plan a Custom Domain
• Plan DNS Zones
• Plan DNS Record Requirements
• Create a Custom Domain

Module 5: Configure Client Connectivity to Microsoft 365

• Introduction
• Examine Automatic Client Configuration
• Explore DNS Records for Client Configuration
• Configure Outlook Clients
• Troubleshoot Client Connectivity

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

• Introduction
• Examine Roles in Permission Model
• Manage Roles Across the Ecosystem
• Explore Administrator Roles
• Examine Best Practices for Roles
• Assign Admin Roles to Users
• Delegate Admin Roles to Partners
• Implement Role Groups
• Manage Permissions Using Administrative Units
• Manage SharePoint Permissions
• Elevate Privileges Using Privileged Identity Management

Module 7: Manage Tenant Health and Services in Microsoft 365

• Introduction
• Monitor Microsoft 365 Services Health
• Monitor Tenant Health Using Adoption Score
• Monitor Tenant Health Using Usage Analytics
• Implement Network Connectivity Assessments and Insights
• Implement Microsoft 365 Backup
• Develop an Incident Response Plan
• Request Assistance from Microsoft

Module 8: Deploy Microsoft 365 Apps for Enterprise

• Introduction
• Explore Apps for Enterprise Functionality
• Complete Self-Service Installation
• Deploy with Configuration Manager
• Deploy from the Cloud
• Deploy from a Local Source
• Manage Updates
• Explore Update Channels
• Manage Cloud Apps Using Admin Centre
• Add Apps to Microsoft Intune
• Deploy Security Baseline

Module 9: Analyse Workplace Data Using Microsoft Viva Insights

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

Module 10: Explore Identity Synchronisation

• Introduction
• Examine Identity Models
• Examine Authentication Options for Hybrid Identity
• Explore Directory Synchronisation

Module 11: Prepare for Identity Synchronisation to Microsoft 365

• Introduction
• Plan Microsoft Entra ID Deployment
• Prepare for Directory Synchronisation
• Choose Synchronisation Tool
• Plan for Synchronisation Using Entra Connect Sync
• Plan for Synchronisation Using Entra Cloud Sync

Module 12: Implement Directory Synchronisation Tools

• Introduction
• Configure Entra Connect Sync Prerequisites
• Configure Entra Connect Sync
• Monitor Services Using Entra Connect Health
• Configure Entra Cloud Sync Prerequisites
• Configure Entra Cloud Sync

Module 13: Manage Synchronised Identities

• Introduction
• Manage Users with Synchronisation
• Manage Groups with Synchronisation
• Maintain Synchronisation Using Security Groups
• Configure Object Filters for Synchronisation
• Explore Microsoft Identity Manager
• Troubleshoot Synchronisation

Module 14: Examine Threat Vectors and Data Breaches

• Introduction
• Explore Today's Threat Landscape
• Examine Phishing Tactics
• Examine Spoofing Tactics
• Compare Spam and Malware
• Examine Account Breaches
• Examine Privilege Elevation Attacks
• Examine Data Exfiltration
• Examine Data Deletion
• Examine Data Spillage
• Examine Other Attacks

Module 15: Explore the Zero Trust Security Model

• Introduction
• Examine Zero Trust Principles and Components
• Plan for Zero Trust Model
• Examine Microsoft's Zero Trust Strategy
• Adopt Zero Trust Approach

Module 16: Manage Secure User Access in Microsoft 365

• Introduction
• Examine Identity and Access Tools
• Manage User Passwords
• Implement Conditional Access Policies
• Enable Pass-through Authentication
• Implement Multifactor Authentication
• Explore Password less Options
• Explore Self-Service Password Management
• Implement Smart Lockout
• Explore Security Defaults
• Investigate Sign-in Issues

Module 17: Explore Security Solutions in Microsoft Defender XDR

• Introduction
• Enhance Exchange Protection
• Protect Identities Using Defender for Identity
• Protect Networks Using Defender for Endpoint
• Protect Against Cyber Attacks
• Provide Suspicious Activity Insights
• Review Security Reports

Module 18: Examine Microsoft Secure Score

• Introduction
• Explore Secure Score
• Assess Security Posture
• Improve Secure Score
• Track Secure Score History and Goals

Module 19: Examine Privileged Identity Management

• Introduction
• Explore Privileged Identity Management
• Configure Privileged Management
• Audit Privileged Management

Module 20: Examine Microsoft Entra ID Protection

• Introduction
• Explore ID Protection
• Enable Default Protection Policies
• Explore Detected Vulnerabilities and Risks
• Plan Identity Investigation

Module 21: Examine Email Protection

• Introduction
• Implement Anti-malware Policies
• Implement Anti-spam Policies
• Detect Spam or Malware Using Auto Purge
• Explore Anti-spoofing in Exchange Protection
• Explore Other Anti-Spoofing Measures
• Examine Outbound Spam Filtering

Module 22: Enhance Email Protection Using Defender for Office 365

• Introduction
• Transition to Defender for Office 365
• Expand EOP Protections
• Manage Spoofed Intelligence
• Configure Outbound Spam Policies
• Manage Email Access
• Submit Analysis Requests to Microsoft

Module 23: Manage Safe Attachments

• Introduction
• Protect Users from Malicious Attachments
• Create Safe Attachment Policies
• Create Policies Using PowerShell
• Modify Existing Policies
• Create Bypass Transport Rule
• Examine End-User Experience

Module 24: Manage Safe Links

• Introduction
• Protect Users from Malicious URLs
• Create Safe Links Policies
• Create Policies Using PowerShell
• Modify Existing Policies
• Create Bypass Transport Rule
• Examine End-User Experience

Module 25: Explore Threat Intelligence in Microsoft Defender XDR

• Introduction
• Explore Intelligent Security Graph
• Explore Alert Policies
• Run Automated Investigations
• Explore Threat Hunting
• Explore Advanced Threat Hunting
• Explore Threat Analytics
• Identify Issues Using Reports

Module 26: Implement App Protection Using Defender for Cloud Apps

• Introduction
• Explore Defender Cloud Apps
• Deploy Defender for Cloud Apps
• Configure File Policies
• Manage and Respond to Alerts
• Configure Cloud Discovery
• Troubleshoot Cloud Discovery

Module 27: Implement Endpoint Protection Using Defender for Endpoint

• Introduction
• Explore Defender for Endpoint
• Configure in Microsoft Intune
• Onboard Devices
• Manage Endpoint Vulnerabilities
• Manage Device Discovery
• Reduce Threat and Vulnerability Exposure

Module 28: Implement Threat Protection Using Defender for Office 365

• Introduction
• Explore Protection Stack
• Examine Security Policies and Rules
• Investigate Attacks Using Threat Explorer
• Identify Issues Using Threat Trackers
• Prepare with Attack Simulation Training

Module 29: Examine Data Governance Solutions in Microsoft Purview

• Introduction
• Explore Data Governance and Compliance
• Protect Sensitive Data
• Govern Organisational Data
• Minimise Insider Risks
• Explore eDiscovery Solutions

Module 30: Explore Data Management Practices

• Introduction
• Explore Archive Mailboxes
• Enable Archive Mailboxes
• Restore Data in Exchange Online
• Restore Data in SharePoint Online

Module 31: Explore Retention

• Introduction
• Explore Retention Policies and Labels
• Compare Retention Capabilities
• Define Retention Scope
• Examine Retention Principles
• Implement Retention Measures
• Restrict Retention Changes

Module 32: Explore Compliance

• Introduction
• Plan for Security and Compliance
• Plan Beginning Compliance Tasks
• Manage Compliance Requirements
• Examine Compliance Manager Dashboard
• Analyse Compliance Score

Module 33: Implement Insider Risk Management

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

Module 34: Implement Information Barriers

• Introduction
• Explore Information Barriers
• Configure Information Barriers
• Examine Barriers in Microsoft Teams
• Examine Barriers in OneDrive
• Examine Barriers in SharePoint

Module 35: Explore Data Loss Prevention

• Introduction
• Examine Prevention for Workloads
• Examine Policies
• Explore Endpoint Prevention
• Explore Adaptive Protection
• View Policy Results

Module 36: Implement Data Loss Prevention

• Introduction
• Plan to Implement Data Loss Protection
• Implement Default DLP Policies
• Design Custom DLP Policy
• Create Custom Policy from Template
• Configure Email Notifications
• Configure Policy Tips

Module 37: Implement Data Classification of Sensitive Information

• Introduction
• Explore Data Classification
• Implement Classification in Microsoft 365
• Explore Trainable Classifiers
• Create and Retrain Classifier
• View Sensitive Data
• Detect Sensitive Documents

Module 38: Explore Sensitivity Labels

• Introduction
• Manage Data Protection Using Labels
• Explore Label Capabilities
• Determine Label Scope
• Apply Labels Automatically
• Explore Label Policies

Module 39: Implement Sensitivity Labels

• Introduction
• Plan Deployment Strategy
• Enable Labels for Files in SharePoint and OneDrive
• Examine Requirements to Create a Label
• Create Labels
• Publish Labels
• Remove and Delete 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

• Introduction to Microsoft Project
• Starting a Project
• Exploring the Microsoft Project Environment

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
• Splitting Tasks
• Using the Task Inspector

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
• Understanding Baseline and Interim Plans
• Exercise: Setting Additional Baselines
• Analysing Project Costs 

Module 4: Formatting and Customising Views

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

Module 5: Reporting

• Creating Visual Reports
• Editing Reports

Module 6: Working with Templates

• Using Subproject within a Project
• Using Organiser and Project 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

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 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

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 Certified Dynamics 365 Supply Chain Management Functional Consultant Expert Training Course Outline

Module 1: Get Started with Dynamics 365 Supply Chain Management

• Introduction
• Benefits of Supply Chain Management
• Overview of Supply Chain Management
• Cost Accounting
• Cost Management
• Inventory and Warehouse Management
• Master Planning
• Procurement and Sourcing
• Vendor Collaboration
• Sales and Marketing
• Customer Portal
• Product Information Management
• Production Control
• Intercompany Trade
• Warehouse Management
• Transportation Management
• Lab - Explore Dynamics 365 Supply Chain Management

Module 2: Get Started with Inventory Management in Dynamics 365 Supply Chain Management

• Introduction
• Inventory Management Overview
• Configure Inventory Dimensions
• Configure Storage Dimensions
• Configure Tracking Dimensions
• Configure Serial and Batch Numbers
• Configure Sites
• Configure Warehouses
• Configure Inventory Policies
• Exercise - Set up Inventory Policies for an Item Model Group
• Set up Item Groups and Item Model Groups
• Allocate Batch and Serial Numbers
• Work with Consignment Inventory
• Lab - Work with Inventory Management

Module 3: Work with Inventory Management Operations in Dynamics 365 Supply Chain Management

• Introduction
• Inventory Operations Scenarios
• Inventory Locations
• Inventory Statuses
• Set up Disposition Codes
• Warehouse Layout
• Set up Barcodes
• Counting Reason Codes
• Inventory Journals
• Inventory Journal Approval Workflow
• Initialise Stock Levels in the Warehouse
• Transfer Orders
• Create and Post an Inventory Journal
• Exercise- Create and Post an Inventory Journal

Module 4: Set up and Work with Outbound Operations Using Inventory Management in Dynamics 365 Supply Chain Management

• Introduction
• Outbound Operations
• Outbound Setup
• Set up Default Order Settings
• Reserve Inventory Quantities
• Reserve Sales Order Batch Numbers

Module 5: Set up and Work with Inbound Operations Using Inventory Management in Dynamics 365 Supply Chain Management

• Introduction
• Inbound Operations
• Arrival Overview
• Set up an Item Arrival Overview Profile
• Set up Default Order Settings
• Exercise - Use the Item Arrival Profile

Module 6: Set up and Work with Inventory Control in Dynamics 365 Supply Chain Management

• Introduction
• Inventory Cost Methodologies
• Inventory Closing and Adjustment
• Consolidate Inventory Transactions

Module 7: Use Inventory Reports in Dynamics 365 Supply Chain Management

• Introduction
• ABC Inventory Classification
• Physical Inventory by Inventory Dimension Report
• Inventory Value Report
• Inventory On-Hand Report Storage
• Inventory On-Hand Mobile Workspace
• Exercise - Use the ABC Classification Report
• Exercise - Use the Physical Inventory by Inventory Dimension Report
• Exercise - Export a Report to Microsoft Excel

Module 8: Create Products and Product Masters 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 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 9: 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 10: 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 11: 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 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 12: Set Up and Use Production Control for Discrete Manufacturing in Dynamics 365 Supply Chain Management

• Introduction
• Prerequisite Setup in Production Control
• Production Groups
• Production Control Parameters
• Production Pools
• Allocation Keys
• Set Up Journal Parameters
• Create a Production Unit

Module 13: Set Up and Use Discrete Manufacturing Routes in Dynamics 365 Supply Chain Management

• Introduction
• Create Operations and Operation Relations
• Work with Simultaneous Operations
• Set Up Route Groups and Routes
• Route Versions
• Copy Routes
• Route Networks
• Work with Primary and Secondary Routes
• Exercise - Set Up Operations and Routes

Module 14: Set Up and Use Discrete Manufacturing Resources in Dynamics 365 Supply Chain Management

• Introduction
• Set Up Calendars and Resources
• Set Up Working Time Templates
• Create Calendars
• Resource Capabilities
• Resource Groups

Module 15: Set Up Products for Production for Discrete Manufacturing in Dynamics 365 Supply Chain Management

• Introduction
• Set Up Inventory Dimensions in Production
• Set Up Production Dimensions
• Set Up Storage Dimensions
• Set Up Tracking Dimensions

Module 16: Production Costing for Discrete Manufacturing in Dynamics 365 Supply Chain Management

• Introduction
• Production Cost
• General Ledger and Manufacturing Integration
• Inventory Posting Profiles, Item Groups, and Item Model Groups
• End Production Orders
• Production Journals
• Dimension Link
• Production Reports

Module 17: 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 - Analyse BOM Costs Using the Costing Sheet

Module 18: 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 19: Work with Manufacturing Execution in Dynamics 365 Supply Chain Management

• Introduction
• Understand 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 20: 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 21: 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
• Reuse Product Configuration

Module 22: 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 23: 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 24: 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 25: 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 - Create Co-products and By-products
• Exercise - Create a New Formula with a Version from the Released Products Page
• 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

Module 26: 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 Using Quality Orders
• Exercise - Reserve Batch Attributes on Sales Orders

Module 27: Work with Commodity Pricing and Compliance 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 Using Quality Orders
• Exercise - Reserve Batch Attributes on Sales Orders

Module 28: 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 Using an Engineering Change Order
• Exercise - Release the Changed Product

Module 29: Set Up Versioned Products in Dynamics 365 Supply Chain Management

• Introduction
• Create an Engineering Organisation
• Create Nomenclature for Product Versions
• Create Product Version Number Rules
• Create Product Dimension Groups 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 30: 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 31: Convert an Existing Product to an Engineering Product in Dynamics 365 Supply Chain Management

• Introduction
• Enable Change Management on Existing Products
• Enable Engineering Product Categories
• Run the Convert to Engineering Product Wizard

Module 32: 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 Using an Engineering Change Order
• Exercise - Release the Changed Product

Module 33: Manage a Discrete Product BOM and Route for Versioned Products in Dynamics 365 Supply Chain Management

• Introduction
• Create a New Engineering Product
• Set Up a Product Version BOM
• Set Up a Product Version Route
• Release the Product to Operational Companies
• Review and Accept the Product Before Release
• Change a Life Cycle State and Use a Product in Transactions
• Use Readiness Checks
• Exercise - Create and Release an Engineering Product

Module 34: 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 35: Manage Changes in Formulas and Their Ingredients in Dynamics 365 Supply Chain Management

• Introduction
• Engineering Change Management
• Centralised Product Data Management
• Product Versioning
• Formula Lines and Versioning
• Product Life Cycle Management
• Formula Management Process
• Formula Change Management
• Evaluate Business Impact of a Change Request and Send Notifications
• Engineering Change Orders
• Readiness Control
• Enhanced Product Release Functionality
• Introduction
• Roles in Warehouse Management
• Set Up Warehouse Management
• Configure the Warehouse Layout
• Configure Catch Weight Processing
• Warehouse Processes
• Reservation Hierarchies
• Lab - Configure Warehouse 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

Transform Ideas into Action with Copilot Chat 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: Synthesise 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