80. Data Reconciliation | EXCELSIRJI

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel VBA and Excel Macros Course

Course Introduction

01. Course Introduction (0:44)
02. What are you going to learn (3:14)
03. Course Requisites (1:15)
04. Setting Expectations (1:37)

Introduction to VBA

05. Understand about Programming Language, Application or Software (2:27)
06. Understand about VBA Macros and why we need Macros (2:43)
07. Introduction to Visual Basic Editor (3:48)
08. Recording a Macro (3:51)
Quiz 1: Introduction to VBA
Assignment 1: Recording a Macro

Data Types and Variables

09. Variables (2:39)
10. Data Types and Variables (12:45)
11. Declaring and Assigning Values to Variables (7:27)
Quiz 2: Variables
Assignment 2: Student's Average Marks

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

20. Function Definition, Calling a Function, Sub-Procedure Definition, Calling a Sub (9:45)
21. Practical Examples of Sub-Procedure and Function (8:00)
Quiz 4: Functions and Sub-Procedures
Assignment 4: Calculate Age

Msgbox and Inputbox

22. MsgBox and InputBox Introduction (4:52)
23. Practical Examples of Message Box (Msgbox) in Excel VBA (5:22)
24. Practical Examples of InputBox in Excel VBA (2:51)
Quiz 5: 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

66. Date Functions Introduction (Part 1) (6:44)
67. Practical Example of Date Functions in Excel VBA (Part 1) (12:24)
68. Date Functions Introduction (Part 2) (10:12)
69. Practical Example of Date Functions in Excel VBA (Part 2) (10:36)
Quiz 9: Date Functions
Assignment 9: Date Functions

Events and Userforms

70. Events Introduction (4:12)
71. Practical Example of Worksheet and Workbook Events (10:52)
72. Practical Example of Userform (47:48)
Quiz 10: Events and Userforms

Error Handling

73. Error Handling Introduction (6:06)
74. Practical Example of Debugging (8:24)

Practical Examples

75. How to Consolidate Excel Files using VBA (26:26)
76. Read and Write Emails in Outlook (5:47)
77. List Files in a Folder (3:57)
78. Folder Creation (5:28)
79. Splitting Data (10:07)
80. Data Reconciliation (7:38)
81. Data Summary (5:58)

VBA Tips

82. VBA Tips (8:47)

Thank you

83. Thank you (0:11)

Teach online with

80. Data Reconciliation

Download

Data Reconciliation.xlsm

Complete and Continue