Microsoft Office Specialist Certification Courses

Microsoft Word 2003
Microsoft Powerpoint 2003
Microsoft Excel 2003
Microsoft Access 2003
Video Confidence
Digital Literacy
 

Microsoft Office Specialist

One Day Certification Course

Word 2003

This course is designed for experienced Word users wishing to prepare themselves for the Microsoft Office Specialist (MOS) on-line examination in Word 2003.  The following Word 2003 skills will be required for the examination and these topics will be revisited during the course of the day, as required.

Creating Content

  • Insert and edit text, symbols and special characters
  • Insert frequently used and pre-defined text
  • Navigate to specific content
  • Insert, position and size graphics
  • Create and modify diagrams and charts
  • Locate, select and insert supporting information

Organising Content

  • Insert and modify tables
  • Create bulleted lists, numbered lists and outlines
  • Insert and modify hyperlinks
  • Formatting content
  • Format text
  • Format paragraphs
  • Apply and format columns
  • Insert and modify content in headers and footers
  • Modify document layout and page setup

Collaborating

  • Circulate documents for review
  • Compare and merge documents
  • Insert, view and edit comments
  • Track, accept and reject proposed changes

Formatting and Managing Documents

  • Create new documents using templates
  • Review and modify document properties
  • Organise documents using file folders
  • Save documents in appropriate formats for different uses
  • Print documents, envelopes and labels
  • Preview documents and web pages
  • Change and organise document views and windows

Course Dates for Spring & Summer 2007
(Monday to Friday)
Week Commencing
January 8, 15, 22, 29
February 5, 19*, 26
March 5, 12, 19, 26
April 16*, 23, 30
May 7*, 14, 21
June 4, 11, 18, 25
July 2, 9

*No course available on Monday this week

Timetable For The Day
09.15                       Arrival (refreshments included)
09.30 - 10.00            Overview and Skills Assessment
10.00 - 11.00            Group Teaching
11.00 - 11.15            Break
11.15 - 13.00            Individual Skills Practice
13.00 - 13.30            Lunch (provided)
13.30 - 15.00            Exam Question Practice
15.00 - 15.45            On-line Examination
16.00                       End

Course Fee (per day)                              £150
Examination Fee (per exam)                    £35
Total                                                         £185

Back to Menu >>>>>

Microsoft Office Specialist

One Day Certification Course

PowerPoint 2003

This course is designed for experienced PowerPoint users wishing to prepare themselves for the Microsoft Office Specialist (MOS) on-line examination in PowerPoint 2003.  The following PowerPoint 2003 skills will be required for the examination and these topics will be revisited during the course of the day, as required.

 

Creating Content

  • Create new presentations from templates
  • Insert and edit text-based content
  • Insert tables, charts and diagrams
  • Insert pictures, shapes and graphics
  • Insert objects

Formatting Content

  • Format text-based content
  • Format pictures, shapes and graphics
  • Format slides
  • Apply animation schemes
  • Apply slide templates
  • Work with masters

Managing and Delivering Presentations

  • Organise a presentation
  • Set up slide shows for delivery
  • Rehearse timing
  • Deliver presentations
  • Prepare presentations for remote delivery
  • Save and publish presentations
  • Print slides, outlines, handouts and speaker notes
  • Export a presentation to another Microsoft Office program

Collaborating

  • Track, accept and reject changes in a presentation
  • Add, edit and delete comments in a presentation
  • Compare and merge presentations

Course Dates for Spring & Summer 2007
(Monday to Friday)
Week Commencing
January 8, 15, 22, 29
February 5, 19*, 26
March 5, 12, 19, 26
April 16*, 23, 30
May 7*, 14, 21
June 4, 11, 18, 25
July 2, 9

*No course available on Monday this week

Timetable For The Day
09.15                       Arrival (refreshments included)
09.30 - 10.00            Overview and Skills Assessment
10.00 - 11.00            Group Teaching
11.00 - 11.15            Break
11.15 - 13.00            Individual Skills Practice
13.00 - 13.30            Lunch (provided)
13.30 - 15.00            Exam Question Practice
15.00 - 15.45            On-line Examination
16.00                       End

