Skip navigation to content

IT training courses

Microsoft Office course list

We deliver a series of IT training courses most months as a subset of the full range of Microsoft Office courses listed below (current version is Office 2016). The courses currently scheduled for delivery are available and can be booked from the University’s online course booking system, PDMS under the Information Management and IT section. For more detailed content information on a given course, please see the course description in the PDMS booking system.

If you are interested in a training course that is listed but not currently scheduled for delivery, please email your interest to IT Training as we may be able to arrange it. If you would like to schedule a bespoke training session or series of sessions covering a particular range of topics for your School or unit please email or phone (see Contact details) to discuss your needs. We welcome all enquiries.

SoftwareTopicTime (hours)
Email
MS Outlook
Effective Email Management: strategies and tools in Outlook for tackling email and calendar management 2
Word processing
MS Word
Advanced Document Management: using Styles to efficiently control the formating and access an array of powerful features to transform the management of longer documents 2.5
  Controlling Document Design: using tabular features to create more complex and efficient layouts and controlling document structure for custom headers, footers, and pagination 2.5
  Creating Electronic Forms: create featured computer-fillable and online forms 2
  Using Mail Merge: create customised letters, emails and labels for mass mailings 1.5
  Manuscript Skills: using tools for collaborative editing and referencing tools 2.5
  Producing a Thesis or Dissertation in Word:  a concentrated course covering a range of skills and stategies specific to managing and compiling a complex document such as a thesis 3
Presentation software
MS PowerPoint
Essential PowerPoint Skills: key features to make best use of PowerPoint 1.5
  Advanced PowerPoint Skills: tools to make your presentations more distinctive and effective such as custom themes and animation 1.5
  Creating Academic Posters in PowerPoint (available only by arrangement) 2
Spreadsheets
MS Excel
Introduction to Spreadsheets-Managing data: key skills in understanding how to enter, edit and maintain spreadsheets, sorting, filtering and output 2.5
  Creating and Using Formulae: working with calculations in spreadsheets 1.5
  Using Functions: powerful techniques to use built-in calculation tools for more complex analysis 2
  Creating Charts and Pivot Tables: use chart tools to graphically display data and pivot tables to interrogate data 2.5
  Automating Spreadsheets: introduction to form elements and macros 2.5
Databases
Microsoft Access
Introduction to Databases: the basics of designing and implementing a relational database 6

Contact

Sonny Evans

CAPOD
University of St Andrews

Hebdomadar's Block
St Salvator's Quad
75 North Street

St Andrews
Fife
KY16 9AJ
Scotland, United Kingdom

Tel: 01334 46(2591)