Next class: Fall of 2007

Limited Enrolment Apply Immediately!!

Program Objective

To provide unemployed individuals with the training, skills and experience necessary to put them on the path to furthering their education to be able to obtain long-term, stable employment and a career.

Program Overview

This hands-on course is for the intermediate learner who has the introductory level program understanding of MS Office. Topics include intermediate lessons in the following:

Topics for Office Microsoft Word 2003

• Inserting Clip Art from the Web in Word Document
• Centering the Title Page Contents Vertically on the Page
• Inserting a Section Break
• Inserting a Word Document into an Open Document
• Printing Specific Pages in a Document
• Creating a Header Different from a Previous Section Header
• Creating a Footer Different from a Previous Section Footer
• Adding and Deleting Table Tows and Columns
• Summing Table Contents
• Charting a Word Table
• Changing the Chart in Graph
• Creating and Applying a Character Style
• Customizing Bullets in a List
• Creating a Watermark
• Working with AutoShapes and the Drawing Canvas
• Adding an AutoShape in a Drawing Canvas
• Formatting an AutoShape
• Resizing and Formatting the Drawing Canvas
• Creating a Data Source
• Editing Records in the Date Source
• Composing the Main Document for the Form Letters
• Using an IF Field to Conditionally Print Text in a Form Letter
• Creating an Outline Numbered List
• Applying a Paragraph Style
• Merging the Documents and Printing the Letters
• Selecting Data Records to Merge and Print
• Sorting Data Records to Merge and Print
• Addressing and Printing Mailing Labels
• Merging All Data Records to a Directory
• Creating a Professional Newsletter
• Inserting a WordArt Drawing Object
• Formatting a WordArt Drawing Object
• Inserting and Formatting a Floating Graphic
• Formatting a Document into Multiple Columns
• Formatting a Letter as a Drop Cap
• Creating a Pull-Quote
• Changing Column Formatting
• Balancing Columns
• Creating a Diagram
• Using The Format Painter Button
• Reviewing Document
• E-Mailing a Document for Review
• Tracking Changes
• Reviewing Tracked Changes and Comments
• Changing Review Settings
• Comparing and Merging Documents

Topics for Microsoft Office Excel 2003

• Adding Custom Borders and a Background Color to a Range
• Creating Cell Names Based on Row Titles
• Using a Data Table to Analyze Worksheet Data
• Adding a Pointer to the Data Table Using Conditional Formatting
• Creating an Amortization Schedule
• Printing Sections of the Worksheet
• Protecting the Worksheet
• Hiding and Unhiding Rows, Columns and Sheets
• Hiding and Unhiding Workbooks
• Formula Checking
• Creating a List
• Adding Computational Fields to the List
• Using a Data Form to view Records and Change Data
• Sorting a List
• Displaying Automatic Subtotals in a List
• Finding Records Using a Data Form
• Querying a List Using AutoFilter
• Using a Criteria Range on the Worksheet
• Extracting Records
• More About the Criteria Range
• Using Database Functions
• Using SUMIF and COUNTIF Functions
• Saving a Workbook in Different File Formats
• Creating the Template
• Formatting the Template
• Creating a Workbook from a Template
• Copying the Contents of a Worksheet to Other Worksheets in a Workbook
• Referencing Cells in Other Sheets in a Workbook
• Adding and Removing Page Breaks
• The Finds and Replace Commands
• Consolidating Data by Linking Workbooks
• Printing and Saving the Word Document with the Linked Worksheet and Chart

Topics for Microsoft Office PowerPoint 2003

• Importing Text Created in Another Application
• Adding a Picture to Create a Custom Background
• Inserting and Modifying Clips
• Customizing Graphical Bullets Using the Slide Master
• Creating a Table on a Slide
• Creating an Organization Chart
• Adding an Animation Scheme to Selected Slides
• Creating a WordArt Element and Adding It to a Slide
• Adding a Sound Effect
• Adding a Chart to a Slide
• Inserting an Excel Chart
• Adding a Table from Word
• Adding Hyperlinks
• Hiding Slides
• Adding an Action Button on the Slide Master
• Adding a Slide Transition Effect to a Slide Show
• Rehearsing Timings
• Adding Notes and Printing Speaker Notes

Topics for Microsoft Office Outlook 2003

• The Calendar – Microsoft Outlook Window
• Entering Appointments Using the Appointment Area
• Editing Appointments
• Moving Appointments to a New Time
• Moving Appointments to a New Date
• Moving an Appointment to a New Month
• Creating an Event
• Displaying the Calendar in Week and Month views
• Using Tasks to Create a Task List
• Exporting, Deleting and Importing Subfolders
• Meeting and Task Management Using Outlook
• Customizing Calendar Settings
• Printing a Calendar
• Archiving Items

Office 2003 Integration Case Studies

• Integrating Excel, Word, PowerPoint and Outlook

Admission Requirements

Applicants must have at least a grade 10 or mature student status (defined as minimum of 19 years of age and one year away from school)) and have successfully completed the Introductory Level MS Office program. Consideration will be given to applicants who have not completed the Introductory Level but are able to demonstrate an Introductory skill level.

Upon successful completion of this adult training program, students will be provided a "Recognition of Achievement" from Confederation College. Students who wish to enter a full time Confederation College Post-Secondary program must meet the entrance requirements of the program.

Assessment

Students will be assessed throughout the program by tests and demonstration of skills. Attendance is mandatory and will be taken on a daily basis.

Please call 345-6595 for more information or come down to 237 Camelot Street to fill out an application.

Click here for a copy of the poster in PDF (Acrobat Reader format).