Skip to content

St George’s library offers a host of IT training workshops to help staff develop their digital skills using Microsoft Office Desktop and Office 365. Click below to see the contents and to book a workshop.

For 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 Planner and Teams
  • Use OneNote
  • How to download Office apps
Who is this course for?

St George’s and NHS staff

Duration   2 hours

Date and Time
 Monday 24 Feburary 2020  11 - 1 pm
 Tuesday 10 March 2020  2 -  4 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Office 365 – Create an on-line Survey or Quiz
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 and NHS staff

Duration  2  hours

Date and Time
Tuesday 11 February 2020   11 - 1pm
Thursday 02 April 2020     11 -  1 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

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:

  • 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
  • Leaving comments for members
  • Understand Teams Notifications
Who is this course for?

St George’s and NHS staff

Duration 2 hours

Date and Time
Thursday 06 February 2020         2 – 4 pm
 Monday 23 March 2020                      11 -  1 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

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
  • Search in OneDrive
  • Delete files and folders
Who is this course for?

St George’s and NHS staff

Duration 2 hours

Date and Time
Monday 24 February 2020  11 – 1 pm

Tuesday 10 March 2020 

2 -  4 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

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 .5 hours

Date and Time
 Tuesday 17 March 2020  2:00 - 4:30 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Word - Produce Quick Reports
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.5 hours

Date and Time
Monday 27 January 2020  11 – 1:30 pm

Thursday 26 March 2020

 2:00 – 4:30 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Word – Mail Merge
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 lettters
  • 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

 Date and Time
Monday 16 March 2020  2:00 - 4:00 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book


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 charts
Who is this course for?

St George’s and NHS staff

Duration: 2 ½ hours

Date and Time

Monday 3 February 2020

 11 – 1:30 pm

Thursday 13 February 2020

 11 – 1:30 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Excel - Visualising Data with Charts
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

 Date and Time

Thursday 09 April 2020

 2:00 - 4:00 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Excel - Conditional Formatting & Data Validation
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

 Date and Time

Thursday 09 April 2020

 2:00 - 4:00 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Excel – Filtering and Advanced Filtering of Data
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

 Date and Time

Friday 6 March 2020

 11 - 1:00 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Excel – VLookup and Hlookup
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

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Excel - Pivot Tables
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.5 hours

Date and Time

Tuesday 3 March 2020

 11 – 1:30 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Excel - Format Cells and Ranges
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

Date and Time

Thursday 20 February 2020

 11 – 1 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

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

Date and Time

Thursday 30 February 2020

2 – 4 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

PowerPoint Intermediate
If you already know PowerPoint fundamentals and you are ready to move to the next level, this workshop will help ypu create more engaging and dynamic presentations.  

You will learn how to:

  • Use Slide Mater
  • Modify pictures & add WordArt
  • Create & format SmartArt
  • Add & format charts & tables
  • Create custom Animations
  • Add & modify audio & videos
  • Save in various formats
Who is this course for?

St George’s and NHS staff

Duration 3 hours

Date and Time

Thursday 12 March 2020

10 – 1 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Outlook - Automating Messages
The best way to organise your inbox is to move messages to folders that have related messages.You can create “Rules” to move, assign to a category or forward messages automatically.

“Quick Steps” are like macros. You choose when and where to perform one or more functions at the same time. 

You will learn how to:

  • Create a rule using the Rules wizard
  • Create a rule from a selected message
  • Run a rule
  • Create a rule from start to end
  • Sequence rules
  • Turn off a rule
  • Create a quick step
  • Edit a quick step
  • Delete quick steps
Who is this course for?

St George’s and NHS staff

Duration 2 hours

Date and Time

Thursday 23 January 2020

11 – 1 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

Outlook - Managing Meetings
Working with others to accomplish goals usually requires regular meetings.  You can see each individual’s calendar so you can schedule meetings by selecting the date, time and place by sending an invitation with response options.  You can organise meetings on a daily, weekly, monthly or yearly basis.

You will learn how to:

  • Create a meeting request
  • Respond to a meeting request
  • Managing a meeting
  • Updating a meeting request
  • Managing  recurring meeting
  • Sharing meeting notes
Who is this course for?

St George’s and NHS staff

Duration 2 hours

Date and Time

Thursday 23 January 2020

11 – 1 pm

Place: St George’s Library Training Room, in the library, 1st floor Hunter wing

Click here to book

 

Find a profileSearch by A-Z