Excel Windows 7: Upgrade from Excel 5

Course Code: EXCW7-U
Time: 3.5 hours
Prerequisites: Windows 95 and extensive experience in Excel Windows 5
The Upgrade
Setting Up For Class
Starting Excel 7
Windows 95 Screen Elements
Excel Screen Elements
Shortcut Menus
Help!
The Help Button
The Tip Wizard
Searching for Help
In the Help Window

File Management
File Management Enhancements
File Properties
The Summary Property
General Properties
The Contents Property
Custom Properties
File Management
Finding Files
Saving Searches
The File Dialog Button Bar
Send To and Delete
Workbook Templates

Bells and Whistles
AutoCorrect
AutoComplete
AutoCalculate
Cell Notes
Scroll Tips
Drag and Drop Enhancements
Number Formats
AutoFilter with Top 10
Top 10
The Data Map Add-In
Map Data
Creating the Map
Controlling the Map
Customizing the Map
Grabbing the Map
Adding Map Features
Custom Pin Maps

Return to Course Listing | Home Page