Excel 97
Inquire about Microsoft Office 2000 and XP Training
 Teach your end-users all aspects of using Microsoft's spreadsheet tool! From searching
and replacing text, to advanced formatting techniques. Students will gain vital knowledge of the Excel environment. Our Excel 97 Learning System is perfect for a successful migration or implementation to
Microsoft's Office 97.
The CD-ROM include unique features such as Full Multi-Media, Bookmarking, Random Access Help Index, and Quizzes, and through the extensive use of software simulations the
actual need for the application software is not required. Covers training for MOUS certification.
Microsoft Office 97 Training Interactive CD-ROM - Excel
EXCEL BASICS
Screen Layout
Introducing Excel 97
Columns , Rows & Cells
Title Bar
Menu Bar
Toolbars
Scroll Bars
Status Bar
Creating & Opening a Workbook
Create a Workbook
Open an Existing Workbook
(exercise)
Editing Tools
Find & Replace Data (exercise)
Undo & Redo Commands
Viewing Worksheets
Views, Introduction
Splitting Sheets
Saving & Closing Workbooks
Save a Workbook
Close a Workbook
Printing
Overview
Printing (exercise)
Printing Multiple Worksheets
Create & Print Headers and Footers
(Exercise)
Getting Help
Office Assistant
Change the Office Assistant Character
Change the Office Assistant
Character (exercise)
The Help Menu
More About the Help Menu
WORKING WITH CELLS
Selecting Cells
Cell Reference
Selecting Cells (exercise)
Entering Data
Enter Data
Values
Labels
Editing Data
Edit Data (exercise)
Copying & Moving Data
Copy & Move Data
Cut, Copy & Paste (exercise)
Drag-and-drop
Working with Ranges
Create & Name Ranges (exercise)
MANAGING YOUR WORKSHEETS
Modifying a Worksheet
Insert Rows & Columns (exercise)
Delete Rows & Columns (exercise)
Insert Cells (exercise)
Delete Cells (exercise)
Adjust Column Width
Adjust Column Width (exercise)
Adjust Row Height
Adjust Row Height (exercise)
Modifying a Workbook
Insert a Worksheet (exercise)
Delete a Worksheet (exercise)
Rename a Worksheet (exercise)
Move & Copy a Worksheet in the
Same Workbook
Move & Copy a Worksheet to
Another Workbook (exercise)
Playing With The Numbers
Lists [EXP]
What is a List?
Create a List (exercise)
Use a Data Form (exercise)
Analyzing List Data [EXP]
Sorting
Complex Sorting (exercise)
Multiple Sorts
AutoFilter Data (exercise)
PivotTables
Create a Pivot Table (exercise)
"Pivot" the Table
"Pivot" the Table (exercise)
Querying External Data [EXP]
Overview
Define the Data Source (exercise)
Use the Query Wizard
Return Results to Excel
What-If Data Analysis [EXP]
Goal Seek (exercise)
Solver
Scenarios
DOING THE MATH
Formulas
Overview
Create a Formula (exercise)
Use Names in Formulas
Edit & Copy Formulas (exercise)
Cell References
Relative References
Absolute References (exercise)
Mixed References
Functions
Overview
Enter a Function Manually
(exercise)
Use 'Paste Function' (exercise)
Auditing Worksheet Data [EXP]
The Auditing Toolbar
MAKING IT LOOK GREAT
Overview
Overview
Formatting Text & Numbers
Overview
Format Text (exercise)
Format Numbers
Format Numbers (exercise)
Advanced Formatting [EXP]
Format Numbers Using the 'Format Cells' Dialog Box (exercise)
Create Custom Formats
Formatting Cells
Cell Alignment
Cell Alignment (exercise)
Apply Borders, Colors and Patterns
Conditional Formatting [EXP]
Conditional Formatting
Conditional Formatting (exercise)
The Drawing Tools
The Drawing Toolbar
Create a Drawing Object
Work with Drawing Objects
(exercise)
Templates [EXP]
Overview
Use a Built-in Template to Create a
Workbook (exercise)
Customize Templates (exercise)
Create a New Template From an Excel Workbook
Opening Templates
Data Validation (exercise)
USING CHARTS AND MAPS
Creating a Chart
What is a Chart?
Use Chart Wizard (exercise)
Modifying & Formatting a Chart
Change Chart Type (exercise)
Enhance a Chart
Format a Chart
Move, Resize & Delete a Chart
Using a Data Map [EXP]
Microsoft Map
Create a Map (exercise)
Automating Your Work
Overview
Overview
AutoFill and AutoComplete
AutoFill
Use AutoFill (exercise)
AutoComplete
AutoSum and AutoCalculate
AutoSum
Use AutoCalculate (exercise)
AutoFormat [EXP]
Use AutoFormat (exercise)
Styles [EXP]
Overview
Create a New Style (exercise)
Apply Styles
Macros [EXP]
Macros
Record and Assign a Macro
(exercise)
Edit Macros
SHARING INFORMATION
Converting Data to HTML
Overview
Convert Excel Data to HTML (exercise)
Linking Workbooks [EXP]
Links vs. Hyperlinks
Link Workbooks (exercise)
Update Links
Delete a Link (exercise)
Create a Hyperlink (exercise)
Sharing Workbooks [EXP]
Overview
Set Up a Workbook for Sharing (exercise)
Save Changes to a Shared
Workbook
Track Changes in a Shared
Workbook
Highlight & Review Changes
(exercise)
View the Change History
(exercise)
End a Shared Workbook Session
(exercise)
Merge a Shared Workbook
Exchanging Data [EXP]
Drag-and-Drop
Edit Menu Commands (exercise)
Object Linking & Embedding
Link Objects (exercise)
Import Files From Other Programs
Import a Text File (exercise)
Export an Excel File
Return to Main Page
|
