Course Code: ms365bspk
Duration: 7 hours
Prerequisites:
  • Attendees should have basic Office skills and Windows operating system knowledge

Other requirements:

  • Client should provide licensed Office 365 apps installed on a Windows 10 laptop
  • Client should prepare a trainer laptop and staff laptops with the required setup
  • All laptops should have Internet connectivity via customer-provided Wi-Fi or wired network
  • MIGROS-specific elements should be provided to the trainer for course material preparation
  • Course will be designed for English Office 365 apps on English Windows OS
Course Outline:

WORD:

Create And Manipulate Page Background

  • Add Watermark
  • Add Page Borders

Link document and database with Mail Merge

  • Creating Mail Merge with step by step wizard
  • Using button on Ribbon for Mail Merge
  • Mail Merge for creating labels and envelop

Manage Format With Styles by using MIGROS Template

  • Create Paragraph Style
  • Create Character Style
  • Create Table Style
  • Select All Text With Similar Formatting

OUTLOOK


Manage And Organizing E-Mail

  • Manage Mail Rules
  • Manage Mail By Using Outlook Rules
  • Create Automatic Reply Rules

Other Outlook Options

  • MIGROS Out of Office Assistant Regulation

Personal Calendar And Group Scheduling

  • Navigate The Calendar
  • Group Scheduling
  • Recurrence booking consideration
  • Categorize meeting by different color
  • Archiving Outlook Data

About Archiving Data

  • Enable & Disable AutoArchive
  • Run the Manual Archive

MIGROS Email Signature Regulation

  • Smart Tips for Outlook
  • How to add personal folder
  • How to search email by filters.
  • How to search big email

POWERPOINT

  • Manipulate SmartArt
  • Insert A SmartArt Diagrams
  • Add Text To A SmartArt Diagram
  • Add A Shape
  • Modify The SmartArt Diagram
  • Convert Selected Text To SmartArt Diagram
  • Convert Selected SmartArt Diagram To A Bulleted List
  • How to Use Migros Template
  • Things to Highlight on using Text
  • Footnote and auto-update data
  • Embed fonts in your presentation
  • Inserting External Data
  • Insert chart for presenting numerical data from Excel

TEAMS NEW FUNCTIONS 

  • Teams New Features in 2021 -2022
  • Teams Meeting with External Parties
  • How to check and fix the speaker, microphone and camera issues.

EXCEL

 Conditional Formatting

  • • Using Conditional Formatting
  • − Apply Conditional Formatting by using Quick Analysis
  • − Format cells by using data bars
  • − Format cells by using an icon set
  • − Format cells that contain text, number, or date or time values
  • − Format only top or bottom ranked values
  • − Format only values that are above or below average
  • − Format only unique or duplicate values
  • − Set up your own conditional formatting rule
  • − Use a formula to determine which cells to format
  • − Clear conditional formatting

 PivotTable

  • • PivotTable Fundamentals
  • − Introduce PivotTable
  • − Understand How The PivotTable Summarize Data
  • • Create A Basic PivotTable
  • − Clean Up Your Data Before Creating PivotTable
  • − Insert A PivotTable
  • − Understand Different Area In A PivotTable
  • − Add Fields Into PivotTable
  • − Extract Data For Each Summarized Entry
  • • Customize Fields In A PivotTable
  • − Change Summarizing Method On Data Field
  • − Change Number Format Of Data Field
  • − Create Running Total Or Other Representation
  • • Format Your PivotTable Report
  • − Change The Layout Of The PivotTable
  • − Apply Styles To The PivotTable

SHAREPOINT AND ONEDRIVE 

  • Portal (https://www.office.com/)
  • OneDrive and SharePoint Introduction
  • SharePoint Online Navigation
  • Organize and Manage Files and Information
  • Share and Collaborate
  • OneDrive Online Navigation
  • Organize and Manage Files and Information
  • Managing Desktop OneDrive Folder
  • Differences between OneNote for M365 and OneNote for Windows 10

MS FORMS:

  • personal form in office.com and “Forms for Excel” in SharePoint