Posts tagged: Excel

Congratulations David! Our first MOS Master 2016

16 December 2016

Congratulations to David E Sanchez Espinoza on becoming the University’s first person to qualify as a Microsoft Office Specialist (MOS) – Master 2016, since it was introduced in September. Yes, last week was an eventful one for David, as he also graduated with an MSc in Petroleum and Gas Engineering.

Determined to achieve Master status before he left Salford, achieving this certification felt like an early Christmas present to himself!


David Sanchez Espinoza – MOS 2016 Master

David recommends the Microsoft Office Specialist (MOS) programme to all, and not just to enhance a CV.

“I think that many of us are familiar with Microsoft Office applications, but only to a limited level. I wanted to use this opportunity to develop my skills and broaden my knowledge in the applications that are really relevant to my career field. Going through the MOS programme has allowed me to do that.

I now have much more confidence in producing professional documents, spreadsheets and presentations in the workplace. And getting a certificate that validates my knowledge is definitely worth it.”

Want to know more about MOS?

It’s a globally recognised certification programme, and is freely available to all current students and staff at the University.

The training software is aimed at candidates who have an existing knowledge of their chosen application/s, but perhaps need to strengthen or widen that knowledge to become ‘exam ready’.

How many exams you take is entirely up to you – the choices are Word, Excel, PowerPoint, Outlook and/or Access. Expert level certification is also available in Word and Excel. Or you can aim even higher with the MOS Master certification, as David did, by passing a combination of four exams.

Don’t put it off ’til tomorrow – join the MOS programme today

Excel Mouse Pointer shapes

14 April 2015

It’s amazing how many Excel users don’t realise that the mouse pointer changes shape depending on its context. If you’re a University of Salford student and come to our classroom session on Excel Basics, you’ll get to practise using the different mouse pointer shapes. But if you can’t make it to a classroom session, this video should get you on the right path.

Are you ready for your Microsoft Office Specialist Exam?

2 March 2015

Wow! Microsoft Office Specialist 2010 (MOS) candidates have achieved an impressive 92% pass rate so far this year.

So, if you’ve registered for MOS but haven’t got around to trying the software yet, why not take a practice test today and see how you do. You might surprise yourself with how much you already know!

The GMetrix practice tests give you a clear idea of what to expect in a real exam, and when you score over 70% then you’re ready to book a place on an exam session. And of course, you don’t have to sit an exam for every application – which is ideal, if you only want to be certified for one or two applications.

Microsoft Office Specialist 2010 certification

March exam sessions:

Book your place via Advantage, or the date links above. Exam sessions run every month, with more dates added as demand requires.

Hope to you soon!

Online IT courses

23 February 2015

Ever wanted to learn more about Excel, Word or PowerPoint? Now the University is offering you the chance to brush up your skills, for absolutely free, online.

Short courses include Excel Pivot Tables and Macros, how to format a dissertation in Word and how to add media to PowerPoint, among many others. The full range of courses covers:

  • Access
  • Excel
  • PowerPoint
  • Project
  • SharePoint
  • Word

All you need is your University email to log on. Access the elearning from here:

Alternatively, click the apple icon on the desktop of any University PC:






Once you have completed a course, you are even eligible for a certificate of completion

Get the MOS out of Microsoft

28 December 2014


The Library is offering all students the opportunity of gaining Microsoft Office Specialist (MOS) 2010 certification – for free. This is an industry recognised qualification that shows you have proven IT skills – in demand in a competitive job market.

But it’s not just about getting a qualification for your CV. In working towards MOS certification you’ll find yourself tapping into the full capabilities of Microsoft Office, enabling you to complete university assignments and projects with greater confidence and efficiency.

You can gain a single MOS qualification, a few, or all, in the following courses:

  • Word 2010
  • Excel 2010
  • PowerPoint 2010
  • Access 2010
  • OneNote 2010
  • Outlook 2010

How much time will it take?

That depends on your current level of knowledge. Some people will just need to take a few practice tests, which simulate real Microsoft Office Specialist exams, to familiarise themselves with the software and how the questions are phrased, and others will need more time to refresh their skills. If you have little or no knowledge you can use the training software to build up your skills, take practice tests as you wish and take an exam/exams when you feel ready.


To find out more and to register your place on the programme visit Microsoft Office Specialist

Struggling with your studies? Get Skills for Learning

11 December 2014

skills for learning captureSkills for Learning is a great new website that brings study support together in one easy to find place. It covers all the main areas of:

– Reading and writing

– Finding and understanding information

– Using and referencing information

– IT and digital skills

– Working with numbers

– Group work and presentations

– Assessment, revision and exams

– Supporting your dyslexia or disability

Go and have a look around the site to see what support you can get today from eLearning, videos and guides, or another day by booking onto a workshop, calling into a drop in or arranging a one to one appointment.

And don’t forget, there are also lots of great posts on this blog that will help you with your studies.

If you would like to comment on the site, make suggestions for things to add and things to change you can either post a comment here or email

Help with Excel, PowerPoint and Word

12 June 2014

If you’re a student at Salford and struggling with any aspect of Microsoft Word, Excel or PowerPoint – help is at hand.

A new series of drop in sessions and classroom based courses to help you brush up your IT skills are now available. Whether you need to know how to use formulas in Excel or how to sort out the headings on your dissertation, there’s a session for you, crafted by our team of friendly Digital Skills Trainers, based in the Library.

Here are three ways you can access training and support with IT skills at Salford:

Drop In:
Tuesday 24 June, 8 July, 22 July – Clifford Whitworth Library, second floor extension, room 202a. Times: 1-3pm
Wednesday 18 June, 2 July, 16 July, 30 July. Allerton Learning Space, Seminar Room (CLib105). Times: 1-3pm

Bring your questions/issues with any aspect of Word, PowerPoint or Excel.

Classroom sessions:
New timetable of free training courses is now out. Check out our range of courses on the Library website and book your place on the Advantage system.

Online training:
There’s a great range of elearning on Microsoft Word, Excel, PowerPoint, and much more, for you to work through at your own pace. The training courses are extremely thorough: pick just the aspects you want to learn more about. Online training available here.

How to show Standard Deviation in Excel

16 May 2014

We’ve had lots of questions about how you calculate and display Standard Deviation in Excel recently. Standard Deviation is a measure of how spread out the numbers in a range are: it is a more sophisticated analysis than Average (Mean). Excel has an inbuilt formula – STDEV – which you can use to calculate Standard Deviation on a range of data on your Excel worksheet:

1. Click on the cell where you want the answer to appear.
2. Type: =STDEV(
3. Insert the cell range that you want to calculate the Standard Deviation for.
4. Close the brackets. Your formula should look something like this: =STDEV (C6:C12)
5. Accept (press Enter).

To display Standard Deviations in a chart or graph, Excel uses Error Bars. View this excellent YouTube video from the University of Saskatchewan to see how to calculate Average and Standard Deviation (view from start) and how to display them both in a line graph, using Error Bars (from 6:12):

Click for video