AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

Microsoft Office 2002 (XP) Essentials

Print Version

Let the professsionals walk you and your staff through each of your Office XP applications. Basic and power users alike will gain important office insights from the industry's top professional trainers! Go at your own pace and learn all about Access, Excel, Outlook. PowerPoint and Word.

5 courses - 15 levels - 431 training modules - 45 learning hours

 

Available Options

SINGLE USER: Microsoft Office XP (15 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$595.00Add To Cart
1 YR ONLINE, e-Study Guides$595.00Add To Cart
CD-ROMs, e-Study Guides$595.00Add To Cart
MULTI USER: Microsoft Office XP (15 levels)
Makau Course Cover - Box Shot  
CD-ROMs, e-Study Guides$1,190.00Add To Cart
For additional licensing options. pricing and information, call 877-752-3529

Course Instructor: Rick James and Dennis Taylor

Rick James has worked in the computer industry since 1985, when he began his career as a computer science major working for WordPerfect Corporation. His interests later turned from software development to business and marketing within the computer industry. James was a co-founder of Makau Corporation. His goal is to provide good technical and business training in laymen's terms. He presents complex concepts in ways that all employees in an organization or an individual student can understand.

Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Dennis brings a combination of in-depth knowledge and training experience to his spreadsheet training courses. Watch and Learn in minutes with Dennis.

Course Outline

Level 1 Introduction

1.0 Introduction to Access

  • 1.1 Overview of Access
  • 1.2 Tables
  • 1.3 Forms
  • 1.4 Queries
  • 1.5 Reports
  • 1.6 Section Summary

2.0 Creating a Database

  • 2.1 Create a Blank Database
  • 2.2 Creating a Table Using the Wizard
  • 2.3 Creating a Table in the Design View
  • 2.4 Creating a Table with Data Entry
  • 2.5 Creating a Table by Importing Data
  • 2.6 Section Summary

3.0 Table Utilities

  • 3.1 Adding & Deleting Records
  • 3.2 Adding & Deleting Fields
  • 3.3 Printing Tables
  • 3.4 Section Summary

4.0 Table Appearance

  • 4.1 Hiding, Freezing, and Moving Columns
  • 4.2 Fonts and Colors
  • 4.3 Section Summary

5.0 Table Data Features

  • 5.1 Finding & Replacing Data
  • 5.2 Sorting Data
  • 5.3 Filtering Data
  • 5.4 Section Summary

6.0 Query Essentials

  • 6.1 Setting Criteria
  • 6.2 Wildcards

Level 2 Introduction

1.0 Form Essentials

  • 1.1 Creating Forms with AutoForm
  • 1.2 Section Summary

2.0 Report Essentials

  • 2.1 Exporting Reports
  • 2.2 Using the Label Wizard
  • 2.3 Section Summary

3.0 Field Properties

  • 3.1 Date and Time
  • 3.2 Custom Formats
  • 3.3 Yes & No Fields
  • 3.4 Default Value & Expression Builder
  • 3.5 Validation Rule
  • 3.6 Section Summary

4.0 Creating a Lookup

  • 4.1 Limit to List
  • 4.2 Section Summary

5.0 Importing and Exporting Data

  • 5.1 Linking Data from Excel
  • 5.2 Section Summary

6.0 Relationships

  • 6.1 Creating Table Relationships
  • 6.2 Enforcing Referential Integrity
  • 6.3 Understanding Cascade Options
  • 6.4 Printing Database Information

Level 3 Introduction

1.0 Advanced Query Techniques

  • 1.1 Reports Based on Parameter Queries
  • 1.2 Setting up Calculated Fields
  • 1.3 Overview of the Expression Builder
  • 1.4 Creating Summary Queries
  • 1.5 Section Summary

2.0 Access & HTML

  • 2.1 Publishing Database to HTML Format
  • 2.2 Data Access Pages
  • 2.3 Section Summary

3.0 Merging Access into Word

  • 3.1 Running the Merge
  • 3.2 Section Summary

4.0 Action Queries

  • 4.1 Running an Append Query
  • 4.2 Running a Delete Query
  • 4.3 Running a Update Query
  • 4.4 Section Summary

5.0 Database Maintenance

  • 5.1 Database Backup
  • 5.2 Section Summary

6.0 Advanced Form Design

  • 6.1 Creating & Using Form Controls
  • 6.2 Calculated Controls
  • 6.3 Section Summary

7.0 Advanced Form Modification

  • 7.1 Adding Fields
  • 7.2 Adjusting Tab Order
  • 7.3 Section Summary

8.0 Advanced Report Design

  • 8.1 Modifying Controls
  • 8.2 Adding Controls
  • 8.3 Sorting and Grouping Report Data
  • 8.4 Working with the Pagebreak Control
Level 1
The Excel Screen
  • 1.1 The Excel Workbook
  • 1.2 The Task Pane
  • 1.3 Title Bar and Menu Bar
  • 1.4 Toolbars
  • 1.5 Formula
  • 1.6 Columns & Rows
  • 1.7 Navigation
  • 1.8 Sheet Names & the Status Bar
  • 1.9 Mouse Pointers & Shortcut Menus
Entering Data
  • 2.1 Data Entry Techniques
  • 2.2 AutoFill Entry Techniques
  • 2.3 Erasing Data
  • 2.4 AutoComplete & Pre-selection
  • 2.5 IP Classes
Entering Formulas
  • 3.1 Three Methods of Entering Formulas
  • 3.2 Repeating a Formula in Adjacent Cells
  • 3.3 Additional Formulas
Basic Excel Functions
  • 4.1 Summation & Averaging
  • 4.2 Recalculating Effects
  • 4.3 Other Functions
Formatting
  • 5.1 The Formatting Toolbar
  • 5.2 Adjusting Column Widths
  • 5.3 Numeric Formatting
Saving, Opening and Closing Files
  • 6.1 File Save or File Save As
  • 6.2 Opening & Closing a File
  • 6.3 Creating a New Workbook

The Excel Help System


Level 2
Changing Worksheet Layout
  • 1.1 Inserting Columns/Rows/Cells
  • 1.2 Deleting Columns/Rows/Cells
  • 1.3 Moving Cells
  • 1.4 Copying Cells
Additional Formatting
  • 2.1 Formatting Cell Attributes & Alignment
  • 2.2 Borders
  • 2.3 Numeric Formatting
  • 2.4 Centering Text Across Columns
  • 2.5 Hiding and Unhiding Columns & Rows
Printing
  • 3.1 Using Print Preview & Page Setup
  • 3.2 Printing Controls
  • 3.3 Using Page Break Preview
Using Cell References
  • 4.1 Absolute References
  • 4.2 Mixed References
The Tools Options Command
  • 5.1 Show/Hide Gridlines
  • 5.2 File List & New Workbook
  • 5.3 Default Settings
Introduction to Charting-An Overview
  • 6.1 Quick Chart Creation
  • 6.2 Chart Types
  • 6.3 Titles/Gridlines & Scaling
  • 6.4 Formatting Basics
  • 6.5 Printing & Copying Charts
Level 3
Adjusting Worksheet Views
  • 1.1 Freeze/Unfreeze Panes
  • 1.2 Horizontal & Vertical Split Screens
Formula Auditing Techniques
  • 2.1 Using the Formula Auditing Toolbar
  • 2.2 Tracing Dependent Cells
  • 2.3 Tracing Precendent Cells
The IF and VLOOKUP Functions
  • 3.1 IF & VLOOKUP Functions Operators
  • 3.2 Logical Operators
  • 3.3 Nested IF Functions
  • 3.4 Getting Data from Tables
Dates & Times
  • 4.1 Using Dates as Values
  • 4.2 Entering a Series of Dates
  • 4.3 Date/Time Entry Techniques
Multi-Sheet Workbooks
  • 5.1 Renaming Sheets
  • 5.2 Inserting & Deleting Sheets
  • 5.3 Moving/Copying & Grouping
  • 5.4 Formulas across Multiple Sheets
Introduction to Database Features
  • 6.1 Sorting Data
  • 6.2 Creating Subtotals
  • 6.3 Filtering
  • 6.4 Pivot Tables
Level 1 Introduction

1.0 Introducing Outlook
  • 1.1 Launching Outlook
  • 1.2 Overview of the Outlook Interface
  • 1.3 Folder List
  • 1.4 Outlook Today
2.0 Reading Mail Messages
  • 2.1 Opening and Closing a Mail Message
  • 2.2 Accessing Attachments
3.0 Deleting Items in Outlook
  • 3.1 Restoring a Deleted Item
4.0 Sending Mail Messages
  • 4.1 Sending a New Mail Message
  • 4.2 Adding an Attachment to a Message
  • 4.3 Advanced Formatting Options
  • 4.4 Saving a Draft Message
  • 4.5 Sending to Multiple Recipients
  • 4.6 Sending Over the Internet
5.0 Replying, Forwarding Messages
  • 5.1 Replying to a Message
  • 5.2 Forwarding a Message to Someone Else
6.0 Using Outlook's Address Books
  • 6.1 Adding and Editing a Contact
  • 6.2 Adding a Contact From a Message
  • 6.3 Sending a Message From Contact List
  • 6.4 Using Distribution Lists
7.0 Printing
  • 7.1 Printing Items in Outlook
  • 7.2 Print Attachments
Level 2 Introduction

1.0 Managing Your Calendar
  • 1.1 Calendar Views and Display Options
  • 1.2 Setting Your Work Schedule
  • 1.3 Creating Personal Appointments
  • 1.4 Inviting Additional Attendees
  • 1.5 Checking Attendee Schedules
  • 1.6 Responding to a Meeting Request
  • 1.7 Creating Recurring Appointments
2.0 Managing Your Tasks
  • 2.1 Creating a Task and a Recurring Task
  • 2.2 Responding to a Task Request
  • 2.3 Scheduling Time For a Task
3.0 Using the Outlook Journal
  • 3.1 Tracking Contact Activities
  • 3.2 Creating a Journal Entry
4.0 Organizing Messages
  • 4.1 Creating Personal Folders
  • 4.2 Moving a Message to Another Folder
  • 4.3 Automating Your Mailbox
5.0 Outlook Help
  • 5.1 Accessing Online Help
Level 3 Introduction

1.0 Customizing Toolbars
  • 1.1 Displaying Toolbars
  • 1.2 Customizing Toolbars
  • 1.3 Creating a New Toolbar
  • 1.4 Customizing the Outlook Bar
2.0 Advanced Mail Message Options
  • 2.1 Automatic Spell Checking
  • 2.2 Auto Correct
  • 2.3 Message Signatures
  • 2.4 Additional Message Options
3.0 Finding Messages
  • 3.1 Finding Mail Messages
  • 3.2 Advanced Find
4.0 Recalling & Resending Messages
  • 4.1 Recalling a Message
  • 4.2 Resending a Message
5.0 Flagging Items
  • 5.1 Flagging an Item
  • 5.2 Sorting a Folder
  • 5.3 Marking a Flagged Item Complete
6.0 AutoArchive
  • 6.1 Using AutoArchive
  • 6.2 Viewing Archived Items
  • 6.3 Restoring Archived Items
7.0 Public Folders
  • 7.1 Creating a Public Folder
  • 7.2 Accessing and Using a Public Folder
Level 1 Introduction

1.0 Getting Started
  • 1.1 What is PowerPoint?
  • 1.2 Starting PowerPoint XP
  • 1.3 Touring the PowerPoint Window
2.0 Creating a New Presentation
  • 2.1 New Presentation Task Pane
  • 2.2 AutoContent Wizard
  • 2.3 Saving & Closing Your Work
  • 2.4 Creating from a Design Template
  • 2.5 Creating a Blank Presentation
3.0 Revising Presentations
  • 3.1 Opening an Existing Presentation
  • 3.2 Navigating in a Presentation
  • 3.3 Editing Text
  • 3.4 Viewing a Presentation
  • 3.5 Creating a New Slide
4.0 Getting Help
  • 4.1 Ask A Question Box
  • 4.2 Office Assistant
  • 4.3 PowerPoint Help Window
  • 4.4 Context-Sensitive Help
5.0 Outlining
  • 5.1 Entering Text in an Outline
  • 5.2 Inserting an Outline from Microsoft Word
  • 5.3 Modifying Slides, Paragraphs, & Text
  • 5.4 Exporting an Outline
6.0 Adding & Modifying Slide Text
  • 6.1 Adding & Moving Text
  • 6.2 Formatting Text & Symbols
  • 6.3 Changing Text Box Properties
  • 6.4 AutoCorrect & AutoFormat
  • 6.5 Outline vs. Slide
7.0 Preparing Presentations
  • 7.1 Checking Spelling
  • 7.2 Checking Presentation Styles
  • 7.3 Speaker Notes
  • 7.4 Adding a Header & Footer
8.0 Printing Presentations
  • 8.1 Page Setup & Preview
  • 8.2 Printing a Presentation
Level 2 Introduction

1.0 Developing Content
  • 1.1 Planning & Communicating Effectively
2.0 Managing Presentations
  • 2.1 Inserting Slides from Other Presentations
  • 2.2 File & Folder Management
  • 2.3 Search Task Pane
  • 2.4 Find & Replace
  • 2.5 Keyboard Shortcuts
3.0 Changing Design & Layout
  • 3.1 Applying a Design Template
  • 3.2 Changing the Layout of a Slide
4.0 Working with Masters
  • 4.1 Modifying the Slide Master
  • 4.2 Formatting Bullets
  • 4.3 Handout & Notes Masters
5.0 Graphics & Pictures
  • 5.1 Inserting Clip Art
  • 5.2 Inserting Pictures
  • 5.3 The Clip Organizer
  • 5.4 Modifying Images
6.0 Creating & Formatting Objects
  • 6.1 Adding & Editing an Object
  • 6.2 Formatting Objects
  • 6.3 Object Placement, Orientation, & Grouping
  • 6.4 Enhancing Text with WordArt
Level 3 Introduction

1.0 Working with Tables
  • 1.1 Creating Tables
  • 1.2 Modifying & Formatting Tables
2.0 Working with Graphs & Charts
  • 2.1 Inserting & Formatting a Graph
  • 2.2 Creating an Organization Chart
3.0 Organizing Your Presentation
  • 3.1 Rearranging & Summarizing Slides
  • 3.2 Hiding, Duplicating, & Deleting Slides
4.0 Customizing PowerPoint
  • 4.1 Menus & Toolbars
  • 4.2 Customizing the Workspace
  • 4.3 Changing User Options
5.0 Viewing & Changing Presentation Colors
  • 5.1 Viewing & Choosing a Color Scheme
  • 5.2 Creating a New Color Scheme
  • 5.3 Adding & Modifying a Slide Background
6.0 Creating a Custom Design Template
  • 6.1 Creating Multiple Master Slides
  • 6.2 Adding a Custom Background
  • 6.3 Saving & Applying a Custom Template
7.0 Preparing & Delivering a Slide Show
  • 7.1 Adding Transitions
  • 7.2 Applying Other Animation
  • 7.3 Presenting a Slide Show
Beginning

1.0 Introduction to Word 2002
  • 1.1 Launching Word 2002
  • 1.2 Word Window Overview
2.0 Creating New Documents
  • 2.1 Creating a New Document
  • 2.2 Saving a Document
  • 2.3 Using a Template
  • 2.4 Using a Wizard
  • 2.5 Exiting Out of Word
3.0 Working with Existing Documents
  • 3.1 Opening a Document
  • 3.2 Navigating a Document
  • 3.3 Basic Editing
  • 3.4 Adding a Date
  • 3.5 Adding an Envelope
  • 3.6 Printing a Document
  • 3.7 Updating the Saved Document
4.0 Getting Help
  • 4.1 Ask a Question
  • 4.2 Office Assistant
  • 4.3 Word Help Window
  • 4.4 Context Sensitive
5.0 Essential Skills
  • 5.1 Shortcuts
  • 5.2 Toolbars
  • 5.3 Selecting Text
  • 5.4 Copying & Moving Text
  • 5.5 Clipboard Task Pane
  • 5.6 Undo/Redo & Repeat
6.0 Proofreading Documents
  • 6.1 Spelling & Grammar
  • 6.2 Thesaurus & Word Count
7.0 Level Summary

Intermediate

1.0 Managing Documents
  • 1.1 Working with Multiple Documents
  • 1.2 File & Folder Management
  • 1.3 Search Task Pane
2.0 Formatting Text & Paragraphs
  • 2.1 Working with Fonts
  • 2.2 Formatting Paragraphs
3.0 Additional Editing Tools
  • 3.1 Special Characters & Autocorrect
  • 3.2 Auto Complete
  • 3.3 Auto Text
  • 3.4 Find & Replace
  • 3.5 Format Painter
4.0 Page Layout
  • 4.1 Margins & Page Setup
  • 4.2 Adjusting Margins with Rulers
5.0 Introduction to Graphics
  • 5.1 Inserting Clip Art
  • 5.2 Inserting Picture Files
  • 5.3 AutoShapes
  • 5.4 WordArt
6.0 Level 2 Summary
Advanced

1.0 Understanding Formatting in Word
  • 1.1 Formatting Choices
  • 1.2 Reveal Formatting Task Pane
2.0 Paragraph Formatting
  • 2.1 Tabs
  • 2.2 The IP Address
  • 2.3 Spacing Before & After
  • 2.4 Line Breaks
  • 2.5 Bullets & Numbering
  • 2.6 Outlines
  • 2.7 Sorting Text
  • 2.8 Borders & Shading
3.0 Document Formatting
  • 3.1 Numbering Pages
  • 3.2 Headers & Footers
4.0 Columns
  • 4.1 Working with Columns
5.0 Formatting with Styles
  • 5.1 Applying Styles
  • 5.2 Styles & Formatting Task Pane
  • 5.3 Modifying an Existing Style
  • 5.4 Creating a Style
6.0 Tables
  • 6.1 Inserting Tables
  • 6.2 Modifying Tables
  • 6.3 Formatting Tables
  • 6.4 Formulas
  • 6.5 Creating a Chart
7.0 Complex Documents
  • 7.1 Bookmarks
  • 7.2 Table of Contents & Indexes
8.0 Level 3 Summary