Office 2003 Professional Series

19 Sessions –
57 Hours of Interactive Training

Solid skills with Microsoft Office are a requirement in today’s fast-paced, collaborative business world. With Office 2003 Professional Series from LearnKey, your team can master the Office applications skills necessary to increase productivity in any business environment. Expert instructor, Erin Olsen, will guide you step-by-step through the basics to more advanced features to demonstrate the powerful time saving benefits. This series provides three sessions each of Access 2003, Outlook 2003, and PowerPoint 2003, and five sessions of Excel 2003 and Word 2003.

Benefits

Quickly gain mastery of Microsoft 2003 office products and maximize your productivity.

Be confident in understanding the best tool to make office tasks a breeze.

Create professional, informational documents that communicate your ideas and expertise.

About The Author

Since founding PCKeys Technology Solutions in 1995, Erin Olsen has personally trained more than 10,000 people worldwide in a wide variety of applications and technologies, and she has helped many organizations transition to using Microsoft, Adobe and Macromedia software tools. A Microsoft Office Specialist Master Instructor, Erin enjoys a reputation for providing solid foundations in skills applicable to real-world needs in an easy-to-understand and fun manner. She combines technical knowledge with real-world experience allowing her to provide a wealth of practical examples and inside tips to help her audience learn, retain and actually apply their skills.

Access 2003
Session 1

Section A: Introduction
· Relational Databases
· Flat System
· Relational System
· Database Components

Section B: Database Objects
· Tables
· Queries
· Forms
· Reports
· Macros
· Modules
· Data Access Page

Section C: Database Planning
· Naming Conventions
· Convention Examples
· Database Design
· Plan Purpose
· Plan Tables
· Plan Fields
· Field Names
· Plan Relationships

Section D: Examining Access
· Starting Access
· Table View
· Switching Views
· Query View
· Forms View
· Report View
· Create New Database
· Database Wizard

Section E: Creating Tables
· File Format Considerations
· Create Table
· Data Type
· Description
· Assign Primary Key
· Saving
· Using the Table Wizard

Section F: Text Field Properties
· Field Size
· Format
· Caption
· Default Value
· Required
· Allow Zero Length
· Numbered Text Fields
· Input Mask

Section G: Number Field Properties
· Number Field Size
· Format Date
· Validation Rule
· Validation Text
· Validation Data
· End Date Validation Rule

Access 2003
Session 2

Section A: Working with Data
· Moving Through Datasheets
· Adding Records
· Editing Records
· Deleting Records
· Keyboard Shortcuts

Section B: Working with Datasheets
· Modifying Datasheet Format
· Modifying Datasheet Font
· Modifying Column Widths
· Hiding/Showing Columns
· Moving Columns

Section C: Manipulating Data
· Sorting Data
· Finding Data
· Filtering Data
· Filter Excluding Selection
· Filter for Input
· Filter by Form
· Saving As Query

Section D: Working with Table Structure
· Manipulating Fields
· Changing Data Types
· Deleting Fields
· Moving Fields
· Using Name AutoCorrect
· Property Update Options
· Creating Lookup Fields
· Using Lookup Wizard

Section E: Dependencies & Datasheets
· Checking Object Dependencies
· Subdatasheets
· Manipulating Subdatasheets

Section F: Shaping Up Tables
· Copying
· Renaming
· Deleting
· Printing Tables

Section G: Importing & Exporting
· Importing
· Import Spreadsheet Wizard
· Exporting

Section H: Relationships
· Understanding Relationships
· Referential Integrity
· Join Types
· Understanding Join Types
· Relationship Types

Section I: Creating Relationships
· Relationship Setup
· Adding Tables
· Arranging Tables
· Create Permanent Relationship
· Printing Relationships

Access 2003
Session 3

Section A: Select Queries
· Creating in Design View
· Sorting
· Adding Additional Tables
· Changing Relationship Type
· The Show Box

Section B: Filtering with Criteria
· Exact Entries
· Comparison Operators
· Filter Range
· Null/Not Null
· Using "And" Statements
· Either "Or" Statements
· Unique Values

Section C: Calculations
· Formulas
· Group By
· Concatenation

Section D: Intro to Forms
· Creating Auto Forms
· Form Components
· Working with Controls
· Aligning Controls
· Removing Controls
· Adding Controls
· Using the Forms Wizard

