|
Provided by: 123-CBT Computer Based Training Office 2000 Development Excel Development - Level 4 |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 Recording & Running a Macro
1.2 Assigning to a Command Button
1.3 Viewing Modules
1.4 Recording Options
1.5 Hot Keys
1.6 Editing
1.7 Project Options
2.0 Exploring Excel Objects & Collections (40 Mins)
2.1 Review Object Model
2.2 Application Object
2.3 Workbook Collection
2.4 Workbook Object
2.5 Worksheet Collection & Worksheet Object
2.6 Range Object
2.7 Active Workbook, Active Sheet & Active Cell
3.0 User Defined Functions (4 Mins)
3.1 Creating & Using User Defined Functions
4.0 Excel Events (16 Mins)
4.1 Workbook Events
4.2 Worksheet Events
4.3 Class Modules & Application Events
4.4 Enabling & Disabling Events
5.0 Practical Examples (28 Mins)
5.1 Chart Options
5.2 Loan Calculator
5.3 Entering & Validating Data
Level 4 (Excel Development) (2 Hrs 5 Mins)
1.0 Getting Started (36 Mins)1.1 Recording & Running a Macro
1.2 Assigning to a Command Button
1.3 Viewing Modules
1.4 Recording Options
1.5 Hot Keys
1.6 Editing
1.7 Project Options
2.0 Exploring Excel Objects & Collections (40 Mins)
2.1 Review Object Model
2.2 Application Object
2.3 Workbook Collection
2.4 Workbook Object
2.5 Worksheet Collection & Worksheet Object
2.6 Range Object
2.7 Active Workbook, Active Sheet & Active Cell
3.0 User Defined Functions (4 Mins)
3.1 Creating & Using User Defined Functions
4.0 Excel Events (16 Mins)
4.1 Workbook Events
4.2 Worksheet Events
4.3 Class Modules & Application Events
4.4 Enabling & Disabling Events
5.0 Practical Examples (28 Mins)
5.1 Chart Options
5.2 Loan Calculator
5.3 Entering & Validating Data
|
|
Office 2000 Development Excel Development - Level 4
--
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
-...
