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 |
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 |
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 |
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 |
|
