Beginning Word 2000
(2 Hrs 10 Minutes)

1.0 Getting Started (8 Minutes)

  • Starting word 2000
  • Touring the Word Window

2.0 Creating New Documents (22 minutes)

  • Entering Text
  • Saving Your work
  • Printing & Closing a Document
  • Working with a Template
  • Using a Wizard

3.0 Revising Documents (18 minutes)

  • Opening a Document
  • Moving in a Document
  • Basic Editing
  • Adding a Date
  • Click and Type
  • Envelopes & Labels
  • Multiple Page Documents

4.0 Getting Help (10 minutes)

  • Office Assistant
  • Help Window
  • Context Sensitive Help

5.0 Essential Skills (25 minutes)

  • Selecting Text
  • Copying & Moving Text
  • The Office Clipboard
  • Undo, Redo, Repeat & AutoCorrect
  • AutoComplete

6.0 Character Formatting (21 minutes)

  • Changing font Formatting
  • The Formatting Toolbar
  • Symbols & Special Characters
  • AutoFormat As Your type
  • Paragraph Formatting
  • Paragraph Alignment
  • Line Spacing

8.0 Document Formatting

  • Margins & Paper size
  • Controlling Page Breaks
  • Proofing Documents (10 minutes)
  • Spelling & Grammar
  • Thesaurus

9.0 Previewing & Printing (5 minutes)

  • Previewing a Document
  • Printing a document

10.0 Shortcuts (8 minutes)

  • Shortcut Menus
  • Keyboard Shortcuts
  • Exiting out of Word

Intermediate Word 2000
(2 Hrs 13 Minutes)

1.0 Document Management (31 Mins)

  • Document Views
  • Working with Multiple Document Windows
  • File Management

2.0 Additional Editing Tools (14 Mins)

  • Find & Replace
  • AutoText
  • Format Painter

3.0 Customizing Word (16 Mins)

  • Toolbars
  • Personalized Menus
  • Defaults
  • Options

4.0 More Paragraph Formatting (45 Mins)

  • Tabs
  • Indents
  • Bullets
  • Special Spacing
  • Sorting Text
  • Borders & Shading
  • Page Numbers
  • Numbering Pages
  • Headers & Footers

6.0 Section Formatting (11 Mins)

  • Using Sections
  • Newspaper Columns

7.0 Introduction to Graphics (6 Mins)

  • Basics
Advanced Word 20000
(2 Hrs)

1.0 Tables (25 Mins)

  • Creating a Table
  • Navigating & Modifying a Table
  • Formatting a Table

2.0 Automatic Formatting & Styles (12 Mins)

  • Applying Styles
  • Creating Your Own Styles
  • Modifying Existing Styles

3.0 Document Templates (13 Mins)

  • Personalizing Word's Templates
  • Creating Your Own Templates
  • Automating with Field Codes

4.0 Long Documents & Reports (36 Mins)

  • Cross-references & Bookmarks
  • Footnotes
  • Tables of Contents
  • Indexes
  • Outlines
  • Document Map

5.0 Sharing Documents (14 Mins)

  • Comments
  • Tracking Changes
  • Protecting Documents
  • Saving Different Versions

6.0 Macros (19 Mins)

  • Creating & Running Macros
  • Editing Macros
  • Automatic Macros

 

Beginning Excel
(2 Hrs 16 Mins)

1.0 The Excel Screen (32 Mins)

  • The Excel Workbook & Worksheets
  • Title Bar & Menu Bar
  • Toolbars
  • Formula Bar
  • Columns & Rows
  • Navigation
  • Sheet Names & the Status Bar
  • Mouse Pointers & Shortcut Menus
2.0 Entering Data into a Worksheet (27 Mins)
  • Data Entry Techniques
  • Auto Complete
  • Three Methods of Entering Formulas
  • Repeating a Formula
  • Formulas Beyond Addition & Subtraction
4.0 Basic Functions (21 Mins)
  • Summation
  • Recalculating Effects
  • Averages
5.0 Formatting (13 Mins)
  • The Formatting Toolbar
6.0 Saving (17 mins)
  • File Save or File Save as
  • Opening a File
  • Closing a File
  • Creating a new Workbook

Intermediate Excel
(2 Hrs 5 Mins)

1.0 Changing Worksheet Layout (26 Mins)
  • Inserting Columns
  • Deleting Columns
  • Moving Cells
  • Copying Cells
