|
Provided by: 123-CBT Computer Based Training Excel 2000 Advanced |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Minutes)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Minutes)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard functions
4.0 Logical Functions (30 Minutes)
4.1 IF Functions and 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 Minutes)
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 Minutes)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting and Deleting Sheets
6.3 Moving, Copying and Grouping Sheets
6.4 Formulas across multiple sheets
Advanced (2 Hours 2 Minutes)
1.0 Adjusting Worksheet Views (13 Minutes)1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Minutes)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Minutes)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard functions
4.0 Logical Functions (30 Minutes)
4.1 IF Functions and 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 Minutes)
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 Minutes)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting and Deleting Sheets
6.3 Moving, Copying and Grouping Sheets
6.4 Formulas across multiple sheets
|
|
||||||||
Excel 2000 Advanced
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
