Microsoft Office Specialist (MOS) Distance Learning CourseIT103

Course Info

Is This The Right Course For Me?

Benefits for Employee:
Are you looking to validate your desktop computer skills? Are you keen to improve your proficiency and demonstrate your computer literacy? The MOS certification demonstrates complete competency. 

This MOS bundle gives you everything you need to take and pass the MOS exam in Word, Excel, PowerPoint, Outlook and Access.  The job market is ever more competitive and these qualifications can give you the advantage.

Benefits for Employers:
Are you looking for your employees to be at the top of their game? Work efficiently and get the best out of their existing IT packages? Do you want to limit IT support to urgent incidents and deploy this valuable resource elsewhere?

Then the MOS program will mean you can be absolutely sure that you are getting the best out of each employee and they are working proficiently and productively with their software packages. The exam measures true proficiency so you can be assured that you will not have invested in training to see little difference in behaviour.  This bundle covers Word, Excel, PowerPoint, Outlook and Access.

Distance Learning Support

At Start Learning we pride ourselves on our friendly and supportive tutors. Your tutor support will start as soon as you receive your course and will be valid for 12 months. All our tutors are　highly qualified with extensive experience in supporting distance learning students. You contact your tutor via email and they are responsible for marking assignments answering your questions and guiding you through the course to ensure you are ready for your examinations.

Home Study Entry Requirements

No prior knowledge is necessary to study this course. Just some basic Computer skills. At Start Learning we believe that everyone should have the opportunity to expand their knowledge and study further, so we try to keep our entry requirements to a minimum.

Recommended Hours of Study

We recommended you spend approximately 110 hours of your time studying for the Microsoft Office Specialist (MOS) Course. The pace of study is completely up to you. To give an example, if you dedicate 2 hours a week to the course it would take you a year to complete but if you could spare 4 hours a week you could complete it in six months.

Distance Learning Course Contents

 

To find out more about how our course is taught please click here: IT Course Information

Section 1: MOS-Microsoft Office Specialist Word 2007 (77-601)

The Microsoft Office Specialist Certification, (MOS) recognises business professionals who have demonstrated expertise in Microsoft Office 2007. Start Learning's Word 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software.  When you pass the Word 2007 Exam 77-601, you achieve Microsoft Office Specialist (MOS) status in Word 2007.

Unit 1 - The Basic Document: Editing a Document - Formatting Text - Formatting Paragraphs - Adding Tables - Controlling Page Appearance - Proofing a Document - Format Document Text - Format a Paragraph - Create a New Style - Insert or Create a Table - Change the Page Appearance 
  
Unit 2 - Managing Lists: Customizing Tables and Charts - Customized Formatting - Automating Data Entry - Controlling Text Flow - Drawing - Performing Mail Merges - Automating Common Tasks - Sort and Format a List - Customize a Table - Create Themes and Templates - Create and Use Building Blocks - Change the Document Layout - Use the Mail Merge Wizard 
  
Unit 3 - Word & Other Programs: Collaborating on Documents - Versioning - Reference Marks & Notes - Working in Long Documents - Securing a Document - Creating Forms - Using XML in Word - Creating Web Pages - Link or Embed Content - Compare and Merge Documents - Reference Marks and Notes - Create a Table of Contents - Secure a Word Document

*** 

Section 2: MCAS-Microsoft Office Specialist Excel 2007 (77-602)

The Microsoft Office Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. Start Learning's Excel 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software.  When you pass the Excel 2007 Exam 77-602, you achieve Microsoft Certified Office Specialist (MOS) status in Excel

Unit 1 - Creating and Manipulating Data: Insert data by using AutoFill - Ensure data integrity - Modify cell contents and formats - Change worksheet views - Manage worksheets.

Unit 2 - Formatting Data and Content: Format worksheets - Insert and modify rows and columns - Format cells and cell content - Format data as a table.

Unit 3 - Creating and Modifying Formulas: Reference data in formulas - Summarize data by using a formula - Summarize data by using subtotals - Conditionally summarize data by using a formula - Look up data by using a formula - Use conditional logic in a formula - Format or modify text by using formulas - Display and print formulas

Unit  4 - Presenting Data Visually: Create and format charts - Modify charts - Apply conditional formatting - Insert and modify illustrations - Outline data - Sort and filter data

Unit 5 - Collaborating on and Securing Data: Manage changes to workbooks - Protect and share workbooks - Prepare workbooks for distribution - Save workbooks - Set print options for printing data, worksheets, and workbooks.

***

Section 3: MCAS-Microsoft Office Specialist PowerPoint 2007 (77-603)

The Microsoft Office Specialist Certification, (MOS) recognizes business professionals who have demonstrated proficiency or expertise in Microsoft Office 2007. Start Learning's PowerPoint 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software.  When you pass the PowerPoint 2007 Exam 77-603, you achieve Microsoft Office Specialist (MOS) status in PowerPoint 2007.