Section E: Working in Forms
· Formatting Forms
· Control Properties
· Navigating a Form

Section F: Data Access Pages
· Save Form As
· Using the Page Wizard
· Apply Themes
· Preview in Browser

Section G: Working with Reports
· Creating Auto Reports
· Using the Reports Wizard
· Report Controls & Sections
· Modifying Controls
· Changing Sorting & Grouping
· Controlling Page Breaks
· Report Output Options
· Exporting to Word

Section H: Maintaining Database
· Using Compact & Repair
· Backing up Data
· Convert Database

Office 2003 Professional Series continued

Excel 2003
Session 1

Section A: Introduction
· Exploring Excel
· Exploring Excel
· Data Types
· Navigating
· Selecting Data
· Noncontiguous Selection

Section B: Workbook Basics
· Entering Data
· Dates
· Numbers
· Fill Handles
· Fill Options
· Save

Section C: Editing Worksheets
· Replace/Edit Data
· Cut, Copy & Paste
· Drag & Drop
· Delete Data
· Rows & Columns
· Change Width & Height
· AutoFit
· Data Validation

Section D: Formatting Data
· Format Toolbar
· Font Format
· Merge & Center
· Format Cells
· Indent
· Borders & Shading
· Layout Options
· Add Graphics

Section E: Advanced Formatting
· Number Formats
· Decimals
· Special Features
· Dates
· Custom Formats
· Create Custom Format
· Conditional Format
· AutoFormat

Section F: Reusable Formats
· Using Templates
· Creating Styles
· Modifying Styles
· Creating Template
· Use/Save Worksheet

Excel 2003
Session 2

Section A: Basic Formulas
· Formula Syntax
· Create Formula
· Create & Edit Formulas
· Relative Reference
· Absolute Reference
· Complex Formulas
· Formula Rules

Section B: Formula Auditing
· Tracing
· Evaluate Formula
· Circle Invalid Data
· Watch Window

Section C: Basic Functions
· Function Syntax
· Common Functions
· Building Functions
· Paste Function Box
· Paste Function Button
· AutoCalculate
· Date & Time Functions
· Logical Functions

Section D: Working with Names
· Create Names
· Range Names
· 3-D Names
· Use Names
· Range Functions
· Paste References
· Edit Range

Section E: Organization
· Worksheets
· Copy Worksheets
· Consolidate Data
· Tab Naming

Section F: Charts
· Chart Wizard
· Define Data
· Layout Options
· Position Options
· Charting Toolbar
· Format Options
· 3-D Charts
· Modify Data

Section G: Save & Print
· Save Options
· Save As Web Page
· View Saved Files
· Print Setup
· Page Setup Options
· Print Area

Excel 2003
Session 3

Section A: Protecting Data
· Worksheet View
· Cell Protection
· Allow Range Editing
· Protect Sheet
· Protect Workbook

Section B: Sharing Workbook
· Set Up for Sharing
· Comments
· Email for Review
· View Changes
· Track Changes
· Compare Side by Side

Section C: Database
· Defining Databases
· Database Components
· Using Forms
· Filtering with Forms

Section D: Sorting Database
· Freeze Panes
· Sort Buttons
· Sort Columns
· Sort Order

Section E: Database Function
· DFunction Syntax
· Modify Function
· And vs. Or
· Record Count
· VLookup

Section F: Filtering
· AutoFilter
· Multiple Filters
· Custom Filters
· Advanced Filters
· Copy to Location

Section G: Subtotals
· Working with Subtotals
· Count Subtotal
· Average Subtotal
· Grouping
· Linking Workbooks

Excel 2003
Session 4

Section A: Excel Advanced Features
· Quick Review
· Ways to Manipulate Data
· What-if Analysis Tools
· Goal Seek

Section B: Using Solver
· Setting Solver Parameters
· Modifying Parameters
· Solver Results

Section C: Forecasting with Trendlines
· Terminology
· Trendline Types
· Creating Charts
· Adding Trendlines
· Formatting and Deleting Trendlines

Section D: Working with Scenarios
· Creating Scenarios
· Showing Scenarios
· Modifying Scenarios
· Merging Scenarios
· Scenario Summaries
· Protecting Scenarios

