This Online Training Course on MS Excel 2013 Expert Level covers the concepts of Macros and VBA in Excel. The Curriculum includes range objects, sub programs, user forms, data writing and more.
This course is delivered by WIN Corporate Training, a leading Training Institute on Excel for over 14 years.
Curriculum
I
Excel 2013 Expert - VBA and Macros
1 |
Macro VBA basics Part 1
|
17:37
|
2 |
Macro VBA basics Part 2 Preview
|
14:19
|
3 |
Variable Datatype
|
23:12
|
4 |
Comparison Operators
|
24:57
|
5 |
Condition Statement Part 1
|
20:37
|
6 |
Condition Statement Part 2
|
11:55
|
7 |
Loops
|
27:56
|
8 |
Excel VBA Objects
|
04:46
|
9 |
Workbook Object
|
32:10
|
10 |
Worksheet Object Part 1
|
07:16
|
11 |
Worksheet Object Part 2
|
23:41
|
12 |
Range Object Part 1
|
28:19
|
13 |
Range Object Part 2
|
22:11
|
14 |
Range Object Part 3
|
23:23
|
15 |
Range Object Part 4
|
21:30
|
16 |
Range Object Part 5
|
19:50
|
17 |
Range Object Part 6
|
18:07
|
18 |
Sub Programs in VBA Functions and Procedures Part 1
|
17:05
|
19 |
Sub Programs in VBA Functions and Procedures Part 2
|
15:11
|
20 |
User Forms and Controls Part 1
|
15:55
|
21 |
User Forms and Controls Part 2
|
07:37
|
22 |
Writing Data to the excel File using VBA
|
10:01
|
23 |
Sorting Filtering Charts Pivot Table in VBA Part 1
|
18:35
|
24 |
Sorting Filtering Charts Pivot Table in VBA Part 2
|
14:21
|
|
Excel Practise Test 1
|
|