Microsoft Office XP
The Microsoft Office XP Upgrade Series introduces students to new basic and advanced features of Microsoft Office XP. Ideal for students who are already familiar with an earlier edition of Microsoft Office, this series focuses on what students need to know to be effective immediately in the new application.
1. Microsoft Word XP Upgrade teaches students the major differences of the User Interface from Word 97 to Word 2002.
Objectives
After taking this course, students will be able to:
， Identify and use new task panes for formatting and mail merge
， Use the Smart Tags feature
， Use the translation, speech recognition, and word count features for added functionality
， Apply new features for working with bulleted and numbered lists
， Use new formatting features to enhance your documents
， Format tables using table styles
， Create Web pages using Web Page Wizard
， Send e-mails directly from Word
， Use reviewing and document collaboration features
， Use document recovery and security features to protect your work
Prerequisites
To get the most out of this course, students should be familiar with the basic functions of Word 97 or 2000, including:
， Typing documents
， Applying fonts, styles, and formatting
， Laying out and printing pages
， Saving and managing files
， Using cut, copy, and paste
Content:
Module 1: Course
introduction
1- Course introduction
2- Prerequisites
3- What you need
4- Course resources
5- Your learning community
6- Meet your instructor
7- The course exercise
Module 2: Using basic new
features
1- Using basic new features
2- Task panes
3- Smart tags
4- Translate, speech, and word count features
5- Bulleted and numbered lists
6- New formatting features
7- Module wrap-up
Module 3: Using advanced
new features
1- Using advanced new features
2- Table formatting
3- Using Word with the Web
4- Sending and receiving Word documents
5- Reviewing and collaboration features
6- Document recovery and security features
7- Module wrap-up
Module 4: Course exercise
1- Course exercise
2- Using Smart Tags to insert an address
3- Custom watermarks
4- The Web Page Wizard
5- Document collaboration
6- Where do you go from here?
7- We'd love your feedback
8- Course survey
2. Microsoft
PowerPoint XP Upgrade
provides students with an overview of the PowerPoint 2002 User Interface and an
introduction to new basic and advanced features.
Objectives
After taking this course, students will be able to:
， Use new viewing features and task panes
， Use the Smart Tags feature
， Use new and improved layout and design tools
， Create a PowerPoint photo album
， Use the presenter tool and print preview feature
， Use animation schemes and create custom animations
， Work with multiple masters to format slides in a presentation
， Use collaboration tools to work with others in creating presentations
， Use document recovery and protection tools
Prerequisites
To get the most out of this course, students should be familiar with the basic
functions of PowerPoint 97 or 2000 and be able to:
， Navigate the PowerPoint interface.
， Create and edit basic presentations and use templates.
， Handle basic formatting of PowerPoint text and insert objects into presentation slides.
Content:
Module 1: Course
introduction
1- Course introduction
2- Prerequisites
3- What you need
4- Course resources
5- Your learning community
6- Meet your instructor
7- The course exercise
Module 2: Using basic new
features
1- Using basic new features
2- New viewing features
3- Smart tags
4- New layout and design tools
5- The photo album feature
6- Presenter and print preview tools
7- Module wrap-up
Module 3: Using advanced
new features
1- Using advanced new features
2- New animation features
3- Working with multiple masters
4- Collaboration tools
5- Document recovery features
6- Document protection features
7- Module wrap-up
Module 4: Course exercise
1- Course exercise
2- Slide Design task pane
3- The AutoCorrect options smart tag
4- Image compression
5- Custom animations
6- Where do you go from here?
7- We'd love your feedback
8- Course survey
3. Microsoft Excel XP
Upgrade
presents students with a concise overview of the new features in Excel 2002.
Students will learn how to use each feature, how to change settings, and how to
get the most out of these new features in the real world.
Learning Objectives
After taking this course, students will be able to:
， Use Excel's new color coding, border drawing, and sort text as numbers features
， Use the watch window and tooltips features
， Collaborate with others using the Send for Review and Compare and Merge features
， Use Excel's Web features to publish spreadsheets to the Web
， Protect documents with the document recovery and repair features
， Use the extended AutoSum, find and replace, and cell merging features
， Use the Error Checking and Stock Quote smart tags
， Use the Formula Evaluator and Formula Auditing features
， Improve productivity with speech recognition and text-to-speech features
， Protect Excel documents with improved security features
Prerequisites
To get the most out of this course, students should be familiar with the basic functions of Excel 97 or 2000 and be able to:
， Navigate Excel's views and interface
， Create, save, and manage documents
， Enter data and formulas
， Perform basic formatting and editing operations
Content:
Module 1: Course
introduction
1- Course introduction
2- Prerequisites
3- What you need
4- Course resources
5- Your learning community
6- Meet your instructor
7- The course exercise
Module 2: Using basic new
features
1- Using basic new features
2- Basic usability features
3- Watch window and tooltips
4- Spreadsheet collaboration features
5- Using Excel Web features
6- Document and application recovery
7- Module wrap-up
Module 3: Using advanced
new features
1- Using advanced new features
2- Advanced usability features
3- Smart tags
4- Formula Auditing and Formula Evaluator
5- Using Excel's speech features
6- Security and document protection
7- Module wrap-up
Module 4: Course exercise
1- Course exercise
2- Color coding
3- Excel Web features
4- Extended AutoSum
5- The Stock Quote smart tag
6- Where do you go from here?
7- We'd love your feedback
8- Course survey
4. Microsoft Access XP
Upgrade teaches
students how to use the new features in available in Access 2002.
Objectives
After taking this course, students will be able to:
， Use the new multiple undo and redo feature
， Use new and improved file format support
， Identify new shortcut keys and accessibility features
， Use improved subforms and spelling checker
， Use new PivotTable and PivotChart views
， Publish data to the Web using Internet standard XML format
， Save forms and reports as Data Access pages
， Use the Compact and Repair feature
， Set international preferences
， Use new speech features
Prerequisites
To get the most out of this course, students should be familiar with the basic
functions of Access 97 or 2000 and be able to:
， Navigate Access views, toolbars, and interface
， Create and edit basic databases and use templates
， Understand basic database components: tables, queries, forms, and reports
Content:
Module 1: Course
introduction
1- Course introduction
2- Prerequisites
3- What you need
4- Course resources
5- Your learning community
6- Meet your instructor
7- The course exercise
Module 2: Using basic new
features
1- Using basic new features
2- Multiple undo and redo
3- Supported file formats
4- Shortcut keys and accessibility features
5- Improved subforms and spelling checker
6- PivotTable and PivotChart views
7- Module wrap-up
Module 3: Using advanced
new features
1- Using advanced new features
2- XML presentation output
3- Data Access pages
4- Compact and Repair
5- International and multilanguage support
6- Speech features
7- Module wrap-up
Module 4: Course exercise
1- Course exercise
2- Converting a database to Access 2002 format
3- Data Access pages
4- Improved Access subforms
5- International preferences
6- Where do you go from here?
7- We'd love your feedback
8- Course survey