Section E: PivotTables and PivotCharts
· PivotTable Features
· PivotTable Terminology
· PivotTable Fields
· Creating PivotTables
· PivotTable Layout
· Field List and Toolbar
· Modifying PivotTables
· Filtering PivotTables
· PivotCharts
· Grand Totals and Viewing Details

Section F: Capturing Data from the Web
· Basic Options
· Refreshable Web Queries
· External Data Toolbar
· Web Query Options
· Saving Web Queries
· Exporting Web Pages to Excel
· Redirecting Web Queries

Section G: Using XML
· Saving Spreadsheets to XML Format
· Creating XML Maps
· Exporting XML Data

Office 2003 Professional Series continued

Excel 2003
Session 5

Section A: Macros
· Macros Defined
· Naming Rules
· Storing Macros
· Recording a Macro
· Running a Macro
· Editing a Macro
· Absolute vs. Relative Cell Referencing
· Assigning Macros to Buttons

Section B: Web Functionality
· Hyperlinks
· E-mail a Hyperlink
· Hyperlinks Within Files
· Hyperlinks to Other Files
· Optimizing for Web Publication
· Publishing to the Web
· Office Web Components
· Viewing in a Browser
· Republishing

Section C: Customizing the Interface
· General and View Options
· Calculation and Edit Options
· Custom Lists and Chart Options
· Save Options
· Spelling Options
· Security Options
· Customizing Toolbars
· Creating New Menus

Section D: Manipulating the Screen Display
· Freezing Panes
· Splitting Screens
· Opening in a New Window
· Comparing Side by Side

Section E: Working with Templates
· Benefits
· Creating Styles
· Copying and Importing Styles
· Saving Templates
· Using Templates

Section F: Excel with Other Applications
· Word Mail Merge
· Importing Contacts to Outlook
· Outlook Journal Options
· Linking to Outlook Contacts
· Linking to PowerPoint Charts

Outlook 2003
Session 1

Section A: Introduction
· What is Outlook?
· Usage
· Email Support
· Exchange Storage/Sync
· Personal Folders

Section B: Outlook 2003 Interface
· Starting Outlook
· Setup Email
· Adding Email Account
· Pane View
· Navigation Pane Options

Section C: Navigating with Outlook
· Folders
· Inbox/Reading Pane
· Outlook Today
· Go Menu

Section D: Creating Messages
· Email Messages
· Addressing Options
· Checking Names
· Subject Line
· Text Block
· Message Options
· Tracking/Delivery Options
· Send/Receive

Section E: Working with Messages
· Outbox
· Sent Items
· Inbox
· Voting Options
· Reply/Reply to All
· Forwarding

Section F: Global Email Options
· Message Handling
· Advanced Options
· Reply/Forward Options
· Mail Setup Tab
· Mail Format Tab
· Signatures
· Spell Check
· Reading Pane

Section G: Formatting Messages
· Creating New Message
· Formatting Toolbar
· Create Attachment
· Check Spelling
· Saving Drafts
· Changing Formats
· Stationery Options

Section H: Securing Your Inbox
· Blocked Attachments
· Beaconing
· Viewing Graphics
· Junk Email Options
· Adding Senders

Outlook 2003
Session 2

Section A: Managing Your Inbox
· Read/Unread Messages
· Flagging Messages
· Sorting Inbox
· Advanced Find
· Completing Flags
· Using Colors

Section B: Message Options
· Recalling Messages
· Resending Messages
· Out of Office Assistant
· Receiving Out of Office

Section C: Printing, Saving, & Deleting
· Printing Messages
· Saving Messages
· Deleting Messages
· Deleting Shortcut

Section D: Folders & Folder Rules
· Creating Folder
· Creating Subfolder
· Renaming Folder
· From Inbox to Folder
· Creating Folder Rule

Section E: Create & Edit Contacts
· Creating New Contact
· Adding Email Address
· Adding a Picture
· Adding Phone Numbers
· Adding Address
· Assigning Categories
· Creating Categories
· Contact Details

Section F: Working With Contacts
· Contact Views
· Record Options
· Contact Actions
· Vcards
· Add to Contact List

Section G: Distribution List
· Create Group
· Nested Lists
· Use Distribution Group

Outlook 2003
Session 3

