Microsoft Excel XP Basic Training Course
All three of the following courses for the special price of $159.95!
Covers Microsoft Excel 2002
$159.95US
Microsoft Excel XP Beginning
The Excel Screen: Overview; Screen Elements
Entering Data: Data Entry Techniques; AutoFill Entry Techniques; Erasing Data;
AutoComplete; Undo & Re-do
Entering Formulas: Three Methods of Entering Formulas; Repeating a Formula in Adjacent Cells;
Formulas Beyond Addition & Subtraction
Basic Excel Functions: Summation; Recalculating Effects & Hierarchy of Operations;
Other Functions
Formatting: The Formatting Toolbar; Adjusting Widths & Row Heights; Numeric Formatting
Saving, Opening & Closing Files: File Save & File Save As; Opening a File;
Creating a New Workbook
The Help System: Using the Help System
Microsoft Excel XP Intermediate
Changing Worksheet Layout: Inserting Columns, Rows, & Cells; Deleting Columns, Rows, & Cells;
Moving Cells; Copying Cells
Additional Formatting: Formatting Cell Attributes & Alignment; Borders;
Numeric Formatting; Centering Text Across Columns; Hiding & Unhiding Columns & Rows
Printing: Using Print Preview & Page Setup; Printing Controls; Using Page Break & Preview
Using Cell References: Absolute References; Mixed References
The Tools Options Command: Show/Hide Gridlines & Formulas; Recently Used File List;
Sheets in New Workbook; Default Settings
Microsoft Excel XP Advanced
Adjusting Worksheet Views: Freeze/Unfreeze Panes; Horizontal & Vertical Split Screens
Auditing Techniques: Using the Formula Auditing Toolbar; Tracing Dependent Cells;
Tracing Precedent Cells
The IF & VLOOKUP Functions: The IF Functions & Relational Operators;
Using Words in IF Functions; Using Logical Operators; Nested IF Functions;
Getting Data from the Table with a VLOOKUP Function
Date & Time Functions: Using Dates as Values; Entering a Series of Dates;
Date/Time Entry Techniques
Multi-Sheet Workbooks: Renaming & Reordering Sheets; Inserting & Deleting Sheets;
Moving, Copying, & Grouping Sheets; Formulas Across Multiple Sheets
|