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
Upgradeteaches 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