Microsoft Excel 220 Tutorial Outline

0. INTRODUCTION
Objectives
Pre-Requisites

1. DATA LISTS
Data Lists Defined
Header Row
Fields
Records
Database Terminology
Pick From List

2. FORMATTING DATA LISTS
Formatting the Header Row
Freezing Panes (review)
Calculate Time Difference (in hours)
Absolute References (review)
Conditional Formatting (review)
Spreadsheet v. Database (when to switch)

3. DATA ENTRY FORMS
Data entry forms defined
Opening the data form
Moving between fields
Entering data
New records
Find Previous
Find Next
Deleting records
You can't undo deletes
Calculated fields in data forms
Searching for records
Search Criteria
Using wildcard characters * and ?
Wildcard rules
Restore button

4. ADVANCED SORTING
The sum preview on the status bar
Changing from sum to a different function
Count v. Count Nums
Sorting month names in month order (not alpha)
First key sort order
Sort options
Custom Lists (using in sorts)
Sorting on more than 3 fields
Restoring a list's original sort order
Alphanumeric sorting rules

5. CUSTOMIZING TOOLBARS
Toolbars and commands defined
Customizing built-in toolbars
Reviewing the command button options
Moving buttons around
Removing buttons from toolbars
Copying a button from one toolbar to another
Resetting a toolbar to its default settings
Changing a button from icon to text
Creating a New Toolbar
Attaching a toolbar to a workbook (to share it)
Change Button Image
Creating a custom button image
Button Editor
Edit Button Image
Copying ANY image onto a button
Changing the tooltip text
Toolbars Options tab
Toolbar Quick-Add Buttons
Toolbar buttons with dual functions
How to backup your custom toolbars

8. REVIEW
Review Topics