Excel XP Training: Beginning

1. Excel XP Training: The Excel Screen
   1.1 Overview
   1.2 Screen Elements
   
2. Excel XP Training: Entering Data
   2.1 Data Entry Techniques
   2.2 AutoFill Entry Techniques
   2.3 Erasing Data
   2.4 AutoComplete
   2.5 Undo & Re-do
   
3. Excel XP Training: Entering Formulas
   3.1 Three Methods of Entering Formulas
   3.2 Repeating a Formula in Adjacent Cells
   3.3 Formulas Beyond Addition & Subtraction
   
4. Excel XP Training: Basic Excel Functions
   4.1 Summation
   4.2 Recalculating Effects & Hierarchy of Operations
   4.3 Other Functions
   
5. Excel XP Training: Formatting
   5.1 The Formatting Toolbar
   5.2 Adjusting Widths & Row Heights
   5.3 Numeric Formatting
   
6. Saving, Opening & Closing Files
   6.1 File Save & File Save As
   6.2 Opening a File
   6.3 Creating a New Workbook
   
7. Excel XP Training: The Help System
   7.1 Using the Help System
   

Excel XP Training: Intermediate

1. Excel XP Training: Changing Worksheet Layout
   1.1 Inserting Columns, Rows, & Cells
   1.2 Deleting Columns, Rows, & Cells
   1.3 Moving Cells
   1.4 Copying Cells
   
2. Excel XP Training: Additional Formatting
   2.1 Formatting Cell Attributes & Alignment
   2.2 Borders
   2.3 Numeric Formatting
   2.4 Centering Text Across Columns
   2.5 Hiding & Unhiding Columns & Rows
   
3. Excel XP Training: Printing
   3.1 Using Print Preview & Page Setup
   3.2 Printing Controls
   3.3 Using Page Break & Preview
   
4. Excel XP Training: Using Cell References
   4.1 Absolute References
   4.2 Mixed References
   
5. Excel XP Training: The Tools Options Command
   5.1 Show/Hide Gridlines & Formulas
   5.2 Recently Used File List
   5.3 Sheets in New Workbook
   5.4 Default Settings
   

Excel XP Training: Advanced

1. Excel XP Training: Adjusting Worksheet Views
   1.1 Freeze/Unfreeze Panes
   1.2 Horizontal & Vertical Split Screens
   
2. Excel XP Training: Auditing Techniques
   2.1 Using the Formula Auditing Toolbar
   2.2 Tracing Dependent Cells
   2.3 Tracing Precedent Cells
   
3. Excel XP Training: The IF & VLOOKUP Functions
   3.1 The IF Functions & Relational Operators
   3.2 Using Words in IF Functions
   3.3 Using Logical Operators
   3.4 Nested IF Functions
   3.5 Getting Data from the Table with a VLOOKUP Function
   
4. Excel XP Training: Date & Time Functions
   4.1 Using Dates as Values
   4.2 Entering a Series of Dates
   4.3 Date/Time Entry Techniques
   
5. Excel XP Training: Multi-Sheet Workbooks
   5.1 Renaming & Reordering Sheets
   5.2 Inserting & Deleting Sheets
   5.3 Moving, Copying, & Grouping Sheets
   5.4 Formulas Across Multiple Sheets
   

Return to the Excel 2002/XP Training Main Page Detailed Video Outlines Excel 2002/XP Training DVD Outline Check out the complete list of Keystone Training

A-Z Software Products

Excel 2002/XP Training Return Policy: You may open and view 1 DVD for "demo" purposes and still be able return the product within 15 days. Any Keystone Training Products that have more than 1 DVD opened or unsealed, are no longer covered under the 15 Day Money Back Guarantee Policy.

©Copyright 2008 HALLoGRAM Publishing, Aurora CO. All Rights Reserved. All products mentioned in this site are trademarks of their respective owners.