Font size:

Interactive Instructor-Based Excel XP Essentials Video Training Course on DVD-ROM. Computer Based Training (CBT) and Video Based Training (VBT) have emerged as the premier training tools in recent years. KeyStone Self-Paced CBT/VBT courses are known for their high quality in-depth content. Compared to traditional training methods, KeyStone courses cost less and users can learn faster while taking advantage of some of the best trainers in the industry. They are easy to use, comfortable to follow, perfect for training at the office, on the road, or at home.

Levels included: • Beginner • Intermediate • Advanced

Trainer Information: Dennis Taylor Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Five years ago, he turned his attention to Excel spreadsheets and has become an Excel training specialist. 1.0 The Excel Screen 1.1 Overview 1.2 Screen Elements 2.0 Entering Data 2.1 Data Entry Techniques 2.2 AutoFill Entry Techniques 2.3 Erasing Data 2.4 AutoComplete 2.5 Undo and Re-do 3.0 Entering Formulas 3.1 Three Methods of Entering Formulas 3.2 Repeating a Formula in Adjacent Cells 3.3 Formulas Beyond Addition & Subtraction 4.0 Basic Excel Functions 4.1 Summation 4.2 Recalculating Effects & Hierarchy of Operations 4.3 Other Functions 5.0 Formatting 5.1 The Formatting Toolbar 5.2 Adjusting Widths and Row Heights 5.3 Numeric Formatting 6.0 Saving, Opening and Closing Files 6.1 File Save and File Save As 6.2 Opening a File 6.3 Creating a New Workbook 7.0 The Help System 7.1 Using the Help System Excel XP: Intermediate Level 1.0 Changing Worksheet Layout 1.1 Inserting Columns, Rows, & Cells 1.2 Deleting Columns, Rows, & Cells 1.3 Moving Cells 1.4 Copying Cells 2.0 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.0 Printing 3.1 Using Print Preview & Page Setup 3.2 Printing Controls 3.3 Using Page Break & Preview 4.0 Using Cell References 4.1 Absolute References 4.2 Mixed References 5.0 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: Advanced Level 1.0 Adjusting Worksheet Views 1.1 Freeze/Unfreeze Panes 1.2 Horizontal and Vertical Split Screens 2.0 Auditing Techniques 2.1 Using the Formula Auditing Toolbar 2.2 Tracing Dependent Cells 2.3 Tracing Precedent Cells 3.0 The IF and VLOOKUP Functions 3.1 The IF Functions & Relational Operators 3.2 Using Words in IF Functions 3.3 Using Logical Operators (AND & OR) with the IF Function 3.4 Nested IF Functions 3.5 Getting Data from the Table with a VLOOKUP Function
Register Now
Microsoft Excel XP Essentials Beginner/Intermediate/Advanced - Instructor-based Video Training Online course
  • Course ID:
  • Duration:
  • Price: