Office XP |
|
|
|
Topics:
Introducing Word XP
Moving, Copying and Saving
Formatting Text
Document Layout Features
Graphic Tools
Proofing and Printing Documents
Outlining and Templates
File Management and Web Tools
Objectives:
- Word and Office Assistant
- Screen Components
- Navigation Tools
- Creating Documents
- Moving and Copying Text
- Opening, Saving and Closing
- Basic Text Formatting
- Automated Formatting
- Formatting Paragraphs
- Formatting with Tabs
- Creating and Modifying Tables
- Formatting Tables
- Page Design
- Working with Columns
- Headers and Footers
- Clip Art
- Graphics and Text Enhancements
- Drawing Tools
- Proofing Tools
- Find and Replace
- Printing Documents
- AutoCorrect Features
- Envelopes and Labels
- Outlining
- Working with Templates
- File Management Techniques
- Creating Web Pages
- Documents and E-mail
|
| Top |
|
|
Topics:
Introducing Excel XP
Moving, Copying and Saving
Formulas, Functions and Ranges
Formatting Techniques
Working with large Spreadsheets
Proofing and Printing Spreadsheets
Charting
Web Tools
Objectives:
- Starting Excel and Office Assistant
- Screen Components
- Navigating Workbooks
- Creating Worksheets
- Moving and Copying Cells
- Opening, Saving and Closing
- Formulas and Functions
- Working with Ranges
- Relative & Absolute References
- Paste Functions
- Toolbar Formatting
- Menu Bar Formatting
- Additional Formatting Features
- 3-D Workbooks
- Previewing and Printing
- Splitting, Freezing and Hiding
- Proofing Tools
- Page Breaks and Previewing
- Page Setup Options
- Print Areas and Printing
- Creating and Modifying Charts
- Working with Chart Objects
- Creating a Web Page
- Worksheets and E-mail
|
| Top |
|
|
Topics:
Introducing PowerPoint XP
Creating, Saving & Closing Files
Slide Design
Templates and Drawing Tools
Presentation Masters
Slide Shows and Printing
The Web and Email
Objectives:
- Starting PowerPoint
- Screen Components
- View Buttons
- Creating New Presentations
- Opening, Saving and Closing
- Using Existing Presentations
- Slide View
- Outline View
- Arranging Slides
- Slide Layout
- Templates
- Drawing Tools
- Creating Charts
- Enhancing Charts
- Tables
- Working with Slide Shows
- Spell Checking and Printing
- Publishing Web Presentations
- Emailing Presentations
|
| Top |
|
|
|
Topics:
Introducing Access XP
Working with Tables
Working with Forms
Working with Queries
Working with Reports
Objectives:
- Access Screen Components
- Opening Database Objects
- Data Entry and Navigation
- Creating Tables
- Modifying the Table Design
- Working with Records
- Importing Data
- Table Relationships
- Creating and Using Forms
- Modifying Forms
- Formatting Forms
- Creating and Running Queries
- Joining Tables
- Action and Cross tab Queries
- Creating a Report
- Previewing and Printing
- Report Modification
|
| Top |
|
|
|
Topics:
To be included
Objectives:
|
| Top |
|
|
|
Topics:
Introducing Outlook XP
Sending and Receiving Mail
Items, Folders and Documents
The Calendar
Contacts List and Customising
Tasks List, Journal and Notes
Objectives:
- Starting Outlook
- Screen Components
- Outlook Folders
- Printing in Outlook
- Creating and Sending Messages
- Working with Existing Messages
- Message Handling Tools
- Signatures
- Stationery and Templates
- Customising Address Books
- Viewing Items
- Finding Items
- Working with Folders
- Archiving Folders
- Using Documents
- Entering Appointments
- Viewing and Arranging Itemss
- Planning Meetings
- Adding Events
- Saving as Web Page
- Adding Contacts
- Using the Contacts List
- Additional Contact Tools
- Customising Outlook
- Creating Tasks
- Working with Existing Tasks
- Delegating Tasks and AutoCreate
- The Journal
- Notes
|
| Top |
|
|
|
Topics:
Macros and Custom Toolbars
Named Ranges and Lookup
Working With Data
Consolidating and Linking
Group Editing
Audit, Scenarios, Views and Reports
Data Filters, Goals and Pivot Tables
Objectives:
- Working with Macros
- Custom Toolbars
- Named Ranges
- Lookup Functions
- Importing Data
- Conditional Formatting
- Data Validation
- Outlining
- Creating a Workspace
- Consolidating Data
- Linking Workbooks
- Sharing and Protecting
- Working with Comments
- Tracking Changes
- Auditing Tools
- The Scenario Manager
- Custom Views
- The Report Manager
- Data Forms
- Filtering Data
- Sorting and Sub-Totals
- Goal Seeker and Solver
- Pivot Tables
- Pivot Tables on the Web
|
| Top |
|
|
|
Topics:
Advanced Formatting Features
Mail Merge and Macros
Tables and Charts
Multi-user Documents and Forms with Fields
Printing Envelopes and Labels
Working with SmartTags
Watermarks and Customizing Toolbars
Working with Long Documents
Objectives:
- Auto text
- Sorting Paragraphs and Lists
- Creating and Editing Styles
- Other Paragraph Features
- Translating Text
- Hyphenating Your Documents
- Mail Merge Techniques
- Advanced Mail Merge Features
- Macros
- Advanced Table Features
- Creating Charts
- Editing and Formatting Charts
- Embedding and Linking Objects
- Group Editing Options
- Version Features
- Working with Form Fields
- Creating Form Templates
- Watermarks
- Customizing Word
- Group Editing & Forms with Fields
- Index and Tables Command
- Footnotes and Endnotes
- Working with Master Documents
- Managing Sub-documents
|
| Top |
|
|
|
Topics:
New Features in XP
Objectives:
- Task Panes
- Smart Tags
- Template Gallery
- Design Gallery
|
| Top |
| |
