MS Office 2003

Course Overview

Microsoft Office 2003 will introduce you to the basic and advanced features of all of the tools in this suite of products including Access, Excel, Outlook, Word, Powerpoint and Project.

Course Outline

Access 2003 Basic – 1 hr, 12 mins   

  •  How a Database Works
  •  Interface Review and New Features
  •  Working with Existing Database Information
  •  Building a Database
  •  Additional Tasks

Access 2003 Advanced – 1 hr, 6 mins                   

  •  Building Relationships and Editing
  •  More Form Tasks
  •  Importing and Exporting
  •  More Query Tasks
  •  Working with Reports
  •  Database Activities

Excel 2003 Basic – 1 hr, 9 mins      

  •  Interface Review and Basic Tasks
  •  Managing Data
  •  Formatting Basics
  •  Reviewing Calculations and Templates
  •  Saving and Printing

Excel 2003 Advanced – 1 hr, 6 mins                     

  •  Working with Formulas
  •  Advanced Formatting
  •  Managing Data
  •  Working with Charts
  •  Working with Images

Front Page 2003 – 2 hrs, 7 mins

Level 1 – 44 mins     

  • Getting Started
  • Page Editing and Formatting
  • Navagation View
  • Graphics and Active Elements

Level 2 – 33 mins

  • Folders View
  • Themes
  • Hyperlinks
  • Task Views

Level 3 – 49 mins

  • Tables
  • Forms
  • Cascading Styles Sheets
  • Frames

Outlook 2003 Basic – 58 mins

  •  Overview
  •  Getting Started
  •  Additional Tasks
  •  Working with the Calender

Outlook 2003 Advanced – 1 hr, 3 mins                 

  •  Additional Message Tasks
  •  Managing Outlook Settings
  •  Additional Tasks
  •  Advanced Features

PowerPoint 2003 – 1 hr, 14 mins

  •  Overview
  •  Getting Started
  •  Enhancing a Presentation
  •  Sharing a Presentation
  •  Finalizing a Presentation

Project 2003 – 8 hrs, 6 mins

Level 1 – 1hr, 55 mins

  •  Project Preparation
  •  Launching Microsoft Project
  •  Creating a New Project Plan
  •  Task
  •  Work Breakdown Structure

Level 2 – 2hrs, 24 mins   

  •  Understanding Resources and Their Impact
  •  Setting up Resources
  •  Assigning Resources To Tasks
  •  Leveling Resources

Level 3 – 2 hrs, 2 mins 

  •  Project Costs
  •  Preparing to Track Your Project
  •  Tracking Your Project
  •  Calculating Actual Costs
  •  Viewing Progress

Level 4 – 1 hr, 45 mins

  •  Collaboration on a Project
  •  Beginning to use Project Server 2003
  •  Creating and Managing Projects
  •  Using Project Server Web Access

Visio – 8 hrs, 27 mins

Part 1 – 1 hr, 44 mins

  • Introduction to Visio 2003
  • Core Components of Visio

Part 2 – 1 hr, 49 mins

  • How to Create Diagrams
  • Custom Properties
  • Sharing/Saving & Printing

Part 3 – 2 hrs, 25 mins

  • Templates
  • Diagrams and Drawings
  • Buisness Templates
  • Software & Databases
  • Professional Templates

Part 4 – 2 hrs, 29 mins

  • Shapesheets
  • Shapes
  • Visio Automation

Word 2003 Basic – 1 hr, 4 mins     

  •  Interface Review
  •  Getting Started
  •  Working with Tables
  •  Page Customization and Settings
  •  Basic Tasks

Word 2003 Advanced – 1 hr, 2 mins                     

  •  Letters and Mailings
  •  Working with Pictures
  •  Advanced Formatting
  •  Collaboration
  •  Additional Options