|
|
001 Arithmetic Operators Introduction.mp4
|
MP4
|
21.6 MB
|
|
|
001 Arithmetic Operators Introduction_en.srt
|
SRT
|
4.4 KB
|
|
|
001 Arithmetic-Operators.xlsm
|
XLSM
|
13.6 KB
|
|
|
001 Capturing-Errors.xlsm
|
XLSM
|
13.7 KB
|
|
|
001 Consolidation-Tool.xlsm
|
XLSM
|
30.3 KB
|
|
|
001 Course Introduction.mp4
|
MP4
|
6.8 MB
|
|
|
001 Course Introduction_en.srt
|
SRT
|
921.6 B
|
|
|
001 Date Functions Introduction (Part 1).mp4
|
MP4
|
42 MB
|
|
|
001 Date Functions Introduction (Part 1)_en.srt
|
SRT
|
8.2 KB
|
|
|
001 Date-Functions-Part-1.xlsm
|
XLSM
|
15.2 KB
|
|
|
001 Error Handling Introduction.mp4
|
MP4
|
37.7 MB
|
|
|
001 Error Handling Introduction_en.srt
|
SRT
|
8.5 KB
|
|
|
001 Events Introduction.mp4
|
MP4
|
25.6 MB
|
|
|
001 Events Introduction_en.srt
|
SRT
|
5.3 KB
|
|
|
001 Events.xlsm
|
XLSM
|
17.2 KB
|
|
|
001 Excel Object Model.mp4
|
MP4
|
20.6 MB
|
|
|
001 Excel Object Model_en.srt
|
SRT
|
4.1 KB
|
|
|
001 For Loop Introduction.mp4
|
MP4
|
35.4 MB
|
|
|
001 For Loop Introduction_en.srt
|
SRT
|
6.9 KB
|
|
|
001 For-Loop.xlsm
|
XLSM
|
14.6 KB
|
|
|
001 Function Definition, Calling a Function, Sub-Procedure Definition, Calling a Sub.mp4
|
MP4
|
61.3 MB
|
|
|
001 Function Definition, Calling a Function, Sub-Procedure Definition, Calling a Sub_en.srt
|
SRT
|
12.3 KB
|
|
|
001 Functions-and-Sub-Procedures.xlsm
|
XLSM
|
22 KB
|
|
|
001 How to Consolidate Excel Files using VBA.mp4
|
MP4
|
166.7 MB
|
|
|
001 How to Consolidate Excel Files using VBA_en.srt
|
SRT
|
27.8 KB
|
|
|
001 If, If Else, If ElseIf Else Introduction.mp4
|
MP4
|
53.1 MB
|
|
|
001 If, If Else, If ElseIf Else Introduction_en.srt
|
SRT
|
10.3 KB
|
|
|
001 If-Statements.xlsm
|
XLSM
|
16.4 KB
|
|
|
001 Instr Function Introduction.mp4
|
MP4
|
20.5 MB
|
|
|
001 Instr Function Introduction_en.srt
|
SRT
|
4.4 KB
|
|
|
001 Instr-Function.xlsm
|
XLSM
|
12.7 KB
|
|
|
001 MsgBox and InputBox Introduction.mp4
|
MP4
|
30.2 MB
|
|
|
001 MsgBox and InputBox Introduction_en.srt
|
SRT
|
6.2 KB
|
|
|
001 MsgBox-and-InputBox.xlsm
|
XLSM
|
14.5 KB
|
|
|
001 Thank you.mp4
|
MP4
|
787.2 KB
|
|
|
001 Thank you_en.srt
|
SRT
|
307.2 B
|
|
|
001 Understand about Programming Language, Application or Software.mp4
|
MP4
|
21.9 MB
|
|
|
001 Understand about Programming Language, Application or Software_en.srt
|
SRT
|
2.9 KB
|
|
|
001 VBA Tips.mp4
|
MP4
|
57.3 MB
|
|
|
001 VBA Tips_en.srt
|
SRT
|
11.8 KB
|
|
|
001 Variables.mp4
|
MP4
|
13.9 MB
|
|
|
001 Variables_en.srt
|
SRT
|
3 KB
|
|
|
002 Arithmetic Operators in Excel VBA.mp4
|
MP4
|
23.5 MB
|
|
|
002 Arithmetic Operators in Excel VBA_en.srt
|
SRT
|
5.5 KB
|
|
|
002 Data Types, How to Declare Variables, Valid Variable Names, Naming Conventions.mp4
|
MP4
|
83 MB
|
|
|
002 Data Types, How to Declare Variables, Valid Variable Names, Naming Conventions_en.srt
|
SRT
|
15.3 KB
|
|
|
002 Msgbox-Demo.xlsm
|
XLSM
|
11.8 KB
|
|
|
002 Practical Example of Date Functions in Excel VBA (Part 1).mp4
|
MP4
|
117.8 MB
|
|
|
002 Practical Example of Date Functions in Excel VBA (Part 1)_en.srt
|
SRT
|
13.3 KB
|
|
|
002 Practical Example of Debugging.mp4
|
MP4
|
72.6 MB
|
|
|
002 Practical Example of Debugging_en.srt
|
SRT
|
10.5 KB
|
|
|
002 Practical Example of For Loop in Excel VBA.mp4
|
MP4
|
30.9 MB
|
|
|
002 Practical Example of For Loop in Excel VBA_en.srt
|
SRT
|
5.7 KB
|
|
|
002 Practical Example of If Conditional Statement in Excel VBA.mp4
|
MP4
|
16.7 MB
|
|
|
002 Practical Example of If Conditional Statement in Excel VBA_en.srt
|
SRT
|
4.3 KB
|
|
|
002 Practical Example of InStr Function in Excel VBA.mp4
|
MP4
|
41.7 MB
|
|
|
002 Practical Example of InStr Function in Excel VBA_en.srt
|
SRT
|
6.8 KB
|
|
|
002 Practical Example of Worksheet and Workbook Events.mp4
|
MP4
|
72.9 MB
|
|
|
002 Practical Example of Worksheet and Workbook Events_en.srt
|
SRT
|
12.6 KB
|
|
|
002 Practical Examples of Message Box (Msgbox) in Excel VBA.mp4
|
MP4
|
23.2 MB
|
|
|
002 Practical Examples of Message Box (Msgbox) in Excel VBA_en.srt
|
SRT
|
4.7 KB
|
|
|
002 Practical Examples of Sub-Procedure and Function.mp4
|
MP4
|
41.4 MB
|
|
|
002 Practical Examples of Sub-Procedure and Function_en.srt
|
SRT
|
8.3 KB
|
|
|
002 Read and Write Emails in Outlook.mp4
|
MP4
|
49.8 MB
|
|
|
002 Read and Write Emails in Outlook_en.srt
|
SRT
|
7.2 KB
|
|
|
002 Read-and-Write-Outlook-Emails.xlsm
|
XLSM
|
23.6 KB
|
|
|
002 Understand about VBA Macros and why we need Macros.mp4
|
MP4
|
25.4 MB
|
|
|
002 Understand about VBA Macros and why we need Macros_en.srt
|
SRT
|
3.2 KB
|
|
|
002 What are you going to learn.mp4
|
MP4
|
28.4 MB
|
|
|
002 What are you going to learn_en.srt
|
SRT
|
3.7 KB
|
|
|
002 Working with Cells Introduction.mp4
|
MP4
|
18.8 MB
|
|
|
002 Working with Cells Introduction_en.srt
|
SRT
|
4.2 KB
|
|
|
002 Working-with-Cells.xlsm
|
XLSM
|
13 KB
|
|
|
003 Course Requisites.mp4
|
MP4
|
5.3 MB
|
|
|
003 Course Requisites_en.srt
|
SRT
|
1.4 KB
|
|
|
003 Date Functions Introduction (Part 2).mp4
|
MP4
|
67.8 MB
|
|
|
003 Date Functions Introduction (Part 2)_en.srt
|
SRT
|
12.1 KB
|
|
|
003 Date-Functions-Part-2.xlsm
|
XLSM
|
17.4 KB
|
|
|
003 Declaring and Assigning Values to Variables.mp4
|
MP4
|
28.8 MB
|
|
|
003 Declaring and Assigning Values to Variables_en.srt
|
SRT
|
7.6 KB
|
|
|
003 Employee-Data.xlsm
|
XLSM
|
20 KB
|
|
|
003 For Each Loop Introduction.mp4
|
MP4
|
11.3 MB
|
|
|
003 For Each Loop Introduction_en.srt
|
SRT
|
2.3 KB
|
|
|
003 For-Each.xlsm
|
XLSM
|
14.1 KB
|
|
|
003 Input-Box-Demo.xlsm
|
XLSM
|
12.9 KB
|
|
|
003 Introduction to Visual Basic Editor.mp4
|
MP4
|
18.5 MB
|
|
|
003 Introduction to Visual Basic Editor_en.srt
|
SRT
|
4.6 KB
|
|
|
003 List Files in a Folder.mp4
|
MP4
|
34.3 MB
|
|
|
003 List Files in a Folder_en.srt
|
SRT
|
4.8 KB
|
|
|
003 List-Files-in-Folder.xlsm
|
XLSM
|
17 KB
|
|
|
003 Nested If Introduction.mp4
|
MP4
|
27.4 MB
|
|
|
003 Nested If Introduction_en.srt
|
SRT
|
4.6 KB
|
|
|
003 Nested-If-Statements.xlsm
|
XLSM
|
15.5 KB
|
|
|
003 Practical Example of Userform.mp4
|
MP4
|
304.8 MB
|
|
|
003 Practical Example of Userform_en.srt
|
SRT
|
54.1 KB
|
|
|
003 Practical Examples of InputBox in Excel VBA.mp4
|
MP4
|
10 MB
|
|
|
003 Practical Examples of InputBox in Excel VBA_en.srt
|
SRT
|
3.1 KB
|
|
|
003 StrReverse Function Introduction.mp4
|
MP4
|
20.9 MB
|
|
|
003 StrReverse Function Introduction_en.srt
|
SRT
|
3.9 KB
|
|
|
003 StrReverse-Function.xlsm
|
XLSM
|
12.4 KB
|
|
|
003 String Operators Introduction.mp4
|
MP4
|
7 MB
|
|
|
003 String Operators Introduction_en.srt
|
SRT
|
1.3 KB
|
|
|
003 String-Operators.xlsm
|
XLSM
|
12.9 KB
|
|
|
003 Working with Cells in Excel VBA.mp4
|
MP4
|
26.8 MB
|
|
|
003 Working with Cells in Excel VBA_en.srt
|
SRT
|
6.1 KB
|
|
|
004 Folder Creation.mp4
|
MP4
|
52.6 MB
|
|
|
004 Folder Creation_en.srt
|
SRT
|
7.5 KB
|
|
|
004 Folder-Creator-Tool.xlsm
|
XLSM
|
31 KB
|
|
|
004 Practical Example of Date Functions in Excel VBA (Part 2).mp4
|
MP4
|
81.6 MB
|
|
|
004 Practical Example of Date Functions in Excel VBA (Part 2)_en.srt
|
SRT
|
11.3 KB
|
|
|
004 Practical Example of For Each Loop in Excel VBA.mp4
|
MP4
|
46.5 MB
|
|
|
004 Practical Example of For Each Loop in Excel VBA_en.srt
|
SRT
|
7.6 KB
|
|
|
004 Practical Example of Nested If Conditional Statement in Excel VBA.mp4
|
MP4
|
28 MB
|
|
|
004 Practical Example of Nested If Conditional Statement in Excel VBA_en.srt
|
SRT
|
6.3 KB
|
|
|
004 Practical Example of StrReverse Function in Excel VBA.mp4
|
MP4
|
26.2 MB
|
|
|
004 Practical Example of StrReverse Function in Excel VBA_en.srt
|
SRT
|
5.1 KB
|
|
|
004 Recording a Macro.mp4
|
MP4
|
30.2 MB
|
|
|
004 Recording a Macro_en.srt
|
SRT
|
4.6 KB
|
|
|
004 Setting Expectations.mp4
|
MP4
|
8.1 MB
|
|
|
004 Setting Expectations_en.srt
|
SRT
|
1.9 KB
|
|
|
004 String Operators in Excel VBA.mp4
|
MP4
|
8.8 MB
|
|
|
004 String Operators in Excel VBA_en.srt
|
SRT
|
2.4 KB
|
|
|
004 Working with Ranges Introduction.mp4
|
MP4
|
10.4 MB
|
|
|
004 Working with Ranges Introduction_en.srt
|
SRT
|
1.6 KB
|
|
|
004 Working-with-Ranges.xlsm
|
XLSM
|
14.5 KB
|
|
|
005 Comparison Operators Introduction.mp4
|
MP4
|
35.2 MB
|
|
|
005 Comparison Operators Introduction_en.srt
|
SRT
|
5.9 KB
|
|
|
005 Comparison-Operators.xlsm
|
XLSM
|
14.7 KB
|
|
|
005 Exit For Loop.mp4
|
MP4
|
34.9 MB
|
|
|
005 Exit For Loop_en.srt
|
SRT
|
5.4 KB
|
|
|
005 Exit-For.xlsm
|
XLSM
|
14.3 KB
|
|
|
005 LCase, UCase Function Introduction.mp4
|
MP4
|
6.9 MB
|
|
|
005 LCase, UCase Function Introduction_en.srt
|
SRT
|
1.2 KB
|
|
|
005 LCase-UCase-Functions.xlsm
|
XLSM
|
12.7 KB
|
|
|
005 Select Statement Introduction.mp4
|
MP4
|
15.2 MB
|
|
|
005 Select Statement Introduction_en.srt
|
SRT
|
2.9 KB
|
|
|
005 Select-Statements.xlsm
|
XLSM
|
15.6 KB
|
|
|
005 Splitting Data.mp4
|
MP4
|
107.8 MB
|
|
|
005 Splitting Data_en.srt
|
SRT
|
12.3 KB
|
|
|
005 Splitting-Data.xlsm
|
XLSM
|
22.2 KB
|
|
|
005 Working with Ranges in Excel VBA.mp4
|
MP4
|
43.8 MB
|
|
|
005 Working with Ranges in Excel VBA_en.srt
|
SRT
|
7.2 KB
|
|
|
006 Comparison Operators in Excel VBA.mp4
|
MP4
|
29.5 MB
|
|
|
006 Comparison Operators in Excel VBA_en.srt
|
SRT
|
6.7 KB
|
|
|
006 Data Reconciliation.mp4
|
MP4
|
75.9 MB
|
|
|
006 Data Reconciliation_en.srt
|
SRT
|
9.8 KB
|
|
|
006 Data-Reconciliation.xlsm
|
XLSM
|
22.8 KB
|
|
|
006 Practical Example of LCase and UCase Functions in Excel VBA.mp4
|
MP4
|
14.5 MB
|
|
|
006 Practical Example of LCase and UCase Functions in Excel VBA_en.srt
|
SRT
|
2.4 KB
|
|
|
006 Practical Example of Select Statement in Excel VBA.mp4
|
MP4
|
22.9 MB
|
|
|
006 Practical Example of Select Statement in Excel VBA_en.srt
|
SRT
|
4.5 KB
|
|
|
006 While Loop Introduction.mp4
|
MP4
|
24.9 MB
|
|
|
006 While Loop Introduction_en.srt
|
SRT
|
4.2 KB
|
|
|
006 While-Loop.xlsm
|
XLSM
|
15.2 KB
|
|
|
006 Working with Worksheets Introduction.mp4
|
MP4
|
9.9 MB
|
|
|
006 Working with Worksheets Introduction_en.srt
|
SRT
|
1.8 KB
|
|
|
006 Working-with-Worksheets.xlsm
|
XLSM
|
17.6 KB
|
|
|
007 Data Summary.mp4
|
MP4
|
52.8 MB
|
|
|
007 Data Summary_en.srt
|
SRT
|
8 KB
|
|
|
007 Data-Summary.xlsm
|
XLSM
|
25.2 KB
|
|
|
007 Left, Right, Mid Function Introduction.mp4
|
MP4
|
28.9 MB
|
|
|
007 Left, Right, Mid Function Introduction_en.srt
|
SRT
|
5.6 KB
|
|
|
007 Left-Right-Mid-Functions.xlsm
|
XLSM
|
12.3 KB
|
|
|
007 Logical Operators Introduction.mp4
|
MP4
|
38.9 MB
|
|
|
007 Logical Operators Introduction_en.srt
|
SRT
|
8.1 KB
|
|
|
007 Logical-Operators.xlsm
|
XLSM
|
16.2 KB
|
|
|
007 Practical Example of While Loop in Excel VBA.mp4
|
MP4
|
35.9 MB
|
|
|
007 Practical Example of While Loop in Excel VBA_en.srt
|
SRT
|
6.7 KB
|
|
|
007 Working with Worksheets in Excel VBA.mp4
|
MP4
|
37.8 MB
|
|
|
007 Working with Worksheets in Excel VBA_en.srt
|
SRT
|
7.3 KB
|
|
|
008 Do While Loop Introduction.mp4
|
MP4
|
27.9 MB
|
|
|
008 Do While Loop Introduction_en.srt
|
SRT
|
4.4 KB
|
|
|
008 Do-While-Loop.xlsm
|
XLSM
|
16.5 KB
|
|
|
008 Logical Operators in Excel VBA.mp4
|
MP4
|
27.2 MB
|
|
|
008 Logical Operators in Excel VBA_en.srt
|
SRT
|
6.1 KB
|
|
|
008 Practical Example of Left, Right and Mid Functions in Excel VBA.mp4
|
MP4
|
27.6 MB
|
|
|
008 Practical Example of Left, Right and Mid Functions in Excel VBA_en.srt
|
SRT
|
4.6 KB
|
|
|
008 Working with Workbooks Introduction.mp4
|
MP4
|
11 MB
|
|
|
008 Working with Workbooks Introduction_en.srt
|
SRT
|
2.4 KB
|
|
|
008 Working-with-Workbooks.xlsm
|
XLSM
|
12.5 KB
|
|
|
009 Practical Example of Do While Loop in Excel VBA.mp4
|
MP4
|
43 MB
|
|
|
009 Practical Example of Do While Loop in Excel VBA_en.srt
|
SRT
|
8 KB
|
|
|
009 Trim Function Introduction.mp4
|
MP4
|
7.3 MB
|
|
|
009 Trim Function Introduction_en.srt
|
SRT
|
1.6 KB
|
|
|
009 Trim-Function.xlsm
|
XLSM
|
12.7 KB
|
|
|
009 Working with Workbooks in Excel VBA.mp4
|
MP4
|
29.2 MB
|
|
|
009 Working with Workbooks in Excel VBA_en.srt
|
SRT
|
6.4 KB
|
|
|
010 Exit Do Loop.mp4
|
MP4
|
22.9 MB
|
|
|
010 Exit Do Loop_en.srt
|
SRT
|
4.4 KB
|
|
|
010 Exit-Do-Loop.xlsm
|
XLSM
|
14.4 KB
|
|
|
010 Practical Example of Using Trim Function in Excel VBA.mp4
|
MP4
|
16.8 MB
|
|
|
010 Practical Example of Using Trim Function in Excel VBA_en.srt
|
SRT
|
2.9 KB
|
|
|
010 Working with Application Object Introduction.mp4
|
MP4
|
4 MB
|
|
|
010 Working with Application Object Introduction_en.srt
|
SRT
|
921.6 B
|
|
|
010 Working-with-Application.xlsm
|
XLSM
|
11.5 KB
|
|
|
011 Len Function Introduction.mp4
|
MP4
|
4.4 MB
|
|
|
011 Len Function Introduction_en.srt
|
SRT
|
819.2 B
|
|
|
011 Len-Function.xlsm
|
XLSM
|
12.5 KB
|
|
|
011 Working with Application Object in Excel VBA.mp4
|
MP4
|
12 MB
|
|
|
011 Working with Application Object in Excel VBA_en.srt
|
SRT
|
3.3 KB
|
|
|
012 Practical Example of Len Function in Excel VBA.mp4
|
MP4
|
15.8 MB
|
|
|
012 Practical Example of Len Function in Excel VBA_en.srt
|
SRT
|
2.7 KB
|
|
|
013 Replace Function Introduction.mp4
|
MP4
|
18.2 MB
|
|
|
013 Replace Function Introduction_en.srt
|
SRT
|
3.6 KB
|
|
|
013 Replace-Function.xlsm
|
XLSM
|
12.9 KB
|
|
|
014 Practical Example of Replace Function in Excel VBA.mp4
|
MP4
|
28.6 MB
|
|
|
014 Practical Example of Replace Function in Excel VBA_en.srt
|
SRT
|
4.9 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
