Student IT skills

How do you like to learn new skills? As well as classroom courses, we provide self-study Online Training that you can access at home and work through at your own pace. You can also download the accompanying workbooks and exercise files to enhance your learning.

Microsoft Office Specialist

Responsive image

Microsoft Office Specialist 2013 certification

Microsoft Office Specialist (MOS) 2013 is a globally recognised IT qualification and offers current students and staff the opportunity to boost their CVs whilst learning new skills that will benefit their studies and working life.

This is a self-taught study programme, so all the resources you need to pass your chosen MOS certification/s are available online. This allows you to practice in your own time, at your own pace.

MOS 2013 offers certification at three levels: Specialist, Expert and Master:

Microsoft Office Specialist

Demonstrate your core skills by gaining an individual MOS Specialist 2013 certification in one, or more, of these applications.

  • Word
  • Excel
  • PowerPoint
  • Access
  • OneNote
  • Outlook
  • SharePoint

Get details...

Microsoft Office Specialist Expert

Show your advanced skills in Word and/or Excel by earning a Microsoft Office Specialist Expert certification. To earn a MOS Expert 2013 certification, you must pass both of the MOS Expert required exams listed:

  • Word Expert - 2 exams
  • Excel Expert - 2 exams

Get details...

Become a Microsoft Office Specialist Master

Demonstrate that you have the deepest level of skills needed to use Office programs proficiently by earning a Microsoft Office Specialist Master certification. To earn the MOS Master 2013 certification, you must choose one of a combination of Word and Excel exams and pass all of the required exams, and then pass one of the elective exams in the remaining applications, if required.

Get details...

The training software is called Gmetrix, and it requires MS Office 2013 to be installed on your personal device/s. Not got MS Office 2013?

  • Students - current students are able to install MS Office 2013 Pro Plus, for free, via their Office 365 account.
  • Staff - can purchase MS Office 2013 for £6 as part of the University's Microsoft Campus Agreement.
  • On campus access – the GMetrix software is available on library PCs via the GMetrix desktop icon.

* GMetrix does not currently run on Macs

The pass mark for MOS exams is 70%. Use the Gmetrix* training software to take lots of practice tests so that you can get accustomed to the screens, the question types and the way they are phrased, and to gauge how you respond to the added pressure of timed tests. When you find that you are reaching 70-80% pass marks in your practice tests you are ready for your exam. When you are ready to take an exam, book a place on one of our exam sessions via Advantage.

Microsoft Office Specialist exams are invigilated exam sessions which take place at least once a month on campus in the Newton building, room B04a. Find out when they are and book your place visit Advantage: Events > ICT Training > Microsoft Office Specialist 2013 exam. You can decide which exam to take when you arrive.

* If you want to become a MOS Expert or MOS Master make sure you are aware of the combination of applications and exams that you must take to gain the certification. More info…

There is no charge for this MOS IT training and certification.

Want to know more?

Find our detailed Frequently Asked Questions (FAQs) via The Library’s Microsoft Office Specialist link on Blackboard, or contact

Select a category to find out more about course contents.

Our class-room based courses:

EndNote is a bibliographic management software package which allows you to create your own personal database of references, known as an EndNote 'Library'.

EndNote will:

  • Store all the references that you find during your research. They can be entered manually or downloaded from most databases.
  • Store PDF files, pictures, graphs, tables, etc.
  • Allow you to organise the information you find.
  • Work with MS Word to create citations and bibliographies automatically in any output style.
  • Work with PowerPoint to insert citations and references into your presentations.

The Academic Support Team run regular training sessions for EndNote. These are free, but places are limited so you must book.

Can't make it to a classroom session?

We run a Drop In session every week during term-time, alternating between Clifford Whitworth Library and Allerton Learning Space. No need to book, just turn up with your questions on Microsoft Excel, Word and PowerPoint.

Online Training

To access this online training you first need to request an account.

  1. Please ensure you enter your University email address
  2. You will receive an email to your University account giving you your password.
  3. Once you are logged in to your account, change your password from the Profile area via the tab at the top of the page.
  4. Your personal account will enable you to track your training and, if you complete an entire course, will allow you to print your own certificate of completion.
Course title Course description Course login
Word - A complete guide for Word users at all levels
Tables and Images - Working with Tables
- Working with Pictures
- Working with Shapes
- Working with Objects
Format your dissertation in Word - Styles
- Formatting the Page
- References tools
- Viewing your document
- Reviewing your document
- Some extra features
Course title Course description Course login
PowerPoint - A complete guide for PowerPoint users at all levels
Basics - Getting Started with Presentations
- Inserting and Editing Text
- Formatting Text
- Formatting a Presentation
- Inserting images
- Giving your presentation
Enhancing Your Presentations - Formatting a Presentation
- Working with Tables
- Applying Transition and Animations
- Working with Charts and SmartArt
- Working with Multimedia
- Finalizing a Presentation
Adding video and audio - Inserting and recording audio
- Inserting video
- Compressing media
Course title Course description Course login
Excel - A complete guide for Excel users at all levels
Basics - Getting Started with Worksheets
- Editing a Worksheet
Charts - Creating a Chart
- Working with chart data
- Chart layouts & types
Analysing Data - Conditional formatting
- Sorting and Filtering
- Pivot tables
Formulas & Functions - Getting started with worksheets
- More functions and formulas
Pivot Tables - Create a pivot table
- Update data; change layout
- Create a pivot chart
Macros Basic - Recording a Macro
- Playing and deleting a Macro
- Adding a Macro to the Quick Access Toolbar
Macros Advanced - Editing a Macro's visual code
- Inserting copied code
- Using the If…Then…Else statement
V Look Up - How to use this database function
Course title Course description Course login
Access - A complete guide for Access users at all levels
Course title Course description Course login
Project - A complete guide for Project users at all levels
Course title Course description Course login
Beginner - The Fundamentals
- Managing Lists
Intermediate - Working with Lists
- Working with Libraries
- Working with Blogs, Wikis, and Workspaces
- Using SharePoint with Office
Advanced - Managing sites

Need help?


Online Materials

Our workbooks combine learning material with accompanying task-based practical exercises, so that you can learn at your own pace and practice your new skills using the sample exercise files. Popular titles include Word, PowerPoint, Excel and Access.

These workbooks are in pdf format so you will require the Adobe Acrobat Reader software to view or print them.

A selection of short guides giving an overview of shortcut keys and toolbar buttons for both PC and Mac users, covering Microsoft Access, Excel, Outlook, PowerPoint, and FrontPage and a selection of other popular applications, Dreamweaver, Visio, Photoshop, Fireworks and Flash.