Use 'Microsoft Office 2000' tutorials/training course. Suitable for MS Office Specialist (MOS) Certification

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