Excel Windows 2000: Upgrade from 7 or 97

Course Code: EXCW00-U
Time: 3.5 hours
Prerequisites: Windows 95: Introduction and extensive Excel Windows 7/97 experience
The Basics
Starting Excel 2000
Windows 95/98 Screen Elements
Personalized Menus
Shortcut Menus
Excel Screen Elements

Working With Files
File Management
The New Dialog Box Buttons
Files on the Task Bar
File Compatibility
Getting Data From Older Versions
Getting Data To Older Versions
Workbook Templates

The Upgrade
Visual Changes
The Workbook
The Worksheet Border
See-Through Selections
Help, I Need an Assistant!
Toolbars
Hiding/Displaying Toolbars
Moving Toolbars and Menus
Displaying Hidden Buttons

Bells and Whistles
Undo
List AutoFill
Cell Comments
Cell Formatting Enhancements
Orientation
Shrink to Fit
Merge Cells
Conditional Formatting
Drag and Drop Enhancements
Formula Enhancements
The Edit Formula Button and Formula Palette
The Range Finder
Natural Language Formulas
Printing Enhancements
Page Break Preview
Some Other New Features
Dates and the Year 2000

Return to Course Listing | Home Page