Section A: Calendars
· Views
· Customized View
· Add Appointments
· Events/Time Frames
· Notification Options
· Recurring Appointments
· Move/Delete
· Events

Section B: Meetings
· Meeting Request
· Set Up Meeting Group
· Set Meeting Times
· Meeting Request
· Meeting Tally
· Modify Meetings

Section C: Advanced Calendars
· Multiple Calendars
· Group Schedule
· Calendar Work Week
· Calendar Options

Section D: Sharing Information
· Share
· Add Delegates
· Designated Delegates
· View Shared Calendars
· Printing
· Web Calendars

Section E: Task & Notes
· Add & Create Tasks
· Recurring Tasks
· Assign Tasks
· Task Requests
· Task ManagementNotes
· Calendaring Tasks

Section F: Alternate Access
· Storage Options
· Archive
· Archive Options
· Web Access
· Web Access Options
· Offline Access
· Offline vs. Cached
· Enable Offline Mode

Office 2003 Professional Series continued

PowerPoint 2003
Session 1

Section A: Introduction
· Using Presentations
· AutoContent Wizard
· PowerPoint Interface
· View Options
· Working with Slides
· Task Panes
· Workspace Views
· Photo Album

Section B: Creating Presentations
· Slide Building
· Create Slides
· Slide Layouts
· Save/Save Options
· File Options

Section C: Editing Presentation
· Edit Text
· Editing Options
· Find & Replace
· Bullet Levels
· Slide Control

Section D: Formatting Text
· Formatting Basics
· Font Options
· Replace Font
· Bullets
· Bulleted Lists
· Font Variations

Section E: Editing Tools
· Indents
· Tabs
· Text Boxes
· AutoCorrect
· Spelling Corrections
· Style Options
· Spell Check
· Style Check

Section F: Working in Outlines
· Outline View
· Outline Manipulation
· Adding Content
· Working with Word
· Importing

PowerPoint 2003
Session 2

Section A: Drawing Options
· Lines
· Drawing Tools
· Colors
· Fill Effects
· Order
· Manipulating
· AutoShapes/3-D

Section B: Objects
· Insert Clip Art
· Edit Clip Art
· Word Art

Section C: Slide Design
· Backgrounds
· Color Schemes
· Design Templates

Section D: Images
· Insert Pictures
· Picture Controls
· Working with Pictures

Section E: Sound & Video
· Animation
· Sound
· Using CD Audio

Section F: Tables & Graphics
· Inserting Tables
· Add Text in Tables
· Importing Tables
· Table Sources
· Inserting Graphics
· Adding Excel Graphics
· Format Options

Section G: Diagrams
· Diagram Options
· Using Org Chart
· Formatting

PowerPoint 2003
Session 3

Section A: Templates
· Masters
· Edit Templates
· Save As Templates

Section B: Animation
· Animation Scheme
· Custom Animation
· Chart Animation
· Motion Path
· Ordering Animation
· Transitions
· Level Animation

Section C: Timing
· Rehearse Timing
· Setup Show

Section D: Collaboration
· Send for Review
· Modify Presentation
· Add Comments
· Review/Accept Changes

Section E: Finishing Touches
· Speakers Notes
· Hide Slides
· Summary Slides
· Customized Show
· Setup Show
· Presentation Tricks

Section F: Outputting Presentations
· Printing
· Print Dialog Box
· Export
· Print Memory
· Package for CD
· Prepare for Web
· Web Publishing

Word 2003
Session 1

Section A: Introduction
· Versions
· Hardware Requirements
· Launch Word
· Word Environment

Section B: Word Basics
· Click & Type
· Aligning Text
· Word Wrap
· Cut, Copy & Paste Concepts
· Copy & Paste
· Multiple Copy
· Pasting with Clipboard

Section C: Time Savers
· Keyboard Navigating
· End/Home Keys
· Select Options
· Selection Bar
· Selection Shortcuts
· Noncontiguous
· Move Through Documents
· Selection Review

Section D: Word 2003 Interface
· Task Panes
· Using Task Panes
· Type a Question Box
· Office Assistant
· Open Documents
· Search for Documents
· Reading Layout View
· Side-by-Side View

Section E: Creating New Documents
· Page Setup
· Date & AutoComplete
· Symbols
· AutoText
· AutoCorrect
· AutoCorrect Options
· AutoFormat

