Microsoft Office Specialist (MOS)
Microsoft Office Specialist (MOS) certification is the leading IT certification in the world. More than one-million MOS exams are taken every year in over 140 countries.
You have a number of learning options, in the best way to suit your needs.
You can progress entirely online, drop into our IT Hub on campus for face-to-face support, or access support through our online platform. Alternatively, you can use a mix of the three, depending on your support requirements as you progress through the course. It normally takes a maximum of 20 weeks to complete each course, with the final exam held in the College.
Word
Word
Successful candidates for the Microsoft Word exam will have a fundamental understanding of the Word environment and the ability to complete tasks independently.
They will demonstrate the correct application of the principle features of Word by creating and editing 2- to 3-page documents for a variety of purposes and situations.
Document examples include professional-looking reports, multi-column newsletters and business correspondence.
Course content includes:
- Printing and saving documents
- Inserting text and paragraphs
- Formatting text and paragraphs
- Ordering and grouping text and paragraphs
- Creating and modifying tables
- Creating and modifying lists
- Creating and managing simple references
- Inserting graphic elements
- Formatting graphic elements
- Inserting and formatting
- SmartArt graphics
Entry requirements: Basic knowledge of Word application software.
Certification: Microsoft Certificate
Duration: 20 hours over 10 weeks
Price: £120
Next Steps: MOS Expert
Excel
Excel
A core-level candidate for the Microsoft Excel exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently.
They should know and demonstrate the correct application of the principal features of Excel and should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. Candidate roles might include students, clerical workers, bookkeepers, instructors, and others.
Course content includes:
- Creating Worksheets and Workbooks
- Navigating in Worksheets and Workbook
- Formatting Worksheets and Workbooks
- Customising options and views for Worksheets and Workbooks
- Configuring Worksheets and Workbooks for distribution
- Inserting data in cells and ranges
- Formatting cells and ranges
- Summarizing and organising data
- Creating and Managing tables
- Managing table styles and options
- Filtering and sorting a table
- Summarising data by using functions
- Performing conditional operations by using functions
- Formatting and modifying text by using functions
- Creating and formatting charts
- Inserting and formatting objects
Entry requirements: Basic knowledge of Excel application software.
Certification: Microsoft Certificate
Duration: 20 hours over 10 weeks
Price: £120
Next Steps: MOS Expert
Access
Access
Successful candidates for the Access exam have a fundamental understanding of the application’s environment.
They understand basic database design principles and are able to complete tasks independently. They know and demonstrate the correct application of the principle features of Access 2016, and will demonstrate the ability to create and maintain basic Access database objects including tables, relationships, data entry forms, multi-level reports, and multi-table queries.
Course content includes:
- Creating and modifying databases
- Managing relationships and keys
- Navigating through a database
- Protecting and maintaining databases
- Printing and exporting databases
- Creating and managing tables
- Managing records in tables
- Creating and modifying fields
- Creating and modifying queries
- Creating calculated fields and grouping within queries
- Creating a form
- Configuring form controls
- Formatting a form
- Creating a report
- Configuring report controls
- Formatting a report
Entry requirements: Basic knowledge of Access application software
Certification: Microsoft Certificate
Duration: 20 hours over 10 weeks
Price: £120
Next Steps: MOS Expert
Outlook
Outlook
Successful candidates will create and edit professional-looking email messages, maintain calendars across time zones, and schedule tasks for a variety of purposes and situations.
Candidates will use Outlook to enhance professional correspondence, create calendars, and schedule appointments. Application examples include coordinating building resources, sending messages for marketing campaigns, planning staff meetings, and assigning meeting action items.
Course content includes:
- Customise Settings
- Print and Save Information
- Perform Search Operations in Outlook
- Configure Mail Settings
- Create Messages
- Format a Message
- Organise and Manage Messages
- Create and Manage Calendars
- Create Appointments,
- Meeting and Events
- Organise and Manage Appointments, Meetings and Events
- Create and Manage Notes and Tasks
- Create and Manage Contacts
- Create and Manage Contact Groups
Entry requirements: Basic knowledge of Outlook application software.
Certification: Microsoft Office Specialist
Duration: 20 hours over 10 weeks
Price: £120
PowerPoint
PowerPoint
Successful candidates will have a fundamental understanding of the PowerPoint environment and demonstrate the correct application of PowerPoint.
Candidates create, edit, and enhance presentations and slideshows. Presentation examples include professional-grade sales presentations, employee training, instructional materials, and kiosk slideshows.
Course content includes:
- Creating a Presentation
- Inserting and formatting slides
- Modifying slides, handouts and notes
- Ordering and grouping slides
- Changing presentation options and views
- Configuring a presentation for print
- Configuring and presenting a slide show
- Inserting and formatting text
- Inserting and formatting shapes and text boxes
- Inserting and formatting images
- Ordering and grouping objects
- Inserting and formatting tables
- Inserting and formatting charts
- Inserting and formatting
- SmartArt graphics
- Inserting and managing media
- Applying slide transitions
- Animating slide content
- Setting timing for transitions and animations
- Merging content from multiple presentations
- Finalising presentations
Entry requirements: Basic knowledge of PowerPoint application software.
Certification: Microsoft Office Specialist
Duration: 20 hours over 10 weeks
Price: £120