2.0 Additional Formatting (6 Mins)
  • Formatting Cell Attributes & Alignment
  •  Borders
  • Numeric Formatting
  • Center Text across Columns
  • Hiding & Unhiding Columns & Rows
3.0 Printing (25 Mins)
  • Using Print Preview & Page Setup
  • Printing Controls
  • Using Page Break Preview
4.0 Using Cell References (29 Mins)
  • Absolute References
5.0 Tools Options Command (18 Mins)
  • Show/Hide Gridlines
  • Show/Hide Formulas
  • Recently used Files List
  • Sheets in New Workbook
  • Default Settings
Advanced Excel
(2 Hrs 2 Mins)

1.0 Adjusting Worksheet Views (13 Mins)

  • Freeze/Unfreeze Panes
  • Horizontal & Vertical Split screen

2.0 Auditing Techniques (12 Mins)

  • Using the Auditing Toolbar
  • Tracing Dependant Cells
  • Tracing Precedent Cells

 3.0 Using Functions (18 Mins)

  • Paste Function
  • The PMT Function
  • Expanding the use of standard functions

 4.0 Logical Functions (30 Mins)

  • IF Functions & Relational Operators
  • Using Words in IF Functions
  • Using IF Functions with Arithmetic Operators (* / + -)
  • Using Logical Operators (AND & OR) with the IF Function
  • Nested IF Functions
  • Using the VLOOKUP Function to overcome Limitations of the IF Functions

5.0 Date & Time Functions (21 Mins)

  • Using Dates as Values
  • Entering a Series of Dates
  • Date/Time entry Techniques

6.0 Multi-Sheet Workbooks (22 Mins)

  • Re-Naming & Re-Ordering Sheets
  • Inserting & Deleting Sheets
  • Moving
  • Formulas across multiple sheets

 

Beginning PowerPoint 2000
(1 Hr 29 Mins)

1.0 Getting a round in PowerPoint (4 Mins)
  • The PowerPoint Screen
2.0 Creating a Presentation (23 Mins)
  • Types of Slides & Work Views
  • Creating a Presentation with a template & or Wizard
  • Creating a Presentation from Existing Slides
  • Deleting Slides in different Views
  • Inserting Headers & Footers
  • Sending a Presentation Via e-mail
  • Sending a Presentation with a Routing Recipient
3.0 Modifying a Presentation (11 Mins)
  • Changing the Order of the Slides
  • Changing the Layout of one or more Slides
  • Using the Slide Master
  • Using a Design Template
4.0 Working with Text (14 Mins)
  • Spell Check & Promotion & Demotion
  • Aligning Text
  • Adding a Text Box
  • Fonts
  • Office Clipboard
5.0 Working with Visual Elements (36 Mins)
  • Adding Clip Art
  • Adding Shapes & Word Art
  • Grouping
  • Fill Features
  • Adding Tables
  • Tips for Beginners

Intermediate PowerPoint 2000
(1 Hr 37 Mins)

1.0 Customizing a Presentation (16 Mins)

  • Bullets & Numbering
  • Animating Text
  • Slide Transitions
  • Speaker Notes
2.0 Creating Output (10 Mins)
  • Previewing Presentations in Black & White
  • Printing Slides
  • Printing Handouts
  • Printing Speaker Notes
  • Printing the Outline View
3.0 Delivering a Presentation (10 Mins)
  • Starting a Slide Show
  • Using the On-Screen Navigation Tools
  • The Pen Tool
  • Printing Overhead Transparencies
4.0 Managing Files (22 Mins)
  • Saving Presentations
  • Publishing to the Web
  • Hyperlinks
  • The Office Assistant
5.0 Advanced Features (11 Mins)
  • Automatically Create a Summary Slide
  • Automatically Create an Agenda Slide
  • Creating our own Design Template
  • Auto Content Wizard
6.0 Modifying a Presentation (27 Mins)
  • Applying animation effects
  • Inserting animated GIF's
  • Adding an Action Button
  • Customizing a Color Scheme
  • Creating a Custom Background
  • Changing Tab Formatting
  • Hiding Slides
  • Adding a Presentation within a Presentation
  • Setting automatic Slide Timings
Advanced PowerPoint 2000
(1 Hr 30 Mins)

1.0 Working Visual Elements (3 Mins)
  • Adding Textured Backgrounds
  • Applying Diagonal Borders to a Table
2.0 Using Data from other Sources (20 Mins)
  • Exporting an Outline to Word
  • Importing an Outline from Word
  • Adding a Table from Word
  • Inserting an Excel Chart
  • Adding Sound
  • Adding Video
