Skip to content

St George’s library offers a host of IT training workshops to help staff and students develop their digital skills using Microsoft Office Desktop and Office 365. To reserve your place, please complete this booking form.

For those wanting self-directed learning, a range of videos with course materials are available to download or view online.

View all Close all
Introduction to Office 365

Office 365 includes many collaboration tools – such as Teams, OneNote and OneDrive and more. These tools allow you to communicate, brainstorm ideas, share documents and have Skype video meetings. Office 365 is free to all staff at St George’s.

In this workshop, you will get a hands-on introduction on how to:

  • access Office 365 from a browser

  • store and share files in OneDrive for Business

  • use Sway for interactive reports and newsletters

  • use Planner and Teams

  • use OneNote.

Who is this course for?

St George’s staff and students.

Duration

2 hours.

Office 365 – Microsoft Forms for surveys, quizzes and polls

Microsoft Forms provides you with the tools to create online surveys, quizzes, polls and plan events. Respondents can access the form using any web browser on any device. As the results are submitted, you can see them via the built-in analytics or download in Excel to analyse further.

You will learn how to:

  • adjust form settings

  • create various types of questions (options, Likert)

  • add branching logic according to how questions are answered

  • add/delete a logo or picture to the form or questions

  • add/delete video to questions

  • share your form for collaboration

  • allow various ways to assess your form

  • add a theme

  • check results and responses in Excel.

Who is this course for?

St George’s staff.

Duration

2 hours.

Office 365 – Microsoft Teams

A Microsoft team is a common workspace that provides central storage and collaboration space for documents, information and ideas. It helps groups of people share information and work together. For example, they can coordinate projects, discuss ideas and review documents.

You will learn how to:

  • understand Microsoft Teams

  • create your Microsoft team and add team members

  • set Microsoft team settings

  • create channels and tabs

  • add content to Microsoft Teams

  • move teams emails to Microsoft Teams

  • leave comments for members

  • understand Teams notifications

  • recover deleted teams and channels

  • archive content

  • how to add someone from outside the organisation as a guest

  • find guest options available in Teams

  • review what you have learned about Teams.

Who is this course for?

St George’s staff.

Duration

2 hours.

Office 365 – Microsoft Planner

Microsoft Planner is part of Microsoft Office 365 apps and integrates with Office applications, so you and your team can work collaboratively. Microsoft Planner allows you to create plans, assign tasks to your team and track the project’s progress from anywhere and on any device. It also provides a central place to share files, and gives visibility to the whole team. Each member will receive email notifications whenever they are assigned a new task or added to a conversation.

You will learn how to:

  • log on to Microsoft Planner

  • create a new plan

  • add tasks and checklist

  • attach files, photos or links

  • flag tasks with labels

  • update progress

  • set notifications for tasks and plans

  • view tasks on a calendar

  • use Planner for iOS and Android.

Who is this course for?

St George’s staff.

Office 365 – OneDrive

OneDrive for Business is a cloud-based file storage system with editing and collaboration tools. It allows you to store, share and sync files across different devices so you can access your files anytime and anywhere.

You will learn how to:

  • access OneDrive for Business

  • use the OneDrive screen

  • upload files

  • sync files

  • open files from OneDrive

  • create a new folder

  • edit OneDrive files

  • sort and filter files

  • share files in OneDrive

  • open a shared file in OneDrive

  • follow files

  • search in OneDrive

  • delete files and folders

  • use OneDrive for mobile devices.

Who is this course for?

St George’s staff.

Duration

2 hours.

Word fundamentals (basic)

Microsoft Word is the standard word-processing application used for typing various documents, so understanding how it works is essential. This course is hands-on, using the word processor to create documents and basic formatting.

You will learn how to:

  • work with fonts (entering, deleting, aligning and changing text)

  • navigate around a document

  • use find and replace

  • set margins

  • insert page numbers

  • adjust line spacing

  • use spelling and grammar checks

  • define text alignment

  • use bullets and numbering

  • use templates.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

Word: produce quick reports (intermediate)

You will be able to format, update and produce quick reports working with Word built-in styles. You will learn how to quickly create a table of contents, a list of figures and tables, and manage large documents in the navigation pane.

You will learn how to:

  • add page numbers

  • create landscape and portrait pages in one document

  • use and modify styles

  • generate a table of contents

  • label images and tables

  • generate a list of figures and tables

  • insert section breaks

  • insert columns

  • insert automatic chapter and subsection numbering

  • define headers and footers for different pages.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

Word: mail merge (intermediate)

Mail merging is the process of combining information from a Word document with information from another data file, for example Outlook, Excel or Access. Mail merge is used to create letters and labels. The data file contains the information that changes, such as the names and addresses of the people to whom you want to write or create a label for.