Course Fee (per day)                              £150
Examination Fee (per exam)                    £35
Total                                                         £185

Back to Menu >>>>>

Microsoft Office Specialist

 One Day Certification Course

Excel 2003

This course is designed for experienced Excel users, wishing to prepare themselves for the Microsoft Office Specialist (MOS) on-line examination in Excel 2003.  The following Excel 2003 skills will be required for the examination and these topics will be revisited during the course of the day, as required.

 

Creating Data and Content

  • Enter and edit cell content
  • Navigate to specific cell content
  • Locate, select and insert supporting information
  • Insert, position and size graphics

Analysing Data

  • Filter lists using AutoFilter
  • Sort lists
  • Insert and modify formulas
  • Use statistical, date and time, financial and logical functions
  • Create, modify and position diagrams and charts based on worksheet data

Formatting Data and Content

  • Apply and modify cell formats
  • Apply and modify cell styles
  • Modify row and column formats
  • Format worksheets

Managing Workbooks

  • Create new workbooks from templates
  • Insert, delete and move cells
  • Create and modify hyperlinks
  • Organise worksheets
  • Preview data in other views
  • Customise window layout
  • Setup pages for printing
  • Print data
  • Organise workbooks using file folders
  • Save data in appropriate formats for different uses

Collaborating

  • Insert, view and edit comments

Course Dates for Spring & Summer 2007
(Monday to Friday)
Week Commencing
January 8, 15, 22, 29
February 5, 19*, 26
March 5, 12, 19, 26
April 16*, 23, 30
May 7*, 14, 21
June 4, 11, 18, 25
July 2, 9

*No course available on Monday this week

Timetable For The Day
09.15                       Arrival (refreshments included)
09.30 - 10.00            Overview and Skills Assessment
10.00 - 11.00            Group Teaching
11.00 - 11.15            Break
11.15 - 13.00            Individual Skills Practice
13.00 - 13.30            Lunch (provided)
13.30 - 15.00            Exam Question Practice
15.00 - 15.45            On-line Examination
16.00                       End

Course Fee (per day)                     £150
Examination Fee (per exam)           £35
Total                                                £185

Back to Menu >>>>>

Microsoft Office Specialist

One Day Certification Course

Access 2003

This course is designed for experienced Access users wishing to prepare themselves for the Microsoft Office Specialist (MOS) on

line examination in Access 2003.  The following Access 2003 skills will be required for the examination and these topics will be revisited during the course of the day, as required.

 

Structuring Databases

  • Create Access databases
  • Create and modify tables
  • Define and modify field types
  • Modify field properties
  • Create and modify one-to-many relationships
  • Enforce referential integrity
  • Create and modify queries

Creating Forms

  • Add and modify form controls and properties

Creating Reports

  • Add and modify report control properties
  • Create a data access page

Entering Data

  • Enter, edit and delete records
  • Find and move among records
  • Import data to Access

Organising Data

  • Create and modify calculated fields and aggregate functions
  • Modify form layout
  • Modify report layout and page setup
  • Format datasheets
  • Sort records
  • Filter records

Managing Databases

  • Identify object dependencies
  • View objects and object data in other views
  • Print database objects and data
  • Export data from Access
  • Back up a database
  • Compact and repair databases

Course Dates for Spring & Summer 2007
(Monday to Friday)
Week Commencing
January 8, 15, 22, 29
February 5, 19*, 26
March 5, 12, 19, 26
April 16*, 23, 30
May 7*, 14, 21
June 4, 11, 18, 25
July 2, 9

*No course available on Monday this week

Timetable For The Day
09.15                       Arrival (refreshments included)
09.30 - 10.00            Overview and Skills Assessment
10.00 - 11.00            Group Teaching
11.00 - 11.15            Break
11.15 - 13.00            Individual Skills Practice
13.00 - 13.30            Lunch (provided)
13.30 - 15.00            Exam Question Practice
15.00 - 15.45            On-line Examination
16.00                       End

Course Fee (per day)                     £150
Examination Fee (per exam)           £35
Total                                                £185

Back to Menu >>>>>

Video Confidence

March 2008 Information Flyer >>>>
PowerPoint Presentation >>>>

 

Back to Menu >>>>>