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 2000 Essentials

Print Version

This Microsoft Office training series will enhance your skills and knowledge on the popular Office 2000 suite of desktop applications. Learn from expert applications instructors, Rick James and Dennis Taylor as they take you through the finer points of Access, Excel, PowerPoint and Word.

4 courses - 12 levels - 403 training modules

 

Available Options

SINGLE USER: Microsoft Office 2000 (12 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$495.00Add To Cart
1 YR ONLINE, e-Study Guides$495.00Add To Cart
CD-ROMs, e-Study Guides$495.00Add To Cart
MULTI USER: Microsoft Office 2000 (12 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$990.00Add To Cart
CD-ROMs, e-Study Guides$990.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

Access 2000 Level 1

1.0 Introduction
  • 1.1 Starting Access
  • 1.2 Opening an Existing Database
  • 1.3 The Access Desktop
  • 1.4 The Database Window
  • 1.5 A Preview of the Database Components
2.0 Working with an Existing Database
  • 2.1 Viewing & Navigating Table Data
  • 2.2 Editing Table Data
  • 2.3 Adding Records to a Table
  • 2.4 Selecting & Deleting Records
  • 2.5 Find & Replace
  • 2.6 Modifying the Appearance of a Datasheet
  • 2.7 Spell-Check & Auto-correct
3.0 Form Basics
  • 3.1 Moving from Record to Record
  • 3.2 Finding
  • 3.3 Sorting
  • 3.4 Filtering
  • 3.5 AutoForms
  • 3.6 Using a Form Wizard
  • 3.7 Conditional Formatting
4.0 Report Basics
  • 4.1 Moving form Page to Page
  • 4.2 Zooming In & Out
  • 4.3 Viewing Multiple Pages
  • 4.4 Printing
  • 4.5 AutoReports & the Report Wizard
  • 4.6 Page Setup
5.0 Printing Database Objects
  • 5.1 Printing Table Datasheets
  • 5.2 Printing Queries
  • 5.3 Printing Forms
  • 5.4 Printing Reports
6.0 Getting Help
  • 6.1 The Office Assistant & Index Searching
  • 6.2 Context-Sensitive Help & Printing Help Topics
7.0 Database Maintenance & Shortcuts
  • 7.1 Backing Up & Restoring a Database
  • 7.2 Compacting & Repairing a Database
  • 7.3 Converting a Database to a Previous Version
  • 7.4 Organizing Database Objects into Groups
Access 2000 Level 2

1.0 Planning & Designing a Database
  • 1.1 Evaluating Inputs & Outputs
  • 1.2 Normalization
  • 1.3 Creating a Database Using a Wizard
  • 1.4 Creating a Database from Scratch
2.0 Building & Modifying Tables
  • 2.1 Creating Tables Using a Wizard
  • 2.2 Creating Tables from Scratch & Data Types
  • 2.3 Setting Primary Keys
  • 2.4 Field Properties
  • 2.5 Input Masks
  • 2.6 The Lookup Wizard
  • 2.7 Indexes
3.0 Working with Relationships
  • 3.1 Introduction to Relationships
  • 3.2 Benefits of Relationships
  • 3.3 Types of Relationships
  • 3.4 Referential Integrity
  • 3.5 Indexes & Relationships
  • 3.6 Printing Relationships
4.0 Designing Simple Queries
  • 4.1 Selecting Fields & Ordering the Query Result
  • 4.2 Refining Queries with Criteria
  • 4.3 Updatability of Query Results
  • 4.4 Queries Based on Multiple Tables
Access 2000 Level 3

1.0 Building & Modifying Forms
  • 1.1 Adding Controls
  • 1.2 Selecting Controls
  • 1.3 Moving
  • 1.4 Aligning Controls
  • 1.5 Changing Control Properties
  • 1.6 Changing the Tab Order Controls
  • 1.7 Form Properties
  • 1.8 Working with Combo Boxes & List Boxes
2.0 Building & Modifying Reports
  • 2.1 Understanding Report Bands
  • 2.2 Working with Controls
  • 2.3 Creating Groups & Totals Reports
  • 2.4 Working with Report Properties
  • 2.5 Modifying Selection Criteria
3.0 Database Startup Options
  • 3.1 Setting the Application
  • 3.2 Designing other Startup Information
4.0 Importing
  • 4.1 Exporting to another Database
  • 4.2 Exporting to an Excel Spreadsheet
  • 4.3 Exporting to ASCII
  • 4.4 Exporting to HTML
  • 4.5 Importing from anther Access Database
  • 4.6 Importing Spreadsheet Data
  • 4.7 Importing ASCII Data
  • 4.8 Importing from HTML
  • 4.9 Linking to Anther Access Database
  • 4.10 Linking to anther types of Database
  • 4.11 The Linked Table Manager

Excel 2000 Level 1

1.0 The Excel Screen
  • 1.1 The Excel Workbook and Worksheets
  • 1.2 Title Bar and Menu Bar
  • 1.3 Toolbars
  • 1.4 Formula Bar
  • 1.5 Columns and Rows
  • 1.6 Navigation
  • 1.7 Sheet Names and the Status Bar
  • 1.8 Mouse Pointers and Shortcut Menus
  • 1.9 Section Summary

2.0 Entering Data

  • 2.1 Data Entry Techniques
  • 2.2 AutoFill Entry Techniques
  • 2.3 Erasing Data
  • 2.4 AutoComplete and Pre-Selection
  • 2.5 Undo and Redo
  • 2.6 Section Summary

3.0 Working With Existing Documents

  • 3.1 Three Methods of Entering Formulas
  • 3.2 Repeating a Formula in Adjacent Cells
  • 3.3 Additional Formulas
  • 3.4 Section Summary

4.0 Basic Excel Functions

  • 4.1 Summation
  • 4.2 Recalculating & Hierarchy of Operations
  • 4.3 Other Functions
  • 4.4 Section Summary

5.0 Formatting

  • 5.1 The Formatting Toolbar
  • 5.2 Adjusting Column Widths & Row Heights
  • 5.3 Numeric Formatting
  • 5.4 Section Summary

6.0 Saving, Opening and Closing Files

  • 6.1 File Save or File Save As
  • 6.2 Opening and Closing a File
  • 6.3 Creating a New Workbook
  • 6.4 Section Summary

7.0 The Excel Help System

Level Summary

Excel 2000 Level 2

1.0 Changing Worksheet Layout

  • 1.1 Inserting Columns, Rows, and Cells
  • 1.2 Deleting Columns, Rows, and Cells
  • 1.3 Moving Cells
  • 1.4 Copying Cells
  • 1.5 Section Summary

2.0 Additional Formatting

  • 2.1 Formatting Cell Attributes and Alignment
  • 2.2 Borders
  • 2.3 Numeric Formatting
  • 2.4 Centering Text Across Columns
  • 2.5 Hiding and Unhiding Columns and Rows
  • 2.6 Section Summary

3.0 Printing

  • 3.1 Using Print Preview and Page Setup
  • 3.2 Printing Controls
  • 3.3 Using Page Break Preview
  • 3.4 Section Summary

4.0 Using Cell References

  • 4.1 Absolute References
  • 4.2 Mixed References
  • 4.3 Section Summary

5.0 The Tools Options Command

  • 5.1 Show/Hide Gridlines and Formulas
  • 5.2 File List and New Workbook Sheets
  • 5.3 Default Settings 5.4 Section Summary

6.0 Introduction to Charting - An Overview

  • 6.1 Quick Chart Creation
  • 6.2 Chart Types
  • 6.3 Titles, Gridlines, and Scaling
  • 6.4 Formatting Basics
  • 6.5 Printing and Copying Charts

Level Summary

Excel 2000 Level 3

1.0 Adjusting Worksheet Views

  • 1.1 Freeze/Unfreeze Panes
  • 1.2 Horizontal and Vertical Split Screens
  • 1.3 Section Summary

2.0 Formula Auditing Techniques

  • 2.1 Using the Auditing Toolbar
  • 2.2 Tracing Dependant Cells
  • 2.3 Tracing Precedent Cells
  • 2.4 Section Summary

3.0 The IF and VLOOKUP Functions

  • 3.1 IF Functions and Relational Operators
  • 3.2 Logical Operators with the IF Function
  • 3.3 Nested IF Functions
  • 3.4 The VLOOKUP Function
  • 3.5 Section Summary

4.0 Dates and Times

  • 4.1 Using Dates as Values
  • 4.2 Entering a Series of Dates
  • 4.3 Date/Time Entry Techniques
  • 4.4 Section Summary

5.0 Multi-sheet Workbooks

  • 5.1 Renaming Sheets
  • 5.2 Inserting and Deleting Sheets
  • 5.3 Moving, Copying, and Grouping
  • 5.4 Formulas Across Multiple Sheets
  • 5.5 Section Summary

6.0 Intro to Database Features - An Overview

  • 6.1 Sorting Data
  • 6.2 Creating Subtotals
  • 6.3 Filtering
  • 6.4 Pivot Tables
Level Summary
PowerPoint 2000 Level 1

1.0 Getting a round in PowerPoint
  • 1.1 The PowerPoint Screen
2.0 Creating a Presentation
  • 2.1 Types of Slides & Work Views
  • 2.2 Creating a Presentation with a template & or Wizard
  • 2.3 Creating a Presentation from Existing Slides
  • 2.4 Deleting Slides in different Views
  • 2.5 Inserting Headers & Footers
  • 2.6 Sending a Presentation Via e-mail
  • 2.7 Sending a Presentation with a Routing Recipient
3.0 Modifying a Presentation
  • 3.1 Changing the Order of the Slides
  • 3.2 Changing the Layout of one or more Slides
  • 3.3 Using the Slide Master
  • 3.4 Using a Design Template
4.0 Working with Text
  • 4.1 Spell Check & Promotion & Demotion
  • 4.2 Aligning Text
  • 4.3 Adding a Text Box
  • 4.4 Fonts
  • 4.5 Office Clipboard
5.0 Working with Visual Elements
  • 5.1 Adding Clip Art
  • 5.2 Adding Shapes & Word Art
  • 5.3 Grouping
  • 5.4 Fill Features
  • 5.5 Adding Tables
  • 5.6 Tips for Beginners
PowerPoint 2000 Level 2

1.0 Customizing a Presentation
  • 1.1 Bullets & Numbering
  • 1.2 Animating Text
  • 1.3 Slide Transitions
  • 1.4 Speaker Notes
2.0 Creating Output
  • 2.1 Previewing Presentations in Black & White
  • 2.2 Printing Slides
  • 2.3 Printing Handouts
  • 2.4 Printing Speaker Notes
  • 2.5 Printing the Outline View
3.0 Delivering a Presentation
  • 3.1 Starting a Slide Show
  • 3.2 Using the On-Screen Navigation Tools
  • 3.3 The Pen Tool
  • 3.4 Printing Overhead Transparencies
4.0 Managing Files
  • 4.1 Saving Presentations
  • 4.2 Publishing to the Web
  • 4.3 Hyperlinks
  • 4.4 The Office Assistant
5.0 Advanced Features
  • 5.1 Automatically Create a Summary Slide
  • 5.2 Automatically Create an Agenda Slide
  • 5.3 Creating our own Design Template
  • 5.4 Auto Content Wizard
6.0 Modifying a Presentation
  • 6.1 Applying animation effects
  • 6.2 Inserting animated GIFís
  • 6.3 Adding an Action Button
  • 6.4 Customizing a Color Scheme
  • 6.5 Creating a Custom Background
  • 6.6 Changing Tab Formatting
  • 6.7 Hiding Slides
  • 6.8 Adding a Presentation within a Presentation
  • 6.9 Setting automatic Slide Timings
PowerPoint 2000 Level 3

1.0 Working Visual Elements
  • 1.1 Adding Textured Backgrounds
  • 1.2 Applying Diagonal Borders to a Table
2.0 Using Data from other Sources
  • 2.1 Exporting an Outline to Word
  • 2.2 Importing an Outline from Word
  • 2.3 Adding a Table from Word
  • 2.4 Inserting an Excel Chart
  • 2.5 Adding Sound
  • 2.6 Adding Video
3.0 Creating Output
  • 3.1 Saving a Slide as a Graphic
  • 3.2 Generate Meeting Notes
  • 3.3 Changing the output format (Page Setup)
  • 3.4 Export to 35 mm Slides
4.0 Delivering a Presentation
  • 4.1 Save Presentation for use on another computer (Pack Ní Go)
5.0 Managing Files
  • 5.1 Saving Embedded Fonts in a Presentation
  • 5.2 Saving HTML to a Specific target Browser
6.0 Toolbars
  • 6.1 Customizing the Toolbar
  • 6.2 Creating a Toolbar
7.0 Working with Charts & Graphs
  • 7.1 Building & Modifying a Chart or a Graph
  • 7.2 Building an Organization Chart
  • 7.3 Animating an Organization Chart
8.0 Collaborating with Workgroups
  • 8.1 Broadcasting Overview
  • 8.2 Setting Up the Presentation for Broadcasting
  • 8.3 Viewing a Presentation on the Web
  • 8.4 Using Net Meeting to Schedule a Broadcast
Word 2000 Level 1

1.0 Getting Started
  • 1.1 Starting Word 2000
  • 1.2 Touring the Word Window
2.0 Creating New Documents
  • 2.1 Entering Text
  • 2.2 Saving Your Work
  • 2.3 Printing & Closing a Document
  • 2.4 Working with a Template
  • 2.5 Using a Wizard
3.0 Revising Documents
  • 3.1 Opening a Document
  • 3.2 Moving in a Document
  • 3.3 Basic Editing
  • 3.4 Adding a Date
  • 3.5 Click & Type
  • 3.6 Envelopes & Labels
  • 3.7 Multiple Page Documents
4.0 Getting Help
  • 4.1 Office Assistant
  • 4.2 Help Window
  • 4.3 Context Sensitive Help
5.0 Printing Database Objects
  • 5.1 Selecting Text
  • 5.2 Copying & Moving Text
  • 5.3 The Office Clipboard
  • 5.4 Undo
  • 5.5 AutoComplete
6.0 Character Formatting
  • 6.1 Changing Font Formatting
  • 6.2 The Formatting Toolbar
  • 6.3 Symbols & Special Characters
  • 6.4 AutoFormat As You Type
7.0 Paragraph Formatting
  • 7.1 Paragraph Alignment
  • 7.2 Line Spacing
8.0 Document Formatting
  • 8.1 Margins & Paper Size
  • 8.2 Controlling Page Breaks
9.0 Proofing Documents
  • 9.1 Spelling & Grammar
  • 9.2 Thesaurus
10.0 Previewing & Printing a Document
  • 10.1 Previewing a Document
  • 10.2 Printing a Document
11.0 Shortcuts
  • 11.1 Shortcut Menus
  • 11.2 Keyboard Shortcuts
  • 11.3 Exiting out of Word
Word 2000 Level 2

1.0 Document Management
  • 1.1 Document Views
  • 1.2 Working with Multiple Document Windows
  • 1.3 File Management
2.0 Additional
  • 2.1 Other Collaboration & Web Tools
3.0 Online Documents
  • 3.1 Web Layout ViewEditing Tools
  • 3.2 Find & Replace
  • 3.3 AutoText
  • 3.4 Format Painter
4.0 Customizing Word
  • 4.1 Toolbars
  • 4.2 Personalized Menus
  • 4.3 Defaults
  • 4.4 Options
5.0 More Paragraph Formatting
  • 5.1 Tabs
  • 5.2 Indents
  • 5.3 Bullets
  • 5.4 Special Spacing
  • 5.5 Sorting Text
  • 5.6 Borders & Shading
6.0 Page Numbers
  • 6.1 Numbering Pages
  • 6.2 Headers & Footers
7.0 Section Formatting
  • 7.1 Using Sections
  • 7.2 Newspaper Columns
8.0 Introduction to Graphics
  • 8.1 Basics
Word 2000 Level 3

1.0 Tables
  • 1.1 Creating a Table
  • 1.2 Navigating & Modifying a Table
  • 1.3 Formatting a Table
2.0 Automatic Formatting & Styles
  • 2.1 Applying Styles
  • 2.2 Creating Your Own Styles
  • 2.3 Modifying Existing Styles
3.0 Document Templates
  • 3.1 Personalizing Wordís Templates
  • 3.2 Creating Your Own Templates
  • 3.3 Automating with Field Codes
4.0 Long Documents & Reports
  • 4.1 Cross-references & Bookmarks
  • 4.2 Footnotes
  • 4.3 Tables of Contents
  • 4.4 Indexes
  • 4.5 Outlines
  • 4.6 Document Map
5.0 Sharing Documents
  • 5.1 Comments
  • 5.2 Tracking Changes
  • 5.3 Protecting Documents
  • 5.4 Saving Different Versions
6.0 Macros
  • 6.1 Creating & Running Macros
  • 6.2 Editing Macros
  • 6.3 Automatic Macros