|
|
|
MS Office 2000 (MOS) CD Training (CBT) COMPLETE Course (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "MS Office 2000 Courses"]
|
|
|
| Product: |
MS Office 2000 (MOS) CD Training (CBT) COMPLETE Course
Word, Excel, Access, PowerPoint and Outlook Training.
|
| Price: |
|
|
|
| Description: |
|
Specialized Solutions has your Office 2000 Training on 13
CD-ROMs. The Office suite includes Access, Excel, Word, PowerPoint
and Outlook. The suite consists of 13 CD-ROMs and each level
with the exception of Outlook contains a three tape series.
Our expert staff of curriculum developers created a 13 CD-ROM
course for Microsoft Office 2000 that will elevate your expertise
and prepare you for the Microsoft Office User Specialist Exam.
|
 |
| |
| Subjects covered in the MOUS/MOS Office
2000 CBT Course |
|
Access 2000
Level One:
- Open a database file
- Select an object using the Objects Bar
- Navigate through records in a table, query or form
- Using online help
- Switch between object views
- Display related records in a sub datasheet
- Sort and Search for records
Level Two:
- Edit, Add, and Delete records
- Find and replace specific data
- Create table structure
- Determine appropriate data input and output for
a table
Level Three:
- Create a Query
- Modify a Query
- Create a complete Query
- Select records using a specific criterion
- Create and modify a form
- Build and modify a report
Excel 2000
Level One:
- What is Microsoft Excel 2000?
- Navigation
- Creating a workbook
- Using spreadsheets and on-line help
- Formatting values and ranges
- Opening and modifying a workbook
- Deleting cell contents and worksheets
- Revising text and numbers
- Sorting data
- Printing workbooks
- Printing screens and ranges
- Using drawing tools, functions & charts
- Inserting and deleting rows/columns
- Using and creating templates
Level Two:
- Auto and custom formatting
- Creating and working with formulas
- Formula order of operations
- Copying formulas using relative and absolute reference
- Using IF and nested IF functions
- Working with dates
- Importing data from other sources
- Importing lists
Level Three:
- Advanced charts
- Hyperlinks and macros
- Using filters and sorts
- Data analysis
- Conditional formatting and styles
- Sharing workbooks and workgroups
- Functions of sharing
- Pivot tables
Outlook 2000
- Getting familiar with Outlook 2000
- E-mail and messages
- Personal distribution lists
- Recalling, printing and organization
- Appointments and events
- Scheduling and editing appointments
- Assigning categories
- Adding and editing contacts
- Managing contacts
- Creating, editing and deleting notes
- Managing tasks
- AND MANY MORE !
|
Powerpoint 2000
Level One:
- Introduction to Powerpoint
- Working with Office Assistant
- Working with presentation features
- Creating a presentation for the first
page
- Working with automated presentation
design tools
- Creating a presentation without any
assistance
- Use another presentation to create
a new one
- Printing presentations
- Importing data from other sources
- Importing lists
Level Two:
- Using AutoContent Wizard
- Working with outlines
- Using templates
- Working with fonts and tags
- Setting slide
sequences and automation
- Drawing and working with objects
- Using animation techniques
- Working with colors and backgrounds
- Customizing clip art and editing other
objects
Level Three:
- Working with charts, graphs and tables
- Using Style Checker
- Compatibility with the Office family
of products
- Speaker notes and meeting notes
- Customizing slide shows with hyperlinks
- Online broadcasts
- Saving presentations
Word 2000
Level One:
- Intro to MS Word 2000
- Creating a document and using text
- Drag-and-drop editing
- Working with paragraphs
- Controlling the document's appearance
- Formatting text and paragraphs
- Status bar
- Proofing and printing
- Saving a document to a floppy disk
Level Two:
- Using Headers and Footers
- Inserting page breaks
- Creating and modifying columns
- Outline lists
- Locating missing and unnamed files
- Using templates
- Using graphics, clipart and images
- Saving a document as a Web Page
- Adding a hyperlink to a document
- Documents as email attachments
Level Three:
- Paragraphs using text flow options
- Create multiple versions of a document
- Sorting lists
- Create and modify a table of contents
- Create and modify a form
- Create, apply and edit macros
- Footnotes and endnotes
- Customized toolbars
- Using Mail Merge
- Track changes to a document
- Using tables & charts
- Workgroups
|
|
| The CD-ROMs include the
following exclusive features: |
|
1. While most computer based training courses are one-half
or less of your screen, our courses are available in Full
Screen Resolution and since they are from our original
digital masters, they are of the highest quality. What good
is a visual presentation if you have trouble identifying what
is on your screen?
2. Full Motion Video and interaction offers you full
control of what you see and hear on your screen. If you would
like the instructor to repeat what he just said, you simply
click on the rewind button and you may listen as often as
you like. Each section is also identified with a digital index
to help you find your place if you have to pause in the middle
of a Lesson.
3. A "Floating Window" will be your guide through
the application processes and steps. It acts like the ?Office
Assistant? but since we programmed it into the course, it
already knows what you are doing and will only offer information
that is relevant to what you are doing. It is your companion
through the interactive simulations.
4. Notepad lets you record detailed and precise notes
during the instruction and is readily available at any time
during any course. With a click of a button, you may record
as many notes as you like and then resume with the visual
presentation.
5. Complete Control of the Video Streams, down to
each second of time, enables you to directly go to and from
any section of the training series. You may replay any single
part or all of the information as many times as you think
necessary to grasp the concepts.
|
|
Meet
The Expert
Shawn Oliver is a training specialist for the
entire Microsoft Office family of products. He is an MCP,
MCT and MOUS Certified Instructor. Shawn's easy-to-understand
format and straight-forward, hands-on delivery make him one
of the most effective technical application trainers in the
industry.
|
 |
| Shawn Oliver |
|
