Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.

---

The training system for Microsoft Excel 2000 spans 3 CD-ROM's and contains over 6 hours of professional quality instructor led training. Multimedia content allows you to quickly learn Excel concepts and the CD format lets you quickly pause and review important areas. After completing the course you will be prepared to take and pass the CS244 Microsoft Excel certification exam. A detailed outline of the course as well as a short introduction to the trainer are included below.

Microsoft Excel 2000 3 CD-ROM Set. $157.00    2-Year NCSA Certification. (must pass exam) FREE    Shipping. FREE

About The Trainer:

Dennis P. Taylor currently trains employees at Amgen, IBM, and other companies in his specialized area of spreadsheet software. Dennis has over 15 years experience presenting PC software to individuals and seminar groups. He has also co-authored a number of books on spreadsheet topics.

Beginning Excel 2000 (2 Hrs 16 Mins)

1.0 The Excel Screen (32 Mins)
1.1 The Excel Workbook & Worksheets
1.2 Title Bar & Menu Bar
1.3 Toolbars
1.4 Formula Bar
1.5 Columns & Rows
1.6 Navigation
1.7 Sheet Names & the Status Bar
1.8 Mouse Pointers & Shortcut Menus
2.0 Entering Data into a Worksheet (27 Mins)
2.1 Data Entry Techniques
2.2 Auto-Fill Entry Techniques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Mins)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition & Subtraction
4.0 Basic Functions (21 Mins)
4.1 Summation
4.2 Recalculating Effects
4.3 Averages
5.0 Formatting (13 Mins)
5.1 The Formatting Toolbar
5.2 Adjusting Column-width & Row-height
5.3 Numeric Formatting
6.0 Saving (17 mins)
6.1 File Save or File Save as
6.2 Opening a File
6.3 Closing a File
6.4 Creating a new Workbook

Intermediate Excel 2000 (2 Hrs 5 Mins)

1.0 Changing Worksheet Layout (26 Mins)
1.1 Inserting Columns
1.2 Deleting Columns
1.3 Moving Cells
1.4 Copying Cells
2.0 Additional Formatting (6 Mins)
2.1 Formatting Cell Attributes & Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Center Text across Columns
2.5 Hiding & Unhiding Columns & Rows
3.0 Printing (25 Mins)
3.1 Using Print Preview & Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Mins)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Mins)
5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently used Files List
5.4 Sheets in New Workbook
5.5 Default Settings

Advanced Excel 2000 (2 Hrs 2 Mins)

1.0 Adjusting Worksheet Views (13 Mins)
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Mins)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Mins)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard functions
4.0 Logical Functions (30 Mins)
4.1 IF Functions & Relational Operators (> < >= <= = <> )
4.2 Using Words in IF Functions
4.3 Using IF Functions with Arithmetic Operators (* / + -)
4.4 Using Logical Operators (AND & OR) with the IF Function
4.5 Nested IF Functions
4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions
5.0 Date & Time Functions (21 Mins)
5.1 Using Dates as Values
5.2 Entering a Series of Dates
5.3 Date/Time entry Techniques
6.0 Multi-Sheet Workbooks (22 Mins)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting & Deleting Sheets
6.3 Moving
6.4 Formulas across multiple sheets