LearnKey Training

Office XP Professional
Office XP Professional


Office XP Professional

15 Sessions –
45 Hours of Interactive Training
Office XP is Microsoft’s latest version of the most popular office productivity software suite. With the Office XP Professional Series of training courses from LearnKey, you’ll easily learn to use Access 2002, Excel 2002, Outlook 2002, PowerPoint 2002 and Word 2002. LearnKey expert instructors will quickly have you managing documents, organizing your communications and building spreadsheets, databases and professional looking presentations. At the conclusion of this series, you’ll feel confident using the 2002 version of the Office programs and understand basic and advanced features.

Benefits
  • Quickly gain mastery of Microsoft 2002 office products and maximize your productivity.
  • Be confident in understanding the best tool to make office tasks a breeze.
  • This course covers all the objectives for the Microsoft Office Specialist exams.
    • Also Available:
    · Study Guide
    About The Authors
    Casey McNeal is the founder of Meridian Technical Services, Inc., which provides training and consulting services for organizations worldwide.
    Joe Healey's message comes from real-world experience. He spent several years in corporate banking with the then ninth largest bank, Mellon Bank.
    Reed Jacobson is the author of the book Excel Visual Basics Step by Step. He has been a featured presenter at Microsoft conferences.
    Since founding PCKeys Technology Solutions in 1995, Erin Olsen has personally trained more than 10,000 people worldwide.
    Nikki O'Connell is president of Noetics, a professional software organization that specializes in designing custom applications and training users.
    Access 2002
    Session 1

    Section A: Introduction
    · Database Concepts
    · Relational Databases
    · Task Pane
    · Tables
    · Forms
    · Queries & Reports

    Section B: Database Wizard
    · Database Development
    · Build a Database

    Section C: Table Essentials
    · Table Wizard
    · Relationships
    · Field Names
    · Text & Number Data Types
    · Other Data Types
    · Primary Key

    Section D: Datasheet View
    · Add New Record
    · Delete Record
    · Office Clipboard

    Section E: Table Appearance
    · Column Width
    · Font & Cell Effects
    · Moving & Hiding Columns

    Section F: Filter Techniques
    · Sorting Records
    · Find a Record
    · Filter By Selection

    Section G: Query Essentials
    · Relationships
    · Query Wizard
    · Dynaset Concepts
    · Add Criteria
    · Comparison Operator
    · Wildcards

    Section H: Form Essentials
    · Form Wizard
    · AutoForm

    Section I: Report Essentials
    · Report Wizard
    · Calculated Control
    · Print Preview
    · Label Wizard


    Session 2

    Section A: Field Properties
    · Field Size
    · Data & Time
    · Context Sensitive Help
    · Yes & No Fields
    · Default Value
    · Validation Rule
    · Indexed Field

    Section B: Create a Lookup
    · Insert a field
    · Lookup Wizard
    · Limit to List

    Section C: Importing & Exporting Data
    · Export to Excel
    · Import from Access
    · Import from Excel
    · Link Data from Excel
    · Share a Database
    · Database Splitter

    Section D: Relationships
    · Relate Tables
    · Referential Integrity
    · Cascade Options
    · Print Relationships

    Section E: Advanced Query Techniques
    · Parameter Queries
    · Multiple Parameters
    · Calculated Fields
    · Expression Builder
    · Summary Queries

    Section F: Using Access & HTML
    · Properties of HTML
    · Creating a Hyperlink
    · Using Hyperlinks
    · Publish Database to HTML Format
    · Creating Data Access Pages
    · Accessing Access Pages in Browser


    Session 3

    Section A: Merging Access into Word
    · Mail Merge Wizard
    · Create Letter
    · Run Merge

    Section B: Action Queries
    · Make Table Query
    · Append or Delete Query
    · Run Delete Query
    · Update & Print Queries

    Section C: Compact & Backup
    · Compact & Repair Utility
    · Backup & Restore Tool

    Section D: Form Design
    · Print Records
    · Form Controls
    · Calculated Controls
    · Object Properties
    · Event Procedures
    · Working with Controls

    Section E: Advanced Form Design
    · Adding Fields
    · Saving & View Form
    · Adjust Tab Order
    · Add Combo Box
    · Add Command Button
    · Add Graphic
    · Add Header & Footer
    · Add ActiveX Control
    · Input Mask Wizard

    Section F: Report Design
    · Headers & Footers
    · Move & Resize Controls
    · Add Controls
    · Add Calculated Control
    · Add Group & Sorting Control
    · Pagebreak Control
    · Report Footer

    Section G: Macros
    · Creating, Saving & Running Macros
    · Perform Queries from Macros
    · Assigning a Macro to Event Procedures

    Section H: Switchboard
    · Creating Switchboard
    · Editing Switchboard
    · Switchboard in Action
    · Set a Startup Option

    Excel 2002
    Session 1

    Section A: Introduction & Simple Lists
    · Cell Reference
    · Creating Lists
    · Simple Formatting
    · AutoFill Values
    · Format Painter

    Section B: Workbooks & Worksheets
    · Save a Workbook
    · File Properties
    · Rename & Delete Worksheets
    · Move & Copy Worksheet
    · Printing a Workbook

    Section C: Manipulating Values
    · Editing Values
    · Insert, Delete & Move Cells
    · Copy Cells
    · Comments
    · AutoFilter
    · Find & Replace

    Section D: Charts
    · Create a Chart
    · Chart Options
    · Manipulate Values
    · Chart Type
    · Secondary Axis
    · Add Values

    Section E: Summarizing Values
    · New Worksheet
    · Add Values
    · AutoSum & AutoFormat
    · Modifying Format Styles

    Section F: Formatting & Graphics
    · Create a Grid or Border
    · WordArt
    · Add Text
    · Merge & Center
    · Insert Clip Art
    · Drawing Object
    · Rotated Text
    · Print Preview

    Section G: Using Help
    · Tool Tips
    · Office Assistant
    · Ask a Question Box
    · Context Sensitive Help
    · Comprehensive Help


    Session 2

    Section A: Financial Functions
    · Loan Calculation
    · Insert Function
    · Name Ranges
    · Amortization Table
    · Future Value
    · Date Functions
    · Dynamic Dates

     


    Office XP Professional continued

    Section B: What-If Analysis
    · Goal Seek Command
    · Create Scenarios
    · View Scenarios
    · Single-input Data Table
    · Two-input Data Table

    Section C: Relative & Absolute References
    · Expense Allocation
    · Formula Auditing
    · Trace Precedents
    · Finding Errors
    · References
    · Evaluate Formulas

    Section D: Protection
    · Protect Worksheet
    · Unlock Cells
    · Protection Options
    · Protect Workbook
    · Control Input

    Section E: Lookups
    · Named Range
    · Exact Lookup
    · Bonus Amount
    · Range Lookup
    · Moving Ranges
    · External References
    · Update & Repair Links
    · Hyperlinks

    Section F: Advanced Formatting
    · Custom Number Formats
    · Conditional Formatting

    Section G: Consolidating Values
    · Budget Template
    · Save As Template
    · Enter Values
    · Consolidate: Sum
    · Consolidate: Link
    · Create Workspace
    · 3D Formulas

    Section H: Sharing Workbooks
    · Share a Workbook
    · Track Changes
    · Merge Workbooks


    Session 3

    Section A: Creating Sample Data
    · Sample Database
    · Replicate Ranges
    · Sort Command
    · Random Numbers

    Section B: Exporting & Importing Data
    · Export to Text
    · Export to Database
    · Import from Database
    · Import from Text
    · Import Text Wizard

    Section C: Advanced Filters
    · Custom AutoFilter
    · Advanced Filter
    · Extract a List

    Section D: Subtotals & Outlines
    · Subtotal
    · Outline
    · Nesting Subtotals
    · Manual Grouping

    Section E: Summarizing with a PivotTable
    · Create a PivotTable
    · PivotTable Field List
    · Manipulate a PivotTable
    · Format
    · Group Data
    · Create a PivotChart
    · Manipulate a PivotChart
    · AutoFormat

    Section F: Publishing Workbooks
    · Preview Large Document
    · Freeze Headings
    · Header
    · Footer
    · Preview a Chart
    · Print a Chart
    · Static HTML Page
    · PivotTable Interactivity
    · Spreadsheet Interactivity
    · Web Queries

    Section G: Creating Macros
    · Record Macros
    · Play Macros
    · Visual Basic
    · Edit a Macro
    · Toggle Macro

    Section H: Adding User Interface
    · Custom Toolbar
    · Menu Command
    · Security Level
    · Workbook Button


    Outlook 2002
    Session 1

    Section A: Introduction
    · Outlook Features
    · Email Options
    · Outlook Interface
    · Navigation Options
    · Outlook Today
    · Customize Outlook Today

    Section B: Creating Messages
    · Using the Inbox
    · Create New Message
    · Addressing Options
    · Name Checking
    · Completing Your Message
    · Send Message

    Section C: Working With Messages
    · Changing Format
    · Spell Check
    · Creating Signatures
    · Formatting Signature
    · Stationery
    · Save a Draft

    Section D: Distribution Lists
    · Creating
    · Select Members
    · Use List & Edit List

    Section E: Attachments
    · Insert Text
    · Insert Hyperlink
    · Attach Files

    Section F: Messaging Options
    · Importance & Sensitivity
    · Voting Buttons
    · Delivery Options

    Section G: Sending & Receiving
    · Inbox
    · Preview & Auto Preview
    · Using Voting Buttons
    · Saving Mail Messages
    · Setting Flags
    · Forward Message
    · Printing Messages
    · Message Tracking

    Section H: Customizing Mail
    · Email Options
    · Reply & Forward Options
    · Mail Format Options
    · Signature Options
    · Out of Office Assistant

    Section I: Organize
    · Sorting Mail
    · Follow-up Flags
    · Create Folder
    · Create Mail Rule
    · Delete Items

    Section J: Getting Help
    · Office Assistant
    · Ask a Question
    · Using Help Dialog Box


    Session 2

    Section A: Creating Contacts
    · Create a Contact
    · General Information
    · Phone Number & Email Address
    · Mailing Address
    · Internet
    · Comments & Categories
    · Create New from Same Company
    · Contact Views

    Section B: Using Contacts
    · Printing Contacts
    · Print Style Options
    · Print Preview & Page Configuration
    · Import Information
    · Import from Excel File
    · Map Custom Fields
    · Exporting Contacts
    · Confirm Export
    · Contact Address on Internet

    Section C: Getting More From Contacts
    · Create Contact from Message
    · Create New Letter to Contact
    · V-Cards
    · Receive V-Card

    Section D: Scheduling Appointments
    · Add Appointment
    · Appointment Options
    · Local vs. Exchange Mailbox
    · Auto Date
    · Reminder Window
    · Recurring Events
    · Setting Recurrence
    · Multi-day Appointments

    Section E: Working With Appointments
    · Move & Cancel
    · Change Multi-Day Appointments
    · Configure Default Options
    · Add Holidays
    · Print Calendar
    · Publish Calendar

    Section F: Scheduling Meetings
    · Create a Meeting
    · Response to Meeting
    · Move Meeting
    · Accept
    · Tracking
    · Delete a Meeting
    · Group Schedule
    · View Group Schedules

    Section G: Creating Tasks
    · Working with Lists
    · Create New Task
    · Task Tracking
    · Recurring Tasks
    · Assign Tasks
    · Accept Assigned Tasks
    · Email to Task
    · Add Task to Calendar


    Session 3

    Section A: Creating Journal Entries
    · Journal Options
    · Create Journal Entry
    · Apply to Contact
    · Configure Contact
    · Manage by Contact

    Section B: Creating Notes
    · Note Usage
    · Move Note to Desktop
    · Customize Notes
    · Forward Notes
    · Managing Notes

    Section C: Customizing Views
    · Define Views
    · Create New View
    · View Filters
    · Delete Custom View

    Section D: Mail Merge
    · Mail Merge Contacts
    · Contacts Options
    · Mail Merge Helper
    · Insert Merge Fields
    · Format Document
    · Preview & Complete Merge

    Section E: Archiving Data
    · Auto Archive Setup
    · Default Archive Settings
    · Manual Archive
    · Individual Folder Auto Archive Settings
    · Mailbox Cleanup

    Section F: Delegation
    · Setup Delegates
    · Delegate Permissions
    · Add Delegated Folders to View
    · Working with Delegated Folders

     



    Office XP Professional continued

    Section G: Public Folders
    · Create New Folder
    · Create Public Contact
    · Notify Others
    · Delete Public Folders

    Section H: Working With Forms
    · Custom Forms
    · Create Custom Forms
    · Adding Fields to Forms
    · Publish Custom Forms
    · Using Custom Forms
    · Select Startup Form

    Section I: Synchronization
    · Setup Offline Folders
    · Connection State
    · Create Send & Receive Group
    · Synchronization Options


    PowerPoint 2002
    Session 1

    Section A: Introduction
    · PowerPoint Interface
    · Objects in PowerPoint
    · Using the Interface
    · Image Files
    · Output Planning

    Section B: Using PowerPoint
    · Normal View
    · Slide Sorter View
    · Notes Page View
    · Print Options
    · Working with Objects
    · Slide Show View

    Section C: Customizing the Interface
    · Toolbars
    · Create New Toolbar
    · Add Buttons to Toolbar
    · Screen Toolbars

    Section D: Templates & Wizards
    · Design Templates
    · Backgrounds
    · PowerPoint 2000 Style Templates
    · Change Slide Layout
    · Auto Content Wizard

    Section E: Presentation Planning
    · Master View
    · Edit Font
    · Create New Presentation
    · Picking a Background
    · Import Images to PowerPoint
    · Resize Images
    · Format Text
    · Insert New Slide

    Section F: Working With Text
    · Copy Slide Content
    · Tri-pane View
    · Edit Text in Normal View
    · Font Styles
    · Planning Style & Color
    · Delete & Create Text Box
    · Text Shadow & Alignment

    Section G: Text Levels & Saving
    · Text Levels
    · Enter Text in Outline View
    · Format Painter
    · Demoting & Promoting
    · Saving Files
    · Saving Options


    Session 2

    Section A: Tools for Text
    · Prepare Word File for Import
    · Import Preparations
    · Import Outline
    · Office Clipboard
    · Spell Checking

    Section B: Working With Graphics
    · Types of Graphics
    · Insert Clip Art
    · Using Clip Organizer
    · Automatic Layout
    · Set Transparent Color
    · Insert Text on Graphic

    Section C: Creating Shapes
    · AutoShapes
    · Fill Effects
    · Layers
    · Grouping Objects
    · Rotate Objects
    · Layout Options
    · WordArt
    · 3-D Styles

    Section D: Tables
    · Insert Chart
    · Insert Table
    · Create a Chart
    · Chart Toolbar
    · Create a Table
    · Link to Excel Database
    · Update Chart Information

    Section E: Bullets & Numbering
    · Auto Numbering
    · Choosing Bullets
    · Adjusting Indents
    · Import Graphic Bullets
    · Edit Bullets in Master View

    Section F: Animation
    · Set Animation in Master View
    · Animate Subtext
    · Preview Animations
    · Animate Objects
    · Sound Effects
    · Chart Animation

    Section G: Presentation Skills
    · Room Setup
    · Slide Usage & Timing
    · Slide Navigation
    · Options
    · Pen Pointer
    · Switch Between Presentations

    		Session 3

    Section A: Slide Transitions
    · Understanding Audience
    · Pacing & Style
    · Transitions
    · Transition Options
    · Concerns with Sound
    · Slide Advance Delay
    · Enhance Transitions

    Section B: Sending Presentations
    · Sound
    · Record Presentations
    · Test Narration
    · Send Presentation
    · PowerPoint Show

    Section C: PowerPoint & the Web
    · Import Images
    · Import Text
    · Web Page Preview
    · Web Consideration
    · Publish as Web Page

    Section D: Tips & Tricks
    · AutoCorrect
    · Find & Replace
    · Grid & Guides
    · Insert Hyperlink
    · Using Hyperlinks
    · Edit Hyperlinks

    Section E: Print Tools
    · Page Setup
    · Custom Paper Size
    · Photo Album
    · View in Grayscale
    · Print Options

    Section F: Powerful Visuals Made Easy
    · Insert Video
    · Format Video Object
    · Video in Presentation
    · Best Practice for Video
    · Office Assistant
    · Close


    Word 2002
    Session 1

    Section A: Introduction
    · Open Word
    · Open Dialog Box
    · Files & Folders
    · Open Documents
    · Copy & Paste
    · Paste Options
    · The Office Clipboard
    · Review

    Section B: Automating Content Creation
    · Save As Template
    · AutoCorrect
    · AutoComplete
    · AutoText
    · Spelling Checker
    · Create AutoText
    · Grammar Checker

    Section C: Lists
    · Bulleted Lists
    · Customize Bullets
    · Numbered Lists
    · Change Order
    · Outline Numbered Lists
    · Customize Outline Lists
    · Sort Lists

    Section D: Formatting Techniques
    · Keyboard Shortcuts
    · GoTo
    · Scrollbar
    · Paragraph Formatting
    · Paragraph Indent
    · Font Formatting
    · Borders & Shading
    · Text Effects
    · Format Painter
    · Repeat Command

    Section E: Styles
    · Reveal Formatting
    · Create a Style
    · Apply Styles
    · Manage Styles

    Section F: Understanding & Creating Tables
    · Introduction to Tables
    · Types of Tables
    · Create a Table
    · Adjust Column Width

    Section G: Saving, Sending, & Printing
    · Save As
    · Save As Web Page
    · Print Preview


    Session 2

    Section A: Using Graphics
    · Insert Clip Art
    · Format Clip Art
    · Image Control Options
    · Insert Picture
    · WordArt
    · Diagrams

    Section B: Sections
    · Insert Section Break
    · Page Orientation
    · Remove Section Break
    · Title Page

    Section C: Columns
    · Format Columns
    · Remove Columns
    · Balance Columns
    · Newspaper Columns
    · Insert Column Break

    Section D: Headers & Footers
    · Page Numbers
    · Edit Footer
    · Date & Time

    Section E: Advanced Headers & Footers
    · Initial Header & Footer
    · Section Page Numbering
    · Unlink

     


    Office XP Professional continued

    Section F: Forms
    · Save As Template
    · Form Controls
    · Form Controls Cont.
    · Protect Form

    Section G: File Locations
    · Documents File Location
    · Workgroup Template

    Section H: Mail Merge
    · Create Envelope
    · Envelope Options
    · Create Labels
    · Mail Merge Wizard
    · Create Address List
    · Insert Merge Fields
    · Preview & Print

    Section I: Advanced Mail Merge
    · Envelope Merge
    · Merge with Excel Data Source
    · Merge Using Outlook Contacts


    Session 3

    Section A: Setting Up Long Documents
    · Table of Contents
    · Index
    · Table of Authorities
    · Table of Figures
    · Footnotes

    Section B: Managing Long Documents
    · Comments
    · Cross References
    · Hyperlinks
    · Bookmark Link
    · Paste as Hyperlink
    · Web Page Link

    Section C: Master Documents
    · Master & Subdocuments
    · Create Subdocuments
    · View Master
    · Insert Subdocument

    Section D: Versions & Tracking Control
    · Multiple Versions
    · View Versions
    · Distribute Document
    · Tracking
    · Accept & Reject Changes
    · Compare & Merge

    Section E: Advanced Table Functions
    · Table Properties
    · Table Layout
    · Table Header Row
    · Working with Columns
    · Split Columns
    · Calculating in Word
    · Advanced

    Section F: Creating Charts
    · Using Data from Excel
    · Create Graph Chart
    · Change Chart Type
    · Embed Excel Chart

    Section G: Web Page Creation
    · Web Page Wizard
    · Add Visual Themes
    · Web Site Design
    · Add Hyperlink
    · Insert File
    · Save Project

    Section H: Create Shortcuts
    · Building Macros
    · Record Macro
    · Use Macro
    · Macro Button
    · Modify Macros
    · Customize Menu
    · Digital Signatures