Training 2

Research at St George’s investigates and develops new, pioneering methods and treatments to improve health at a local, national and international level with a growing portfolio of collaborations in Asia, Europe, Africa and the Americas.

We face-to-face training in Microsoft Office applications such as Word, Excel, Powerpoint and Outlook with an experienced IT Trainer.

 

Where do the Microsoft Office workshops take place?

Most courses take place in the Library Training room 1st floor Hunter wing. All course confirmation will come with the date, time and place of the workshop.

You don't offer the training I need, what should I do?

Contact This email address is being protected from spambots. You need JavaScript enabled to view it. and we will discuss your training needs.

 


Access and eligibility

Who are the workshops for?

All workshops are for University staff and students.

What should I do if I have to cancel my booking?

Send an email to This email address is being protected from spambots. You need JavaScript enabled to view it. to cancel and let us know if you wish to be booked on another date or course.

 


Making a booking

How do I make a booking?

Send an email to This email address is being protected from spambots. You need JavaScript enabled to view it.

What if the course I want is fully booked?

Depending on your urgency to learn a manual can be sent for you to work through or you can arrange a 1-2-1 for 1 hour depending on your needs and knowledge of the application.

What if I can't make any of the available dates?

We will book you on the next date available or depending on your urgency to learn, a manual can be sent for you to work through or you can arrange a 1-2-1 for 1 hour depending on your needs and knowledge of the application.

 


Other information

What happens if IT Training have to cancel a course?

You will be sent an email of the cancellation and will be given an alternative date and time.

I still haven't had my question answered, how do I contact you?

We are based in the library 1st floor Hunter wing, you can also contact us by phone on extension 5662.

Do you provide 1-2-1 support?

Yes. Face to face, email or over the telephone.

MS-Office-Drop-inlogo

IT support is offered to assist in the use of Microsoft Office 2013 on a drop in basis in the library foyer:

Monday 11am - 1pm
Friday    11am - 1pm

 

Do you provide tailored IT training session for departments and individuals?

Yes. Contact us by email This email address is being protected from spambots. You need JavaScript enabled to view it. or phone extension 5662 to discuss your requirements.

A selection of online tutorials and e-learning packages.

Medical and health related

Armando Hasudungan Biology and Medicine Videos
Extensive series of sketch note style Biology and Medicine videos created by Amando Hasudungan who started the series as a medical student.

Cell Signalling Biology
Describes the biology of cell signalling. The emerging information on cell signalling pathways is integrated and presented within the context of specific cell types and processes.

Clinical Skills Online
Online videos demonstrating core clinical skills common to a wide range of medical and health-based courses. From the e-Learning Unit at SGUL. A CSO Youtube channel is also available.

Cochrane Library
There are three Cochrane Library modules, scroll down to 'Online self-paced tutorials'.

Drug Calculations & Numeracy testing
Drug calculations quiz designed to assist in learning the principles of metric conversions, fluid dosage calculations, tablet dosage calculations and Intravenous drop rate calculations.

Medical Masterclass
Interactive Mock MRCP Part 1 and 2 Exams website
Ask at the Library helpdesk for a username and password. *Only available to medical trainees*

NEJM - Videos in Clinical Medicine - onsite access
Peer reviewed educational videos that demonstrate clinical procedures and physical examinations
For offsite access select "Log in via your institution" option. *Offsite access only available to SGUL staff and students*

PathCal onsite access
PathCAL is a series of online tutorials covering a wide range of pathology and pathophysiology subjects produced and published by the College of Medicne and Veterinary Medicine at the University of Edinburgh.

PathCal offsite access: select St George's, University of London from the drop down box. *Offsite access only available to SGUL staff and students*

PubMed
The PubMed Tutorial is a Web-based learning program that will show you how to search PubMed, the National Library of Medicine's (NLM) journal literature search system.

St George's, University of London MOOCs
Check for online courses created by St George's University of London on the FutureLearn platform

 

Statistics

Rice Virtual Lab in Statistics
Provides demonstrations for statistical concepts, case studies, basic statistical analysis tools and an online statistics book.
Developed by David Lane - Associate Professor of Psychology,
Statistics,and Management at Rice University, USA.

Khan Academy
A collection of video tutorials on statistics developed by Khan Academy.

 

We provide free downloadable Microsoft Office training manuals with exercises and flexible web based learning.

 

New Microsoft Office Training manuals

Please note, these files are password-protected. You will be redirected to the Portal pages where you will be required to log in with your SGUL credentials.

Word - Adding page numbers to landscape pages

Word – Reports quick sheet

Word - Building Blocks - zipped folder

Excel – Add or subtract time

Excel - Gantt Chart

Excel - Sharing and Protecting Data - zipped folder

Excel - Functions

Excel - Referencing

Intro PowerPoint quick sheet

 

How to unzip folders to access documents.

  1. Save the zipped folder.
  2. Right click when hovering over the folder and select 'Extract all' or 'Extract files' to begin process.

 

