Be able to work with your data and use some basic analysis tools, such as filtering and pivot tables
Apply suitable formatting to your spreadsheet to improve readability
Understand the features that can help you work with large datasets
Be confident in the use of general formulas and know how to search for more advanced formulas
Know how to display data visually in charts
Microsoft Office Specialist
The Microsoft Office Specialist (MOS) Qualification demonstrates that you have specialist skills in using Microsoft applications.
As a member of Lancaster University current staff and students have the opportunity to self-study one or more MOS qualifications. Microsoft estimate each qualification is around 40 learning hours and each are a qualification in their own right.
Microsoft publish a range of resources on their Office help and training page. They provide various quick-start guides for the main Office applications, as well as a searchable knowledge base of guides.