3.0 Creating Output (12 Mins)
  • Saving a Slide as a Graphic
  • Changing the output format ( Page Setup )
  • Export to 35 mm Slides
4.0 Delivering a Presentation (4 Mins)
  • Save Presentation for use on another computer ( Pack N' Go)
5.0 Managing Files (8 Mins)
  • Saving Embedded Fonts in a Presentation
  • Saving HTML to a Specific target Browser
6.0 Toolbars (10 Mins)
  • Customizing the Toolbar
  • Creating a Toolbar
7.0 Working with Charts & Graphs (14 Mins)
  • Building & Modifying a Chart or a Graph
  • Building an Organization Chart
  • Animating an Organization Chart
8.0 Collaborating with Workgroups (17 Mins)
  • Broadcasting Overview
  • Setting Up the Presentation for Broadcasting
  • Viewing a Presentation on the Web
  • Using Net Meeting to Schedule a Broadcas

 

Beginning Access 
(2 Hrs 6 Mins)

1.0 Introduction (26 Mins)
  • Starting Access
  • Opening an Existing Database
  • The Access Desktop
  • The Database Window
  • A Preview of the Database Components
2.0 Working with an Existing Database (33 Mins)
  • Viewing & Navigating Table Data
  • Editing Table Data
  • Adding Records to a Table
  • Selecting & Deleting Records
  • Find & Replace
  • Modifying the Appearance of a Datasheet
  • Spell-Check & Auto-correct
3.0 Form Basics (25 Mins)
  • Moving from Record to Record
  • Finding
  • Sorting
  • Filtering
  • AutoForms
  • Using a Form Wizard
  • Conditional Formatting
4.0 Report Basics (15 Mins)
  • Moving form Page to Page
  • Zooming In & Out
  • Viewing Multiple Pages
  • Printing
  • AutoReports & the Report Wizard
  • Page Setup
5.0 Printing Database Objects (5 Mins)
  • Printing Table Datasheets
  • Printing Queries
  • Printing Forms
  • Printing Reports
6.0 Getting Help (8 Mins)
  • The Office Assistant & Index Searching
  • Context-Sensitive Help & Printing Help Topics
7.0 Database Maintenance & Shortcuts (12 Mins)
  • Backing Up & Restoring a Database
  • Compacting & Repairing a Database
  • Converting a Database to a Previous Version
  • Organizing Database Objects into Groups

Intermediate Access
(2 Hrs 4 Mins)

1.0 Planning & Designing a Database(20 Mins)

  • Evaluating Inputs & Outputs
  • Normalization
  • Creating a Database Using a Wizard
  • Creating a Database from Scratch
2.0 Building & Modifying Tables (49 Mins)
  • Creating Tables Using a Wizard
  • Creating Tables from Scratch & Data Types
  • Setting Primary Keys
  • Field Properties
  • Input Masks
  • The Lookup Wizard
  • Indexes
3.0 Working with Relationships (27 Mins)
  • Introduction to Relationships
  • Benefits of Relationships
  • Types of Relationships
  • Referential Integrity
  • Indexes & Relationships
  • Printing Relationships
4.0 Designing Simple Queries (27 Mins)
  • Selecting Fields & Ordering the Query Result
  • Refining Queries with Criteria
  • Updatability of Query Results
  • Queries Based on Multiple Tables

Advanced Access
(2 Hrs 3 Mins)

1.0 Building & Modifying Forms (51 Mins)
  • Adding Controls
  • Selecting Controls
  • Moving
  • Aligning Controls
  • Changing Control Properties
  • Changing the Tab Order Controls
  • Form Properties
  • Working with Combo Boxes & List Boxes
2.0 Building & Modifying Reports (26 Mins)
  • Understanding Report Bands
  • Working with Controls
  • Creating Groups & Totals Reports
  • Working with Report Properties
  • Modifying Selection Criteria
3.0 Database Startup Options (5 Mins)
  • Setting the Application
  • Designing other Startup Information
4.0 Importing
  • Exporting to another Database
  • Exporting to an Excel Spreadsheet
  • Exporting to ASCII
  • Exporting to HTML
  • Importing from anther Access Database
  • Importing Spreadsheet Data
  • Importing ASCII Data
  • Importing from HTML
  • Linking to Anther Access Database
  • Linking to anther types of Database
  • The Linked Table Manager