Microsoft Copilot Introduction

Course overview

Microsoft Copilot is the new AI assistant, aimed at enhancing user productivity within Microsoft 365. Delegates will learn the basics of how Copilot works and then dive deeper into individual applications to showcase its range of functionality across the 365 applications.

Topics covered

The fundamentals of Copilot

  • What is Microsoft 365 Copilot?
  • The key features of Copilot
  • How to access Copilot
  • The semantic index
  • How does Microsoft 365 Copilot work?
  • Copilot capabilities

Working with Copilot in Word

  • Draft and add content
  • Transform your content
  • Chat with Copilot
  • Create a summary

Working with Copilot in PowerPoint

  • Create presentations
  • Add a slide or image to your presentation
  • Summarise your presentation
  • Organise your presentation

Working with Copilot in Excel

  • Identify insights
  • Highlight sort and filter your data
  • Generate formula columns

Working with Copilot in Outlook

  • Draft an email message
  • Summarise an email thread
  • Suggested drafts
  • Use Copilot to schedule calendar entries

Working with Copilot in Teams

  • Summarise unread messages from
    individuals, channels or Teams

Delivery methodology

(Face-to-face or virtual delivery available)

Small groups

Ideally 6-8 delegates to maximise engagement and interaction levels.

One-to-one

We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).

Tailored sessions

Talk to us about designing bespoke workshops for your team

Microsoft Outlook Basic

Course overview

Our basic course is ideal for delegates with little or no experience of Outlook. The course will begin with the fundamentals such as navigating the system, move through creating, sending and receiving emails and will also cover additional features such as out of office and Outlook options.

Topics covered

Fundamentals

  • Starting Outlook
  • Control screen layout
  • The message window
  • Navigation pane
  • Reading pane and to-do bar
  • Giving commands/command shortcuts
  • Help
  • Understanding items
  • Locating emails

Receiving e-mail

  • Receiving/reading email
  • Opening attachments
  • Changing views
  • Flagging for follow up
  • Printing an email
  • Reply and forward
  • Junk and unwanted email

Creating and sending e-mails

  • Composing an email
  • Format text tips
  • Spellcheck
  • Hyperlinks
  • Message options
  • Attachments
  • Sending an email
  • Use @ mentions

Additional features

  • Saving drafts
  • Out of office
  • Signatures and fonts
  • Themes and stationary
  • Outlook options
  • Quick flags Recover deleted items

Delivery methodology

(Face-to-face or virtual delivery available)

Small groups

Ideally 6-8 delegates to maximise engagement and interaction levels.

One-to-one

We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).

Tailored sessions

Talk to us about designing bespoke workshops for your team

Microsoft SharePoint Basic

Course overview

Our Microsoft SharePoint course will provide your delegate with the basic skills required to navigate the system, understand the components, site roles and essential functionalities required for team collaboration and management of documents.

Topics covered

Fundamentals

  • Overview of sharePoint
  • Key features & terminology
  • Changing the look
  • Site settings
  • Hub sites
  • Associated sites
  • Guided activities

Library and list apps

  • Understanding library apps
  • Link to documents
  • Adding/amending columns
  • Sorting and grouping data
  • SharePoint lists
  • Adding and editing
  • Deleting and restoring

Customisation and integration

  • Site settings as an owner
  • Site collection administration
  • Office 365 sharePoint admin
  • SharePoint & MS Teams
  • One Drive
  • Excel lists
  • Creating team sites
  • Creating communication sites

Views and content

  • Introduction
  • Personal and public views
  • Customisation
  • Alerts and notifications
  • Check in/Check out
  • Document versioning

Delivery methodology

(Face-to-face or virtual delivery available)

Small groups

Ideally 6-8 delegates to maximise engagement and interaction levels.

One-to-one

We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).

Tailored sessions

Talk to us about designing bespoke workshops for your team

Microsoft Access Basic

Course overview

This course is aimed at the new user and aims to provide the knowledge and confidence to create and amend Access databases, input forms, produce basic reports and manipulate data. Throughout the workshop you are encouraged to explore the software to enhance common errors and how to diagnose them.

Topics covered

Fundamentals

  • Getting started
  • Database terminology
  • Access screen tour
  • Access objects
  • Creating a blank database
  • Create from a template
  • Ribbon menu
  • Working with a window
  • Getting help

Queries

  • Locate specific records
  • Creating and running queries
  • Finding information
  • Create query joins
  • Parameter queries
  • Multi table queries Refining results

Tables

  • Add/edit tables
  • Data entry
  • Design and working mode
  • Filtering/sorting information
  • Modifying
  • Primary and foreign keys
  • Input masks
  • Indexed and data types

Forms and reports

  • Create a form/report
  • Modify and design
  • View and edit
  • Moving, deleting and resizing
  • Formatting controls
  • Prepare to print
  • Enhance the appearance

Delivery methodology

(Face-to-face or virtual delivery available)

Small groups

Ideally 6-8 delegates to maximise engagement and interaction levels.

One-to-one

We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).

Tailored sessions

Talk to us about designing bespoke workshops for your team

Microsoft PowerApps

Course overview

Part of the Microsoft Power Platform, Microsoft PowerApps allows you to create Modern Applications for Data Capture and Data Analysis using a straightforward user interface design studio. PowerApps can be connected to over 250 data connections including SharePoint, SQL, OneDrive, Excel, Salesforce, Oracle and more.

Topics covered

Fundamentals

  • What is Microsoft PowerApps
  • Licensing requirements
  • PowerApp types
  • Environments
  • Data connections

Building custom forms in SharePoint

  • Understanding custom forms in SharePoint
  • Opening the custom form designer
  • Form settings / screens
  • Using Forms
  • Using images, icons and shapes
  • Grouping and renaming objects
  • Using formulas in PowerApps
  • Saving and publishing
  • Form settings and version history

Option to add in more Advanced content including

  • Tables
  • Forms and dashboards
  • Connecting apps to different data sources
  • Chat Bot/Mixed reality apps

Building a canvas app

  • Canvas app layouts
  • Creating a Canvas app from existing data connection and an existing app template
  • Creating a canvas app from a blank template – sizes and resolutions
  • App themes / buttons and navigation /components / galleries
  • Conditional formatting
  • Save and publish / sharing canvas apps

Using a canvas app

  • How to begin to use a canvas app
  • Using canvas apps in SharePoint using Webparts
  • Using canvas apps in Microsoft Teams Using canvas apps on mobile and tablets

Delivery methodology

(Face-to-face or virtual delivery available)

Small groups

Ideally 6-8 delegates to maximise engagement and interaction levels.

One-to-one

We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).

Tailored sessions

Talk to us about designing bespoke workshops for your team