Course Introduction
Introduction to VBA
Data Types and Variables
Operators
-
12. Arithmetic Operators Introduction (4:03)
-
13. Arithmetic Operators in Excel VBA (6:24)
-
14. String Operators Introduction (1:15)
-
15. String Operators in Excel VBA (2:25)
-
16. Comparison Operators Introduction (5:08)
-
17. Comparison Operators in Excel VBA (7:17)
-
18. Logical Operators Introduction (6:34)
-
19. Logical Operators in Excel VBA (6:36)
-
Quiz 3: Operators
-
Assignment 3: Find Syntax and Logical Errors
Functions and Sub-Procedures
Msgbox and Inputbox
Excel Object Model
-
25. Excel Object Model (3:38)
-
26. Working with Cells Introduction (3:31)
-
27. Working with Cells in Excel VBA (6:08)
-
28. Working with Ranges Introduction (1:30)
-
29. Working with Ranges in Excel VBA (6:55)
-
30. Working with Worksheets Introduction (1:30)
-
31. Working with Worksheets in Excel VBA (6:41)
-
32. Working with Workbooks Introduction (2:04)
-
33. Working with Workbooks in Excel VBA (6:15)
-
34. Working with Application Object Introduction (0:46)
-
35. Working with Application Object in Excel VBA (3:10)
-
Quiz 6: Excel Object Model
-
Assignment 5: Calculate Sum and Average
Conditional Statements
-
36. If, If Else, If ElseIf Else Introduction (9:23)
-
37. Practical Example of If Conditional Statement in Excel VBA (4:01)
-
38. Nested If Introduction (4:13)
-
39. Practical Example of Nested If Conditional Statement in Excel VBA (6:27)
-
40. Select Statement Introduction (2:42)
-
41. Practical Example of Select Statement in Excel VBA (5:11)
-
Assignment 6: Color Names
Loops
-
42. For Loop Introduction (5:47)
-
43. Practical Example of For Loop in Excel VBA (6:15)
-
44. For Each Loop Introduction (2:02)
-
45. Practical Example of For Each Loop in Excel VBA (7:55)
-
46. Exit For Loop (4:37)
-
47. While Loop Introduction (3:45)
-
48. Practical Example of While Loop in Excel VBA (6:58)
-
49. Do While Loop Introduction (4:08)
-
50. Practical Example of Do While Loop in Excel VBA (8:57)
-
51. Exit Do Loop (3:33)
-
Quiz 7: Loops
-
Assignment 7: Check Holiday
String Functions in Excel VBA
-
52. Instr Function Introduction (3:43)
-
53. Practical Example of InStr Function in Excel VBA (6:51)
-
54. StrReverse Function Introduction (3:30)
-
55. Practical Example of StrReverse Function in Excel VBA (5:01)
-
56. LCase, UCase Function Introduction (1:05)
-
57. Practical Example of LCase and UCase Functions in Excel VBA (2:48)
-
58. Left, Right, Mid Function Introduction (4:16)
-
59. Practical Example of Left, Right and Mid Functions in Excel VBA (5:10)
-
60. Trim Function Introduction (1:21)
-
61. Practical Example of Using Trim Function in Excel VBA (3:05)
-
62. Len Function Introduction (0:43)
-
63. Practical Example of Len Function in Excel VBA (3:11)
-
64. Replace Function Introduction (2:51)
-
65. Practical Example of Replace Function in Excel VBA (4:30)
-
Quiz 8: String Functions
-
Assignment 8: String VBA Functions
Date Functions in Excel VBA
Events and Userforms
Practical Examples
VBA Tips
Productivity Tools
-
Tools List
-
1. Time and Motion Tracker
-
2. Outlook Email Management Tool
-
3. Random Sampling Tool
-
4. Outlook Bulk Email Tool
-
5. Excel Files and Sheets Consolidator
-
6. Duplicate Files Finder Tool
-
7. File Properties Tool
-
8. File Manager Tool
-
9. Duplicate Data Identifier
-
10. Employee Database
-
11. Folder Creator Tool
-
12. File Rename Tool
-
13. Outlook Work Allocation Tool
-
14. Work Allocation in Excel
ExcelSirJi Addin
Thank you
