LearnKey Training

Office 2003 Fundamental Series

ASP.NET 2.0


Office 2003 Fundamental Series

5 Sessions –
3 Hours of Interactive Training
A complete understanding of Microsoft Office is required for success in today’s fast-paced, collaborative business world. With Office 2003 Fundamentals from LearnKey, you’ll get Session 1 of 5 Courses: Word 2003, Excel 2003, Outlook 2003, PowerPoint 2003 and Learning Windows XP. Expert instructors, Erin Olsen and Erica Wadley, will guide you step-by-step through the basics of each course to provide you with a solid foundation for success with Microsoft’s core applications.

Benefits
  • Quickly gain an in-depth overview of Microsoft’s most popular applications.
  • Be confident in selecting the best application for the office tasks at hand.
  • Begin to 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.
    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

    Learning Windows XP
    Session 1

    Section A: What is Windows XP?
    · Introduction
    · Why Windows XP?
    · System Requirements
    · Activate Windows

    Section B: Working with Windows
    · Desktop
    · Basic Layout
    · Icons
    · Opening Windows
    · Window Characteristics
    · Window Controls
    · Resize Windows
    · Arrange Windows
    · Taskbar

    Section C: Working with Programs
    · Basic Program Layout
    · WordPad Program
    · Scrolling in Documents
    · Moving Insertion Point
    · Delete & Insert Key
    · Selecting Text
    · Cut, Copy & Paste
    · Working with Multiple Programs

    Section D: Files & Folders
    · Organization
    · View Folder Structure
    · Working with Folders
    · Search for Files

    Section E: Organizing Workspace
    · Personal Desktop
    · Shortcuts
    · Start Menu
    · Start Properties
    · Display as Menu
    · Taskbar
    · Quick Launch

    Section F: Enhanced Setting
    · Accessibility Options
    · Narrator
    · On Screen Keyboard
    · Accessibility Wizard
    · Mouse
    · Utility Manager

    Section G: Help & Support
    · Locate a Topic
    · Help Options
    · Search Options
    · Navigate Help
    · History & Favorites
    · Online Support

    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

     



    Office 2003 Fundamental 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

    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