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.
Excel
2000 Essentials set of 3 (CD)
| $159.95
|
|
Excel
2000 Essentials set of 3 (VHS)
| $159.95
|
|
Shipping (US only)
| 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
|