AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

Excel 2002

Print Version

Microsoft® Excel has become a standard for capturing, sharing, and analyzing spreadsheet data. Learn the fundamentals of Excel 2002, part of Office XP. Learn cell referencing, auditing techniques, VLOOKUP functions, and much more.





3 levels - 87 modules - 9 learning hours

 

Available Options

SINGLE USER: Excel 2002 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$149.00Add To Cart
1 YR ONLINE, e-Study Guides$149.00Add To Cart
CD-ROMs, e-Study Guides$149.00Add To Cart
MULTI USER: Excel 2002 (3 levels)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$298.00Add To Cart
CD-ROMs, e-Study Guides$298.00Add To Cart
For additional licensing options. pricing and information, call 877-752-3529

Course Instructor: Dennis P. 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. Dennis brings a combination of in-depth knowledge and training experience to his spreadsheet training courses. Watch and Learn in minutes with Dennis.

Course Outline

Level 1
The Excel Screen
  • 1.1 The Excel Workbook
  • 1.2 The Task Pane
  • 1.3 Title Bar and Menu Bar
  • 1.4 Toolbars
  • 1.5 Formula
  • 1.6 Columns & Rows
  • 1.7 Navigation
  • 1.8 Sheet Names & the Status Bar
  • 1.9 Mouse Pointers & Shortcut Menus
Entering Data
  • 2.1 Data Entry Techniques
  • 2.2 AutoFill Entry Techniques
  • 2.3 Erasing Data
  • 2.4 AutoComplete & Pre-selection
  • 2.5 IP Classes
Entering Formulas
  • 3.1 Three Methods of Entering Formulas
  • 3.2 Repeating a Formula in Adjacent Cells
  • 3.3 Additional Formulas
Basic Excel Functions
  • 4.1 Summation & Averaging
  • 4.2 Recalculating Effects
  • 4.3 Other Functions
Formatting
  • 5.1 The Formatting Toolbar
  • 5.2 Adjusting Column Widths
  • 5.3 Numeric Formatting
Saving, Opening and Closing Files
  • 6.1 File Save or File Save As
  • 6.2 Opening & Closing a File
  • 6.3 Creating a New Workbook

The Excel Help System


Level 2
Changing Worksheet Layout
  • 1.1 Inserting Columns/Rows/Cells
  • 1.2 Deleting Columns/Rows/Cells
  • 1.3 Moving Cells
  • 1.4 Copying Cells
Additional Formatting
  • 2.1 Formatting Cell Attributes & Alignment
  • 2.2 Borders
  • 2.3 Numeric Formatting
  • 2.4 Centering Text Across Columns
  • 2.5 Hiding and Unhiding Columns & Rows
Printing
  • 3.1 Using Print Preview & Page Setup
  • 3.2 Printing Controls
  • 3.3 Using Page Break Preview
Using Cell References
  • 4.1 Absolute References
  • 4.2 Mixed References
The Tools Options Command
  • 5.1 Show/Hide Gridlines
  • 5.2 File List & New Workbook
  • 5.3 Default Settings
Introduction to Charting-An Overview
  • 6.1 Quick Chart Creation
  • 6.2 Chart Types
  • 6.3 Titles/Gridlines & Scaling
  • 6.4 Formatting Basics
  • 6.5 Printing & Copying Charts
Level 3
Adjusting Worksheet Views
  • 1.1 Freeze/Unfreeze Panes
  • 1.2 Horizontal & Vertical Split Screens
Formula Auditing Techniques
  • 2.1 Using the Formula Auditing Toolbar
  • 2.2 Tracing Dependent Cells
  • 2.3 Tracing Precendent Cells
The IF and VLOOKUP Functions
  • 3.1 IF & VLOOKUP Functions Operators
  • 3.2 Logical Operators
  • 3.3 Nested IF Functions
  • 3.4 Getting Data from Tables
Dates & Times
  • 4.1 Using Dates as Values
  • 4.2 Entering a Series of Dates
  • 4.3 Date/Time Entry Techniques
Multi-Sheet Workbooks
  • 5.1 Renaming Sheets
  • 5.2 Inserting & Deleting Sheets
  • 5.3 Moving/Copying & Grouping
  • 5.4 Formulas across Multiple Sheets
Introduction to Database Features
  • 6.1 Sorting Data
  • 6.2 Creating Subtotals
  • 6.3 Filtering
  • 6.4 Pivot Tables