Microsoft Office 97 Training CD-ROMS - Descriptions
Inquire about Microsoft Office 2000 and XP Training
Word 97 Introduction
Explaining the Word 97 window
Using shortcut keystrokes
Working with scroll bars
Discussing the Office Assistant
Entering & deleting text
Inserting text
Using the Over-type mode
Selecting text
Using Undo & Redo commands
Cutting, copying & moving text
Applying font styles
Using text color
Aligning text
Animating text
Setting margins
Inserting a page break
Setting line spacing
Inserting the date in a document
Finding & replacing text
Checking a document's spelling
Looking for grammatical errors
Using the Thesaurus
Demonstrating Word Count
Saving document options
Using Print preview
Printing a document
Word 97, Intermediate
Changing paper size/page orientation
Adjusting margins
Setting tabs
Changing line/paragraph spacing
Using Print Preview
Printing
Working with headers/footers
Discussing Odd/Even options
Using the Outline view
Moving text
Showing Page Layout view
Using Online Layout
Discussing the Document Map
Using the Letter wizard
Discussing AutoSummarize
The AutoComplete feature
Demonstrating AutoCorrect
Showing AutoFormat
Creating columns
Inserting tables
Using the Go To command
Working with Find and Replace
Creating an index
Making a Table of Contents
Inserting comments
Using revision marks
Applying textures
Adding borders
Automatically numbering items
Word 97, Advanced
Reviewing the Word window
Creating a mail merge
Using an existing data source
Inserting fields
Editing the data source
Viewing AutoText
Adding new AutoText
Using the AutoText toolbar
Selecting templates and add-ins
Renaming entry fields
Viewing the Query Options box
Using Operators
Sorting records
Merging
E-mailing form letters
Printing merged letters
Creating a data source
Using Find/Replace
Creating envelopes
Making labels
Creating forms
Adding text boxes
Using check boxes/drop-down lists
Inserting a picture
Adding a table
Inserting a frame
Protecting files
Recording a macro
Using the Open dialog box
Toggling between files
Word 97, Desktop Publishing
Forming a headline
Creating a handbill
Adding borders
Adding color to text
Using animated text
Justifying text
Adding bullets
Using the Page Setup options
Inserting a file
Creating a subhead
Using the Draw toolbar commands
Creating special objects
Using a template
Working with WordArt
Adjusting the shape
Creating effects
Making a party invitation
Drawing a line
Creating an AutoShape
Making a Callout
Flipping/rotating objects
Tips for newsletters
Making a nameplate
Adding a tagline
Check list for writing a headline
Adding a deck
Discussing column format
Reviewing newsletter terms
Adding a shaded border
Inserting Clip Art
Using the Frame command
Discussing alternate newsletter types
Word 97 Secrets & Timesavers
Selecting text
Using shortcut keys to
select text
Moving the insertion point
Using the mouse to move text
Making abbreviations
Using AutoCorrect
Printing the Function key table
Using the F2 key to move text
Changing the letter case
Closing windows
Accessing the font/size tools
Underlining with/without spaces
Pasting a format
Aligning text
Adding bullets
Deleting text
Correcting grammar/spelling
Using hyphens
Working with an outline
Numbering in an outline
Discussing mail merge fields
Adding/deleting fields
Creating the source document
Customizing fields
Printing merged letters
Visual Basic for Word 97
Defining capabilities of VBA
Discussing new features of
VBA Highlighting differences between VBA and Visual Basic
Why learn VBA
Running a sample procedure
Opening the VBA Editor
Discussing the Project Explorer properties
Showing the Code View windows
Exporting & importing VBA source files
Installing the Help file
Macros vs Procedures
Naming & assigning macros
Editing a macro
Naming objects
Adding comments
Explaining VBA statements
Writing & running a procedure
Modifying a MsgBox
Creating InputBoxes
Declaring variables with the Dim keyword
Assigning values to variables
Adding an If-Then statement
Building a UserForm
Modifying a UserForm with
images & buttons
Microsoft Excel 97 Training CD-ROMS
Excel 97, Introduction
Viewing the Excel window
Discussing workbooks/worksheets
Defining a worksheet
Moving through a spreadsheet
Selecting cells
Entering data
Formatting cells
Changing column/row widths & heights
Aligning data in a cell
Clearing/deleting cell contents
Using the Undo command
Creating a workbook
Entering data in a selected range
Editing cell information
Saving a workbook
Using the Save As command
Using templates
Creating a spreadsheet
Inserting worksheets
Entering text
Using AutoFill
Creating a formula
Using mathematical functions
Copying & moving data
Adding borders
Changing text attributes
Copying formats
Using Print Preview
Discussing Page Setup
Excel 97, Intermediate
Splitting a worksheet into panes
Freezing panes
Hiding/unhiding columns and rows
Inserting columns and rows
Naming ranges
Using range names in a formula
Changing worksheet views
Defining formulas
Using Absolute cell references
Creating an IF statement
Using the built-in functions
Working with an Array
Linking workbooks
Linking worksheets
Changing Excel's display
Using AutoFormat
Checking the spelling
Changing a workbook's colors
Arranging multiple windows
Copying between windows
Creating a chart
Excel 97, Advanced
Creating a custom toolbar
Moving/re-sizing toolbars
Attaching remarks to cells
Creating an AutoFill list
Creating custom number formats
Using AutoSum
Outlining a worksheet
Consolidating worksheets
Working with sheet tabs
Using a 3-D reference
Grouping a worksheet
Creating a style
Editing/merging a style
Using a data form
Editing records
Finding/sorting records
Filtering records
Using AutoFilter
Creating a template
Protecting cells in worksheets
Creating a Pivot table
Making a scenario
Importing
Excel 97, Formula & Functions
Reviewing basic math principles
Showing the order of operations
Creating a formula
Copying a formula
Explaining absolute and relative cell references
Using AutoSum
Updating data in a worksheet
Using an Array
Applying Fill and AutoFill
Working with comparison operators
Formula arguments
Creating a nested function
Using financial functions
Using variables in functions
Using the Goal Seek command
Demonstrating the VLOOKUP function
Using and IF statement
Creating a database in Excel
Using filtering & AutoFilter
Working with database functions
Using the Analysis ToolPak
Defining cell functions
Using functions
Working with the Analysis tools
Excel 97, Macros & Charts
Recording a macro
Running a macro
Recording an absolute cell reference
Using the Visual Basic toolbar
Creating a portable macro
Viewing macro code
Using the Personal Macro Workbook
Creating a button
Assigning a macro
Customizing a macro button
Moving a macro button
Creating a custom toolbar
Placing custom buttons on a toolbar
Assigning a macro to a custom button
Running a macro from the button
Editing a button
Removing a button
Deleting a toolbar
Listing import graphic file types
Attaching a macro to a bitmap image
Discussing user-defined functions
Creating an interactive macro
Listing chart types
Using the Chart wizard
Placing a chart on a worksheet
Changing chart types
Altering a charts appearance
Reordering columns
Using a trendline
Creating an outline
Creating a map
Microsoft Access 97 Training CD-ROMS
Access 97, Introduction
Discussing the Access window
Viewing fundamental database components
Opening a database
Using a Database wizard
Creating a database
Adding a table with the wizard
Defining data types
Using the Primary key
Changing field properties
Adding records
Copying records
Creating a form
Copying a table
Moving around a table
Organizing a table
Finding records
Replacing records
Filtering a table
Creating indexes
Sorting records
Access 97, Intermediate
Creating a Select query
Sorting fields for a query
Listing criteria expressions
Entering search criteria
Using AND and OR
Creating a Totals query
Re-labeling query fields
Adding calculating fields
Using an Action query
Creating a backup copy
Making an Update query
Using a Deleting query
Working with a Crosstab query
Creating a form with Forms wizard
Placing a bitmap on a form
Defining controls
Inserting a control
Changing a control's appearance
Creating a check box control
Adding a record
Creating a combo box
Changing the form's detail section
Using the Report wizard
Creating a graph
Placing the graph
Using the Button wizard to create a macro
Creating macros from scratch
Attaching a macro to a form
Access 97, Advanced
Defining database relationships
Demonstrating one-to-many
Showing many-to-many
Using a junction table
Defining one-to-one
Discussing Referential integrity
Joining databases
Using the Performer Analyzer
Query joined tables
Discussing equivalent values
Using parameters
Adding a list box
Adding a word
Using the Toggle Button tool
Creating a main form
Making a sub form
Linking tables
Creating a report
Making a template from a report
Creating mailing labels
Linking tables
Importing files
Exporting a table
Exporting in Rich Text Format
Assigning a password
Backing up a database
Encrypting a database
Microsoft PowerPoint 97 Training CD-ROMS
PowerPoint 97, Intro
Opening a presentation
Viewing a slide show
Discussing the PowerPoint window
Using menus
Demonstrating toolbars
Changing views
Using the AutoContent wizard
Entering data in a presentation
Using the Outline view
Moving between slides
Adjusting text
Using the Slide Master
Adding Clip Art to a slide
Creating/editing a chart
Changing chart types
Modifying a chart
Saving a presentation
Creating speaker notes
Making handouts
Adding transition effects
Discussing advancement options
Using the Pen option
Printing a presentation
PowerPoint 97, Advanced
Opening an existing presentation
Editing text in the Slide Master view
Selecting a slide template
Applying a transition effect
Assigning a build effect
Creating a hidden slide
Working with a Clip Art image
Placing a bitmap image in the Clip Gallery
Downloading Clip Art
Creating an image with Office Art
Grouping an image
Using WordArt
Using a Word 97 file
Importing data from Excel 97 to create a chart
Inserting/editing an Excel worksheet
Inserting/editing a Word table
Exporting an outline
Exporting a slide
Opening/viewing exported files in Word
Using the Animation Effects toolbar
Displaying the rulers and guides
Creating a custom toolbar
Tips on creating a presentation
PowerPoint 97, Presentations
Changing background fills
Using custom fill effects
Using the AutoClipArt wizard
Adding an animation effect
Including a sound effect
Tips for creating effects
Using the Slide Miniature
Working with the Style Checker
Using the AutoCorrect command
Using color schemes
Saving a design template
Presentation delivery options
Using the Pack and Go wizard
Discussing the PowerPoint Viewer
Saving presentations to a disk
Automatically running a slide show
Using the Slide Navigator
Demonstrating the Slide Meter
Viewing the Meeting Minder
Microsoft Outlook 97 Training CD-ROMS
Scheduling with Outlook 97
Examining the Outlook window
Discussing the Outlook Bar
Using the Date Navigator
Examining the Current View list
Scheduling a new appointment
Setting reminders
Designating recurring appointments
Inserting a new task into the TaskPad list
Making tasks complete
Inserting a recurring task
Copying a task
Using filters
Working with groups
Sorting the TaskPad list
Inserting a new and an annual event
Adding a contact
Grouping & sorting the Contact list
Working with the Meeting Planner
Scheduling a meeting
Sending meeting requests
Printing an Outlook file
Changing default settings
Outlook 97, E-mail
Discussing the Outlook bar
Examining Outlook & Mail groups
Using Mail shortcuts/folders
The Folder banner
Sending a message
Including an attachment
Receiving mail options
Opening a message
Viewing an attachment
Replying to a message
Deleting a message
Creating storage folders
Moving/copying files to folders
Sorting messages
Grouping messages
Using AutoSignature
Discussing the AutoName Check feature
Showing AutoPreview
Defining message handling options
Using the Voting feature
Examining the Recalling feature
Flagging a message
Using Message Tracking
Viewing tracking results
Return to Previous Page
|
