5 hours

Students wishing to become familiar with Word 97; students wishing to become certified as Proficient Users of Word 97

Basic familiarity with the Windows 95 or Windows NT 4.0 user environments and the course Microsoft Office 97: Beginning Word 97

To advance basic-level Word 97 skills to an intermediate level

After this course the student should be able to:
1. Create and format tables
2. Key and edit text in columns
3. Create and edit styles
4. Create and modify headers and footers
5. Set tabs 6. Use the AutoText and Thesaurus tools

4 hours

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

To provide students with advanced Word 97 skills

After this course the student should be able to:
1. Apply advanced formats
2. Use cross-references and bookmarks
3. Create an index and a table of contents
4. Create and use worksheets and charts
5. Modify page layout in a document 6. Add, delete, and position graphics

4 hours

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

To provide advanced Word 97 users with skills in workgroup editing, using macros, and using mail merge

After this course the student should be able to:
1. Record and run macros
2. Use macros to create templates
3. Create and modify forms
4. Generate mail merges
5. Create master documents 6. Route and track documents in a workgroup 7. Create multiple versions of a document

5 hours

Basic familiarity with the Windows 95 or Windows NT 4.0 user environments and thorough understanding of the content of the course Microsoft Office 97: Beginning Excel 97

To equip students with the knowledge and skills required to accomplish common Excel 97 tasks efficiently, and to prepare students for certification as Proficient Users of Excel 97

After this course the student should be able to:
1. Perform operations on ranges and use functions
2. Sort data
3. Create, format, and modify charts and graphics
4. Use the Drawing tools
5. Customize the Excel 97 environment and workbooks

3 hours

Proficiency in the use of Excel 97 and comprehensive understanding of all the topics covered in Microsoft Office 97: Intermediate Excel 97

To enable students to maximize their usage of all Excel 97's functionality and to partially prepare students for certification as Expert Users of Excel 97

After this course the student should be able to:
1. Perform advanced editing tasks
2. Implement security and auditing procedures
3. Create and modify outlines
4. Consolidate data

4 hours

Proficiency in the use of Excel 97 and comprehensive understanding of all the topics covered in Microsoft Office 97: Advanced Excel 97

To enable students to maximize their usage of all Excel 97's functionality and to prepare students for certification as Expert Users of Excel 97

After this course the student should be able to:
1. record, run, and edit macros
2. use database functions and run Web queries
3. share data with other workbooks and other applications