You will learn how to:

  • create a letter

  • preview your letters         

  • complete the merge

  • use Excel and Access as data sources

  • insert individual fields

  • prepare labels with images

  • close and save a file

  • use Word fields in mail merge

  • insert Word fields.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

Excel fundamentals

Excel fundamentals is aimed at those who have little or no knowledge of Excel, or who would like a refresher on basic features, as well as learning to apply some built-in Excel functions.

You will learn how to:

  • understand Excel terminology

  • enter, edit, select, copy, and move data

  • write simple formulas using plus +, minus -, multiply *, divide /

  • check calculation

  • use built-in functions sum, average, min and max

  • delete and insert columns and rows

  • create a chart.

Who is this course for?

St George’s and NHS staff.

Duration

2 ½ hours.

Excel: visualising data with charts (intermediate)

A chart is a visual representation of data and is used to compare trends and patterns in data. You can also use charts to compare set targets against actual achievements. Different scenarios require different types of charts.

You will learn how to:

  • understand the different chart types

  • update charts

  • chart non-sequential data

  • chart your data

  • format your chart using chart elements

  • plot time

  • add trend line and error bars

  • alter the scale

  • use sparklines to present data

  • save and customise charts to use again.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

Excel: conditional formatting and data validation (intermediate)

Data validation is about allowing you to dictate what can be entered into cells and make the worksheet as user-friendly as possible. Conditional formatting is applied selectively based on specific rules. This type of formatting allows you to see, for example, values that are over a certain amount or to instantly spot high and low values based on assigned colouring.

You will learn how to:

  • gain an understanding of conditional formatting

  • conditionally format cells containing specific data

  • clear conditional formatting

  • use cell formatting options

  • format the top 10 items in a range

  • use the various top/bottom rules

  • use the rules manager.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

Excel: filtering and advanced filtering of data (basic)

The filter function allows you to analyse information in a table by selecting rows that match a certain criteria or data. It can be used to help find a record, or to extract a subset of records that you can edit, format, copy, move, chart or manipulate without affecting the other records.

You will learn how to:

  • gain an understanding of filtering

  • apply and use a filter

  • clear a filter

  • create a compound filter

  • filter for multiple values

  • create custom filters

  • use wildcards in custom filters

  • extract records and paste them in another location.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

Excel: using VLOOKUP and HLOOKUP (intermediate)

The lookup functions are used to search and extract data from a large list or table in worksheets using formulas. It can be used for a variety of purposes, such as to answer questions, extract data or perform calculations on specific values.

You will learn how to:

  • search and return a name, item or details based on an identifier in a table

  • return approximate data from a list

  • return an exact match from a list

  • use the =IFERROR function with lookups

  • merge two or more tables

  • return the correct data for combined values in a list.

Who is this course for?

St George’s and NHS staff.

Duration

2 ½ hours.

Excel: pivot tables (intermediate)

A pivot table is a way to extract data from a long list of information and present it in a readable form. Pivot tables can be used to summarise, analyse, explore and present your data in both tables and charts.

You will learn how to:

  • organise your source data

  • use Excel tables

  • create a pivot table

  • use pivot table techniques

  • select elements of a pivot table.

Who is this course for?

St George’s and NHS staff.

Duration

2 ½ hours.

Excel: formatting cells and ranges (basic)

Excel provides many different tools to help you layout your spreadsheets for easier understanding. Applying formatting can draw the eye to important information and give it a professional look.

You will learn how to:

  • insert and delete cells

  • modify cell alignment and indentation

  • change font styles

  • apply number formats

  • wrap text within cells

  • merge cells

  • apply borders

  • use format painter

  • apply cell styles

  • insert hyperlinks.

Who is this course for?

St George’s and NHS staff.

Duration

2 ½ hours.

PowerPoint essentials

If you want to produce professional and exciting presentations, this enjoyable and extremely useful introduction workshop is for you.

You will learn how to:

  • create slides using design templates

  • incorporate images into your presentation

  • use the drawing tools

  • use animation effects

  • print slides

  • view your presentation.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

PowerPoint: making interactive slideshows (intermediate)

Presentations are much more than words; adding the appropriate animation and graphics to your slide with sound, music or video clips can create the impact needed.

You will learn how to:

  • understand PowerPoint media tools

  • insert an online video

  • insert an audio clip

  • format your slideshow

  • edit audio clips

  • optimise and compress media

  • insert hyperlinks

  • insert action buttons

  • make interactive, non-linear slideshows.

Who is this course for?

St George’s and NHS staff.

Duration

2 hours.

 

Find a profileSearch by A-Z