|
|
Microsoft Office 97 CBT Interactive Training CD-ROM
|
|
|
Interactive CD-ROM Training
|
#ptsof97
|
$219.95
|
Order
|
Office 97 Interactive CD-ROM
Contains Four Levels of Training for Excel, Word, Access and an introduction to Powerpoint and Outlook 97. Over 40 hours of training on Office 97. Covers training MOUS Certification
Beginning Access 97
General Information
Course Duration: 3 hours
Audience: Users wanting to become familiar with Access 97; users wanting to become certified as Expert Users of Access 97
Prerequisites: A basic familiarity with Windows 95 or Windows NT 4.0 user environments
Topics Covered
Introducing databases
Starting Access 97
Using databases
Creating databases
Hands-on: Creating a database
Help
Creating tables
Hands-on: Creating a table
Defining relationships
Hands-on: Defining a relationship
Entering and changing data
Hands-on: Inserting a column
Sorting and searching for records
Hands-on: Sorting records
Working with filters
Hands-on: Filtering records
Course Aim
To provide an introduction to using Access 97
Learning Objectives
After taking this course, the user should be able to:
use and create databases in Access 97
create and design tables
enter data and manage databases
Intermediate Access
General Information
Course Duration: 4 hours
Audience:
Users wanting to become familiar with Access 97; users wanting to become certified as Expert Users of Access 97
Prerequisites: Familiarity with databases and Access 97
Topics Covered:
Working with forms
Creating forms
Hands-on: Creating a form using Autoform
Subforms
Hands-on: Creating a subform
Building a custom form
Getting more from controls
Hands-on: Creating an option group
Formatting forms
Creating charts
Using reports
Customizing reports
Hands-on: Creating an autoformat
Sub-reports
Printing
Hands-on: Printing a report
Course Aim
To provide an introduction to using, creating, and printing forms and reports in Access 97
Learning Objectives
After taking this course, the user should be able to:
use and create forms
use and create reports
customize forms and reports
print forms and reports
Advanced Access 97
General Information
Course Duration: 4 hours
Audience:
Users wanting to become familiar with Access 97; users wanting to become certified as Expert Users of Access 97
Prerequisites: A good understanding of Access 97
Topics Covered
Introduction to queries
Select queries
Hands-on: Creating a select query
Customizing queries
Hands-on: Customizing a query
Total and summary queries
Crosstab queries
Hands-on: Using crosstab queries
Using action queries
Hands-on: Creating and running an update query
Creating macros
Hands-on: Creating a macro
Ways to run macros
Hands-on: Modifying a macro group
Course Aim
To demonstrate how to use macros, share and secure databases, link and import data, and access the Internet in Access 97
Learning Objectives
After taking this course, the user should be able to
create and run queries in Access 97
customise queries
use action and crosstab queries
create and run macros
Access Power User
General Information
Course Duration: 4 hours
Audience:
Users wanting to become familiar with Access 97; users wanting to become certified as Expert Users of Access 97
Prerequisites: A good understanding of Access 97
Topics Covered
Sharing databases
Hands-on: Splitting a database
Replicating databases
Synchronizing databases
Hands-on: Synchronization
Maintaining databases
Hands-on: Removing a database password
Restricting data entry
Hands-on: Defining an input mask
Lookup fields
Importing from Access databases
Hands-on: Linking tables
Importing from non-Access sources
Hands-on: Linking a spreadsheet
Exporting data
Hands-on: Exporting to a FoxPro file
Navigating the Internet with Access
Creating HTML documents
Hands-on: Creating an HTML document
Creating hyperlinks
Hands-on: Modifying a hyperlink
Course Aim
To demonstrate how to share and secure databases, link and import data, and access the Internet in Access 97
Learning Objectives
After taking this course, the user should be able to
share and secure databases
link and import data
create hyperlinks and HTML documents
Beginning Excel 97
General Information
Course Duration: 4 hours
Audience:
First-time users of Excel 97; those aiming to become certified as Proficient Users of Excel 97
Prerequisites: Basic familiarity with the Windows 95 or Windows NT 4.0 user environments
Topics Covered
Starting Excel
Worksheets and workbooks
Hands-on: Saving a workbook
Previewing and printing
Hands-on: Printing a worksheet
The Help facility
Entering and changing data
Hands-on: Entering data
Working with rows and columns
Hands-on: Inserting a column
Copying and moving data
Hands-on: Copying a column
Adjusting column widths and row heights
Formatting numbers
Hands-on: Formatting numbers
Formatting text
Hands-on: Formatting text
Creating formulas
Hands-on: Entering a formula
Automatic features and filling formulas
Hands-on: Using AutoSum
Date formulas
Hands-on: Using a date formula
Course Aim
To familiarize users with the Excel 97 environment and to enable them to perform basic spreadsheet operations
Learning Objectives
After taking this course, the user should be able to:
work comfortably in the Excel environment
create new workbooks and manipulate data in existing ones
format rows, columns, and numbers
create and use formulas
Intermediate Excel 97
General Information
Course Duration: 5 hours
Audience:
First-time users of Excel 97; those aiming to become certified as Proficient Users of Excel 97
Prerequisites: Basic familiarity with the Windows 95 or Windows NT 4.0 user environments and thorough understanding of the content of the preceding
course Microsoft Office 97: Beginning Excel 97
Topics Covered
Using ranges
Defining names
Hands-on: Naming a range
Using functions
Hands-on: Using the Max functions
Sorting
Hands-on: Sorting data
Chart basics
Modifying charts
Hands-on: Changing a chart type
Formatting and printing charts
Hands-on: Formatting a chart
Working with maps
Creating lines and objects
Hands-on: Annotating a chart
Creating 3-D shapes
Hands-on: Changing a 3-D shape
Customizing toolbars
Hands-on: Removing a toolbar
Using styles
Customizing headers and footers
Hands-on: Customizing a header
Navigating the Internet
Creating an HTML spreadsheet
Hands-on: Saving an HTML spreadsheet
Using hyperlinks
Hands-on: Creating a hyperlink
Course Aim
To equip users with the knowledge and skills required to accomplish common
Excel 97 tasks efficiently, and to prepare users for certification as Proficient Users of Excel 97
Advanced Excel 97
General Information
Course Duration: 3 hours
Audience:
Users already proficient in the use of Excel 97; users aiming for Expert User certification
Prerequisites: Proficiency in the use of Excel 97 and comprehensive understanding of all the topics covered in the preceding course Microsoft
Office 97: Intermediate Excel 97
Topics Covered
Using templates
Hands-on: Creating a template
Group editing
Hands-on: Editing a group
Editing shared workbooks
Hands-on: Sharing a workbook
Protecting worksheets
Hands-on: Protecting a worksheet
Protecting workbooks
Tracing dependents
Hands-on: Tracing dependents
Tracing and correcting precedents
Hands-on: Precedents
Creating and modifying outlines
Consolidating data
Hands-on: Consolidating data
Managing large sheets
Course Aim
To prepare users to maximize their usage of all Excel 97's functionality, and to
partially prepare users for certification as Expert Users of Excel 97
Learning Objectives
After taking this course, the user should be able to
perform advanced editing tasks
implement security and auditing procedures
create and modify outlines
consolidate data
manage large sheets
Excel 97 for Power Users
General Information
Course Duration: 4 hours
Audience
: Users already proficient in the use of Excel 97; users aiming for Expert User certification
Prerequisites: Proficiency in the use of Excel 97 and comprehensive understanding of all the topics covered in the preceding course Microsoft
Office 97: Advanced Excel 97
Topics Covered
Recording and running macros
Hands-on: Recording a macro
Hands-on: Running a macro
Editing macros
Hands-on: Editing a macro
Lists as databases
Hands-on: Using data forms
Sorting and filtering lists
Hands-on: Sort and Custom AutoFilter
Querying a database
Hands-on: Running a Web query
Data analysis with PivotTables
Linking data
Hands-on: Creating a data link
Importing and exporting between Excel and other applications
Hands-on: Embedding an object
Defining custom views and scenarios
Hands-on: Defining a scenario
Creating reports
Hands-on: Creating a report
Course Aim
To enable users to maximize their usage of all Excel 97's functionality, and to prepare users for certification as Expert Users of Excel 97
Learning Objectives
After taking this course, the user should be able to
record, run, and edit macros
use database functions and run Web queries
share data with other workbooks and other applications
use Report Manager to create custom reports
Beginning Word 97
General Information
Course Duration: 4 hours
Audience:
Users wanting to become familiar with Word 97; users wanting to become certified as Proficient Users of Word 97
Prerequisites: A basic familiarity with the Windows 95 or Windows NT 4.0 user environments
Topics Covered
Word 97 features
How to create a document
Hands-on: Deleting, undoing, and redoing
How to save a document
Hands-on: Saving a document
Using Help
Moving and copying text
Checking spelling and grammar
Hands-on: Editing a document
Previewing and printing
Hands-on: Printing a document
Text styles and alignment
Indents, bullets, and numbers
Hands-on: Formatting text
Replacing text breaks and hyphens
Hands-on: Finding and replacing text
Web page authoring tools
How to create HTML documents
Hands-on: Inserting a hyperlink
Course Aim
To provide an introduction to using Word 97
Learning Objectives
After taking this course, the user should be able to
create and edit documents
use the spelling and grammar checkers
preview and print documents
insert bulleted and numbered lists in documents
find and replace text
save Word documents as HTML documents
Intermediate Word 97
General Information
Course Duration: 5 hours
Audience:
Users wanting to become familiar with Word 97; users wanting to become certified as Expert Users of Word 97
Prerequisites: A basic familiarity with the Windows 95 or Windows NT 4.0 user environments and the course Microsoft Office 97: Beginning Word 97
Topics Covered
Creating tables
Hands-on: Creating a table
Changing table layout
Borders and shading
Hands-on: Adding borders and shading
Using wizards
Using columns
Hands-on: Creating columns
Using and editing styles
Hands-on: Creating styles
Headers and footers
Hands-on: Creating headers and footers
How to set tabs
Hands-on: Setting tabs
Using AutoText and the Thesaurus
Hands-on: Creating an AutoText entry
Using outlines
Using the drawing tools
Hands-on: Creating a 3-D shape
Creating graphics
Hands-on: Using WordArt
Course Aim
To advance basic-level Word 97 skills to an intermediate level
Learning Objectives
After taking this course, the user should be able to
create and format tables
key and edit text in columns
create and edit styles
create and modify headers and footers
set tabs
use the AutoText and Thesaurus tools
use the drawing tools in Word 97
Advanced Word 97
General Information
Course Duration: 4 hours
Audience: Users wanting to become certified as Expert Users of Word 97
Prerequisites: A basic familiarity with the Windows 95 or Windows NT 4.0 user environments and the courses Microsoft Office 97: Beginning Word 97
and Microsoft Office 97: Intermediate Word 97
Topics Covered
Advanced columns
Hands-on: Creating advanced columns
Footnotes and endnotes
Hands-on: Creating a footnote
Creating indexes
Hands-on: Creating an index entry
Tables of contents
Hands-on: Creating a table of contents
Performing calculations
Hands-on: Performing a calculation in a table
Creating and importing worksheets
Creating charts
Borders and shading
Hands-on: Creating a page border
Adding graphics
Hands-on: Adding a graphic
Course Aim
To provide users with advanced Word 97 skills
Learning Objectives
After taking this course, the user should be able to
apply advanced formats
use cross-references and bookmarks
create an index and a table of contents
create and use worksheets and charts
modify page layout in a document
add, delete, and position graphics
execute color printing
Word 97 for Power Users
General Information
Course Duration: 4 hours
Audience: Users wanting to become certified as Expert Users of Word 97
Prerequisites: A basic familiarity with the Windows 95 or Windows NT 4.0 user environments and the courses Microsoft Office 97: Beginning Word 97,
Microsoft Office 97: Intermediate Word 97, and Microsoft Office 97: Advanced Word 97
Topics Covered
Recording and running macros
Hands-on: Creating a macro
Editing and modifying macros
Hands-on: Modifying a macro
Building forms
Hands-on: Creating a form
Creating catalogs and lists
Generating mail-merges
Hands-on: Inserting fields
Workgroup editing
Master documents
Hands-on: Creating a master document
Tracking changes, protecting, and routing documents
Hands-on: Commenting on and protecting a document
Course Aim
To provide advanced Word 97 users with skills in workgroup editing, using macros, and using mailmerge
Learning Objectives
After taking this course, the user should be able to
record and run macros
use macros to create templates
create and modify forms
generate mailmerges
create master documents
route and track documents in a workgroup
create multiple versions of a document
add comments using document summary
Outlook 97
General Information
Course Duration: 4 hours
Audience
: Office 97 users and users planning to become certified as Expert Users
Prerequisites: Basic familiarity with the Windows 95 or Windows NT 4.0 user environments
Topics Covered
Starting Outlook
Using Journal
Hands-on: Locating a journal event
Maintaining contacts
Hands-on: Adding a contact
Keeping notes
Hands-on: Creating a note
Sending and receiving messages
Hands-on: Previewing and moving a message
Hands-on: Clearing the Inbox
Setting mail options
Creating message templates
Hands-on: Saving an item as a template
Managing remote mail
Working with Calendar
Hands-on: Setting a reminder
Customizing and securing your Calendar
Hands-on: Setting permissions
Creating a task
Hands-on: Prioritizing a task
Managing tasks
Hands-on: Delegating a task
Navigating folders
Creating shared items
Hands-on: Modifying the Field Chooser
Offline folder synchronization
Printing all components
Course Aim
To prepare users for optimal use of Outlook 97 in the integration of their
desktop applications; to show how Outlook 97 can be used in most organizational and communications tasks; to prepare users for the Microsoft Outlook Expert User exam
Learning Objectives
After taking this course, the user should be able to
describe the essential features of Outlook
use the Outlook scheduling and organizational features effectively
communicate effectively using Outlook's powerful e-mail facilities
PowerPoint 97
General Information
Course Duration: 4 hours
Audience:
Users wanting to become familiar with PowerPoint 97; users wanting to become certified as Expert Users of PowerPoint 97
Prerequisites: A familiarity with the Windows 95 or NT 4.0 user environments
Topics Covered
Starting PowerPoint
Creating a presentation
Working with slides
Hands-on: Changing a transition
Adding tables and graphs
Hands-on: Creating a table
Choosing a color scheme
Hands-on: Changing the background color
Drawing and animating objects
Editing objects
Hands-on: Changing an object's color
Importing from Word and Excel
Hands-on: Exporting an outline to Word
Inserting pictures
Hands-on: Resizing a clip art object
Adding sounds and movies
Internet support
Hands-on: Saving for the Internet
Reviewing and printing your presentation
Adding notes
Running your slide show
Hands-on: Running slides
Course Aim
To provide an introduction to PowerPoint 97
Learning Objectives
After taking this course, the user should be able to
view and create presentations
create and design slides
design presentations
import and export data
use PowerPoint on a network or the Internet
review and print a presentation
run a slide show
Return to Main Page
|