Section F: Proofing Documents
· Spelling Checker
· Spelling & Grammar
· Grammar Options
· Find & Replace
· Clipboard Replace
· Go To
· Word Usage Tools

Office 2003 Professional Series continued

Word 2003
Session 2

Section A: Basic Formatting
· Text Formatting
· Character Formatting
· Formatting Options
· Font Formatting
· Shortcuts
· Paragraph Formatting
· Paragraph Spacing
· Line & Page Breaks

Section B: Advanced Formatting
· Using Rulers
· Borders & Shading
· Applying Columns
· Formatting Columns
· Bulleted Lists
· Tabs
· Tables

Section C: Document Sections
· Insert Section Break
· View Section Break
· Header/Footer Options
· Create Header
· Page Border

Section D: Graphics
· Text Boxes
· Clip Art
· Picture Options
· Insert Picture
· Word Art
· Excel Worksheet
· Linking Documents

Section E: Charts & Diagrams
· Graph Charts
· Diagrams
· Modify Diagrams
· Organization Charts
· Modify Charts

Section F: Save Documents
· Document Properties
· Preview Document
· Save Option
· Change File Type
· Web Version
· View/Preview

Word 2003
Session 3

Section A: Printing
· Print Preview
· Print Dialog Box
· Zoom Options
· Printing Options
· Envelopes/Labels
· Envelope Formatting
· Envelope Printing
· Labels

Section B: Templates
· New Document
· Online Template
· Save Templates
· Template Location
· Attaching Templates
· Built-in Templates

Section C: Collaboration
· Track Changes
· Send Documents
· Review/Edit
· Add Comments
· Compare/Merge
· Show Change Options
· Accept/Decline
· Reviewing Pane

Section D: Menus & Toolbars
· Toolbar Control
· Customizing Options
· Custom Toolbar
· Customize Menu
· Customize Order

Section E: Basic Styles
· Current Styles
· Style & Formatting
· Apply Styles
· View Styles

Section F: Advanced Styles
· Customized Styles
· Modify Paragraph Style
· Styles with Borders
· Create New Style
· Character Style
· Apply Style
· Bullet/List Styles
· Apply Bullet Style

Word 2003
Session 4

Section A: Draw Table
· Insert Table Button
· Format Cells
· Add Data
· Navigate
· Insert Table Menu
· Calculations

Section B: Formatting Tables
· Select/Delete
· Format Options
· Header Rows
· Resize Cells
· Move Tables
· Sort Data
· Table Styles

Section C: Document Effects
· Watermarks
· Picture Watermarks
· Themes

Section D: Navigate within Documents
· Go To
· Browse By
· Split Windows
· Multiple Windows
· Bookmarks
· Using Bookmarks
· Hyperlinks
· Hyperlink Navigation

Section E: Creating References
· Footnotes/Endnotes
· Footnote Content
· Footnote Shortcut
· Format Footnotes
· Move/Delete Footnotes
· Captions
· Table of Figures

Section F: Index/Table of Contents
· Indexing
· Cross References
· Subentry
· Create Index
· Table of Contents
· Edit Table of Contents

Section G: Master Documents
· Using Master Documents
· Insert Subdocuments
· Edit Subdocuments
· Work with Subdocuments

Word 2003
Session 5

Section A: Outlines/Summaries
· Outline View
· Working with Outlines
· Promote/Demote
· Adding Text
· Expand/Collapse
· AutoSummarize

Section B: Forms
· Form Overview
· Text Form Field
· Drop-Down Form Field
· Calculations
· Form Control
· Help Text
· Protect Document
· Validate Form

Section C: Mail Merge
· Merge Components
· Mail Merge Template
· Mail Merge Wizard
· Lists
· Write Email
· Address Block
· Complete Merge
· Labels

Section D: XML
· What is XML?
· Schema
· Transform
· XML in Word
· Saving in XML

Section E: Macros
· Introduction
· Creating Macros
· Recording Macros
· Signature Block
· Organizer Tool

Section F: Security
· Document Protection
· Security Tab
· Document Properties
· Digital Signatures
· Apply Signatures

Section G: Application Maintenance
· Application Recovery
· Save My Settings
· Updates
· Detect & Repair