Office 2003 Courses

The following courses are available. Please click on the course (Introduction, Intermediate or Advanced) to see a content overview. In the Overview, click on "Full Specification" to view more detailed information (Objectives, Assessment Criteria etc.). Bespoke courses are available if you prefer to pick topics from different levels and combine them into a single course. 

Excel 2003 Courses

This course introduces the key skills required to create and edit spreadsheet files as well as enter and format data. Topics covered:

• The Excel Environment

• The Creation and Editing of Workbooks, Worksheets and Cells

• Techniques for Correctly and Efficiently Entering Data

• Formatting and Customising Data

• Editing Spreadsheets

• Using Formulas and Functions

• Printing

This course covers the following intermediate level skills:

• Viewing Worksheets

• Using Formatting Techniques

• Using Formulas and Functions

• Utilising Database and List Management Tools

• Creating Charts

• Working with Drawing and Picture Objects

• Using Excel with Other Applications

This course covers the following advanced level skills:

• Importing Data (Text file, Web and Database)

• Using Templates and Styles

• Analysing Data (Goal Seeking, Data Tables, Pivot Tables, the Solver and Scenarios)

• Recording and Running Macros

• Security and Proofing

• Customising Excel

• Collaborating and Consolidating

Word 2003 Courses

To provide the student with the skills to produce professional, quality documents consistently and efficiently. Topics covered:

• Controlling the Word Application

• Formatting a document

• Searching a Document

• Creating Emails and Web Pages

• Printing Documents

This course covers the following intermediate level skills:

• Managing Files within Word 2003

• Applying text and paragraph formatting

• Using Tables

• Managing AutoCorrect and AutoText

• Mail Merging

• Inserting Text Boxes, Graphics and Word Art

• Linking and Embedding objects from other Applications

This course covers the following advanced level skills:

• Working with Forms

• Creating Macros

• Creating and Using References

• Proofing a Document

• Using Advanced Document Management Techniques

• Creating Web Pages

• Using Advanced Document Layout Techniques

Access 2003 Courses

To provide the student with the skills to produce professional, quality documents consistently and efficiently. Topics covered:

• Designing Tables

• Designing Queries

• Designing Forms

• Designing Reports

• Working with Pivot Tables and Pivot Charts

• Importing and Exporting Data

• Building Expressions

This course covers the following intermediate level skills:

• Navigating Access

• Creating and Working with Tables

• Creating and Working with Queries

• Creating and Managing Forms

• Creating and Managing Reports
  

This course covers the following advanced level skills:

• Topics to be added

PowerPoint 2003 Courses

To provide the student with the skills to produce professional, quality documents consistently and efficiently. Topics covered:

• Controlling the PowerPoint Application

• Viewing PowerPoint Screens

• Using AutoLayout

• Using the AutoContent Wizard

• Creating a Simple Text Slide

• Formatting and Proofing Text

• Using Objects and Backgrounds

• Printing a Presentation

• Creating and Running a Slide Show

This course covers the following intermediate level skills:

• Managing Files and Folders

• Adding Text to Slides

• Formatting and Proofing Text

• Using Masters

• Using the ClipArt Gallery

• Creating Tables

• Creating Charts

• Adding Organisational Charts

• Using PowerPoint with other Applications

• Printing a Presentation

• Customising PowerPoint

This course covers the following advanced level skills:

• Creating Interactive Presentations

• Working with Multimedia

• Integrating PowerPoint with Other Files

• Working on the Web

• Working with Templates

• Working with Tables and Organisation Charts

• Delivering On-Screen Presentations

Project 2003 Courses

To provide the student with the skills to produce professional, quality projects consistently and efficiently. Topics covered:

• The Project Window

• Defining a Project

• Managing Calendars

• Managing Tasks

• Managing Resources

• Assigning Resources to Tasks

• Sorting, Filtering, Grouping and Outlines

• Managing Tables, Views and Charts

• Printing Reports

This course covers the following intermediate level skills:

• Baseline and Interim Plans

• Schedule Analysis (Cost, Critical path etc.)

• Resource Management and Levelling

• Communication (Task assignment etc. by email)

• Managing Multiple Projects

• Customisation of Table fields

• Project Views

Visio 2003 Courses

To provide the student with the skills to produce professional, quality drawings consistently and efficiently. Topics covered:

• Configuring Visio

• Working with Drawings

• Choosing Drawing Types

• Building Drawings

• Formatting a Drawing

• Setting-up and Edit Pages

• Sharing Drawings

• Customising Visio

Outlook 2003 Courses

To provide the student with the skills to manage Emails, Contacts, Calendar etc.. Topics covered:

• Open and Use Outlook

• Use the Toolbars

• Send and Receive Emails

• Manage Contacts

• Manage Tasks

• Manage Notes and the Journal

• Manage Mail

• Manage the Calendar

• Use Outlook with the Web

• Save and Archive