Unit 1 - Starting in PowerPoint: Beginning a Presentation - Formatting Text - Formatting Paragraphs - Preparing to Deliver - Format Slide Text - Create a Presentation - Change a Placeholder - Create and Print Handouts 
 
Unit 2 - Adding Tables: Charting in PowerPoint - Inserting Multimedia Objects - Working with AutoShapes - Add and Customize a Table - Insert Graphics in Slides 
 
Unit 3 - Powerpoint Masters: Special Effects - Delivering a Presentation - Collaborating in PowerPoint - Securing and Distributing - Create and Modify Masters - Apply Animation Effects - Deliver a Custom Slide Show - Use Comments and Marku

***

Section 4: MCAS-Microsoft Office Specialist Outlook 2007 (77-604)

The Microsoft Office Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. Start Learning's Outlook 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software.  When you pass the Outlook 2007 Exam 77-604, you achieve Microsoft Office Specialist (MOS) status in Outlook 2007

Unit 1 - Using Outlook: Application Window - Messages - Appointments - Contacts - Tasks - Moving, Copying, and Deleting Items - Printing and Finding Items - Customize the Navigation Pane - Use the To-Do Bar - Create an Email Message - Use the Reading Pane - Attach a File to a Message - Open and Preview Attachments - Create a New Contact - Add a Contact from a Message 
  
Unit 2 - Advanced Management: Message Settings - Task Management - Item Organization - Assign Categories to Contacts - Apply a Flag to Mail Items - Customize a Message View - Find a Message using Search - Save a Message as Text - Send a Calendar via Email - Save a Calendar as a Web Page - Use a Distribution List 
 
Unit 3 -Options and Customization: Managing Views - Sharing Calendars - Managing Outlook - Security and Privacy - Create a Default Signature - Schedule an Appointment - Create a Recurring Appointment - Schedule a Meeting - Respond to a Meeting Request - Create and Assign a Task - Respond to a Task Request - Create, Delete, and View Notes 

*** 

Section 5: MOS-Microsoft Office Specialist Access 2007 (77-605)

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. ReTrain for IT's Access 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software.  When you pass the Access 2007 Exam 77-605, you achieve Microsoft Office Specialist (MOS) status in Access 2007

Unit 1 - Access Basics: Designing a Database - Building a Database - Non-Numerical Data Types - Managing Table Data - Filters and Queries - Using Forms - Producing Reports - Create a Database - Create a New Table - Edit a Relationship - Set Field Data Type - Manage Table Data - Filter a Datasheet - Design a Query - Create a Form - Design a Report

Unit 2 - Controlling Data Entry: Finding and Joining Data - Creating Flexible Queries - Enhancing Forms - Customizing Reports - Sharing Access Data - Create a Validation Rule - Join Tables in a Query - Create a Parameter Query - Add Controls to a Form - Create a Grouped Report - Get External Data 
  
Unit 3 - Structuring Existing Data: Writing Advanced Queries - Creating and Using Macros - Making Forms More Effective - Improving Reports - Setting Startup Options - Database Maintenance - Distributing and Securing the Database

Qualification

Qualifications

You will receive the Microsoft Office Specialist (MOS) credential, part of the Microsoft Business Certification program, identifies specific skills covering the most in-demand 2007 Microsoft Office system products—Microsoft Office Word 2007, Excel 2007, PowerPoint 2007, Access 2007, and Outlook 2007—as well as the Windows Vista operating system. Candidates must pass a certification exam in order to earn the MCAS credential.

Exam 77-601: Using Microsoft Office Word 2007
Exam 77-602: Using Microsoft Office Excel 2007
Exam 77-603: Using Microsoft Office PowerPoint 2007
Exam 77-604: Using Microsoft Office Outlook 2007
Exam 77-605: Using Microsoft Office Access 2007

Language of Course

English

Examination Centre

Exams are taken at your local Certiport Testing centre. Please click here to view a list and map - Certiport

FAQ's

Q: How much do the exams cost?
A: They are usually about £70 but you can find the exact cost and book your test on the Prometric Website http://www.2test.com

Q: How is the course taught?
A: You can find out more about how our distance learning courses are taught here: IT Course Teaching

Q: How long do I have to complete the course?
A: No Timescale has been allocated. You can study when you want and where you want. If we update the course, the information will either be posted on our supporting website or sent to you free of charge.

Q: What happens if I’ve paid for the course but find it unsuitable?
A: Not a problem. If you return it within seven days as per the terms and conditions on our web site www.start-learning.co.uk.

Q: What do I receive once I order the course?
A: We will send you ALL the course materials. You can start your studies straight away.

Q: Which exams do I take?
A: You take:

Exam 77-601: Using Microsoft Office Word 2007

Exam 77-602: Using Microsoft Office Excel 2007

Exam 77-603: Using Microsoft Office PowerPoint 2007

Exam 77-604: Using Microsoft Office Outlook 2007

Exam 77-605: Using Microsoft Office Access 2007