About Us Localization Resources Training Consulting Web Design Contact Us Home Page
 
    
Learning
Excel
 
   
 
 
Beginning Excel
  Excel Basics
Navigate Excel
Explore Menus
Select Multiple Cells
Create & Edit a Spreadsheet
Use a Template
Use Help

Formulas and Formats
Create a Formula
Use ƒunctions
The Formula Palette
Use Auto Sum
Use the Fill Commands
Create Absolute References
Format Values
Use Auto Format
Use Conditional Formatting

Preview and Print

Check Spelling
Orient the Document
Adjust the Margins
Center the Printout
Create Headers & Footers
Scale the Print Area

Charts
Use the Chart Wizard
Explore Chart Types
Edit a Chart
Save a Chart Sheet
Class List
Intermediate Excel
  Database Basics
Create and Sort a Database
Perform Multiple Sorts
Use the Data Form
Locate Records
Delete Records

Database Management
Use AutoFilter
Use Compound Criteria
Extract Unique Records
Use Database Functions
Create a Pivot Table

Linking and Protecting

Formula-Link Worksheets
Command-Link Worksheets
Use a Name Range
Link Workbook Files
Consolidate Worksheets
Assign a Password
Protect Cells and Objects
Outline a Worksheet
Create Report Views

Customizing Excel
Create a Cell Tip
Create a Custom Menu
Create a Custom Toolbar
Protecting Data


Class List