If what you want to learn is not available please let us know.

Free downloadable Microsoft Office 2010 training materials

Please note, these files are password-protected. You will be redirected to the Portal pages where you will be required to log in with your SGUL credentials.

Microsoft Access 2010

Microsoft Excel 2010

Master Documents

SmartArt

Tracking Changes

Outlook 2010 Colour Categories - Learn how to assign a colour category to a group of interrelated items − such as messages, contacts, notes, appointments, so that you can easily access or organise them.

Free flexible web-based learning

You can get flexible web based-learning on: Management, Office 2010 and Office 2013 (details of what you can learn below).

To access the web based learning materials, send an email to This email address is being protected from spambots. You need JavaScript enabled to view it. requesting what you wish to learn.

You get 3 months access to each set of learning materials, which can be extended if needed.

 

Management Training

management training image

Management Training will assist you in developing some essential skills, or prepare you for the profession. It covers 5 subjects.

  • Business Strategy
  • Motivation and Teamwork
  • Performance Management
  • Planning and Organising
  • The Five Principe of Business Leadership

 

MS Word 2010

Basic - Create a new document, insert and edit & formatting text, copy and move data, insert images within a document. Use the spell check, printing preview and saving a file.

Intermediate – Insert and format a Table, add headers and footers, insert sections, symbols, hyperlinks, Smart Art, Track changes, Create address labels, using the Go to function, Find & replace tool.

Advanced - Mail merge and forms, add a water mark, Footnotes, insert an Excel worksheet, Digital signatures, updating the table of contents, insert a cover page

 

MS Word 2013

Basic - Create a new document, enter, amend & formatting text, copy and move data, Navigation & selection techniques. Page Layout, Use the spell check, printing preview and saving a file, Bullets & numbering lists, Insert and format a Table.

Intermediate – Quick Parts, Section Breaks, Insert Headers & Footers, Styles, table of Contents, Cover page, Inserting Images, SmartArt, Style set & Themes, Inserting symbols, Borders 7 Shading, Tables & Columns

Advanced - Mail merge and creating forms, add a water mark, Track Changes & Comments, Protect a document, Create forms, Macros, user Accounts , Footnotes & Endnotes

 

MS Excel 2010

Introduction - Create a spreadsheet and input data. Create simple calculations, Summing cells, change page orientation, insert an Image, edit, delete, move, copy and manipulate data, format spreadsheet and printing, insert a pivot table

 

MS Excel 2013

Intermediate – Create a Sparkline, filtering data, name a range, AutoSize columns, Editing Formulae, Formula Auditing, calculate the average, Sorting, Freeze Panes, Create a chart, Scenarios, Changing Chart type, Merge & Centre

Advanced – VLOOKUP function, Paste special (Transpose Values) Working with XML Data, Import test, Delete Duplicate Data, Conditional formatting, Password protect a Workbook.

 

Back to the top

We supports students, university staff and NHS staff  in learning, teaching and research with online resources and training session.

Information Skills

Information Skills Training - includes courses for students, research and teaching staff, NHS staff.

Online Tutorials - cover medical and health-related topics.

Library StART toolkit

Library StART (St George's Assignment Resources Toolkit)  -  an online toolkit to guide you through your first steps of writing an assignment


 

IT and Digital Skills

it logo

The IT Training team will help and support yo to get the most out of the MS Office 2013 package available to you at St George's.

We offer a number of ways to improve your IT skills including Student Microsoft Office Workshops, Staff Microsoft Office Workshops, online tutorials and 1-2-1 sessions for Word, Excel, PowerPoint and Outlook (Office 2013 version).

Contact us (details below) if you're planning a group session, or looking for bespoke training. We will work with you as individuals or groups, to provide a professional service.

 


Office365 (O365)

Office 365 gives you 1TB of storage space in the cloud, enabling you to update Office documents across multiple devices, while keeping your content and formatting intact.

With O365 you can:

  • have group meetings online
  • deliver presentations
  • share documents

End user training resources for Office 2013 and Office 365 are available.

Download Microsoft Office Apps to 5 devices.

 St George's, University of London students and staff can download free copies of the Microsoft Office apps on up to 5 devices.

Note: the software is valid for as long as the user has a valid SGUL account, and will stop working once the account is closed, i.e when the student or staff member leaves the university.

Download MS Office free - PDF

 


Learn at Your Own Pace - E-learning

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

These are useful for any level of user, offering instant targeted solutions, without have to book, arrange and leave the office.

 


IT Trainer in the Library

The IT trainer offers group or one-to-one tailored tuition and support onsite in Microsoft Office® applications such as: Word, Excel, PowerPoint, Publisher, Access, or Project.

Free to SGUL staff and students. For NHS staff, hands-on workshops cost £20 and tailored workshops cost £30 per person, per workshop, per hour (VAT is included in both prices).

 

Contact details

Fiona Graham 020 8725 5662 (ext. 5662)

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.