Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
 
Courses - Microsoft Excel 220

Teacher's Outline

 

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


 

 

You may want to read these articles from the 599CD News:

 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
 

What's New  |  Home  |  Courses  |  Demo  |  Learn More  |  Contact  |  Order