Microsoft Word Intermediate

Course overview

Once you’ve acquired the knowledge of the basics of Word you now need to become more productive and efficient with the creation and maintenance of your documents. You will learn how to use collaborative editing tools, include media, images and tables and learn how to merge documents and track changes.

Topics covered

Themes & styles

  • Create, apply and modify a style
  • New quick style sets
  • Apply and save document themes
  • Document themes, colours & fonts
  • Compare/clean up styles
  • Select, print and remove styles
  • New fonts and theme colours
  • Styles gallery

Shapes, pictures and art

  • Clip art, pictures and graphics
  • Remove a picture’s background
  • Positioning
  • Special effects
  • Inserting/formatting shapes
  • Inserting a text box
  • Inserting/formatting smart art
  • Formatting chart elements
  • Working with labels
  • Chart templates and type

Working with tables

  • Create and adjust a table
  • Add borders and shading
  • Table styles and table style options
  • Row height and column width
  • Cell formatting
  • Insert/delete columns and rows
  • Sorting and formulas
  • Table drawing tools

Formatting & collaborative editing

  • Section breaks and line numbers
  • Hyphenation
  • Insert a section break
  • Page background and cover page
  • Tracking revisions
  • Accept, reject and track revisions
  • Using comments comparing
  • Combine documents
  • Protect a document Password protect a document

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

Course overview

Once you know the basics of Excel this course aims to give you the knowledge to be able to use more advanced logical formulas including lookups to find, extract and compare data. You will be able to organise your data in tables, before learning how to evaluate it with advanced filtering techniques. You will also learn how to get started with Pivot Tables and present your data as charts.

Topics covered

Recap exercise on Absolute Cell Referencing

Working with tables

  • Creating a table
  • Adding and removing data
  • Working with the total row
  • Sorting a table
  • Filtering a table
  • Removing duplicate rows of data
  • Formatting the table
  • Using data validation
  • Converting to a range

Managing workbooks

  • Using workbook views
  • Selecting and switching between worksheets
  • Inserting and deleting worksheets
  • Creating headers and footers
  • Hiding rows, columns, worksheets, and windows
  • Setting the print area
  • Printing a selection, multiple worksheets, and workbooks
  • Creating a template
  • Protecting a workbook
  • Working with data ranges

Working with pivot tables

  • Creating a pivot table
  • Specifying pivot table data
  • Changing a pivot table’s calculation
  • Working with pivot table layout
  • Grouping pivot table items
  • Updating a pivot table
  • Creating a pivot chart
  • Using slicers

Getting started with worksheets

  • Choosing and selecting the source data
  • Choosing the right chart
  • Inserting a chart
  • Editing, adding, and removing chart data
  • Changing chart data
  • Using sparklines

More functions & formulas

  • Formulas with multiple operators
  • Inserting and editing a function
  • AutoCalculate and manual calculation
  • Defining names
  • Using and managing defined names
  • Displaying and tracing formulas
  • Understanding formula errors
  • Using logical and lookup functions such as IF and VLOOKUP

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

Course overview

Now that your delegates have mastered the basics it is time to move on and create more advanced presentations and slides. They will learn to customise themes, create custom templates, modify videos and use multiple slide masters along with a variety of tools and layouts.

Topics covered

Formatting and pictures

  • Change font, size and colour
  • Apply text effects
  • Change the case
  • Align text
  • Copy formatting
  • Add multiple columns
  • Change a picture
  • Artistic effects
  • Compress a picture
  • Format painter

Enhance content and modify

  • Linking to Excel
  • 3D models
  • Create custom shapes
  • Convert smart art to shapes
  • Modify video
  • Record audio
  • Video and audio options

Slide master, templates and themes

  • Themes and templates
  • Create custom layouts
  • Work with slide masters
  • View current layouts
  • Edit a slide master
  • Use a template
  • Custom templates
  • Theme colours and fonts
  • Background styles
  • Custom themes

Animations and tables

  • Animate text
  • Animate objects
  • Using the animation painter
  • Reorder animations
  • Insert a table
  • Format a table
  • Import a table
  • Add rows and columns
  • Advanced picture corrections

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 Intermediate

Course overview

The Intermediate level course allows your delegates to increase their technical knowledge on the core concepts and functionality of Outlook. They will learn additional email features, how to use the calendar, journals and notes and how to organise and find information.

Topics covered

Using the calendar

  • Viewing and navigating
  • Changing view
  • Setting reminders
  • Schedule appointments/events
  • Editing appointments/events
  • Recurring appointments
  • Categorise appointments
  • Availability
  • Shared calendars
  • Changing work days/times
  • Colour coding

Working with contacts and other users

  • Address book
  • Adding and viewing contacts
  • Sorting, editing and deleting contacts
  • Contact window
  • Contact Groups
  • Categorise your contacts
  • Share contacts
  • Print contact list

Working with tasks

  • Create and modify tasks
  • Task views and displays
  • Sorting and assigning tasks
  • Recurring tasks
  • Attachments
  • Task pane
  • Create appointments
  • Completing a task
  • Printing tasks
  • Classic vs to do

Additional Email Features

  • Recalling an email
  • Delaying an email
  • Quick steps
  • Changing the message format
  • Junk email
  • Safe and blocked senders
  • Security settings
  • Create and edit rules Working with Sensitive emails

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 Intermediate

Course overview

This course is designed to elevate your delegates understanding of SharePoint, as basic working knowledge is required to attend this course. Delegates will learn to create sites and site designs, understand metadata and security and how to create and manage site pages.

Topics covered

Personalisation

  • Editing pages
  • Connecting
  • Customisation
  • Shared and personal pages
  • Web part gallery options
  • Information and web page customization
  • Promoting a page
  • Page analytics

Metadata

  • Understanding metadata
  • Managed metadata
  • Term Store Groups
  • Permissions
  • Folders vs metadata

SharePoint administration

  • SharePoint pitstop
  • SharePoint use cases
  • Site templates
  • What’s new
  • Microsoft 365 roadmap
  • SharePoint Intrazone

Site permissions

  • SharePoint permission structure
  • Permission groups
  • Use access
  • Users in a Team Site
  • Unique permissions
  • Remove permission
  • Levels

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