Excel VBA Syllabus Basic VBA 👉 Lesson 1 Excel Macro Tutorial — How to Write Macros in Excel & Use 👉 Lesson 2 VBA in Excel — What is Visual Basic for Applications, How to Use 👉 Lesson 3 VBA Variables, Data Types Definition & Explanation 👉 Lesson 4 VBA Comparison Operators — Not equal, Less than or Equal to 👉 Lesson 5 VBA Logical Operators — AND, OR, NOT 👉 Lesson 6 VBA IF else condition 👉 Lesson 7 VBA Loop 👉 Lesson 8 VBA custom filter 👉 Lesson 9 VBA file dialog 👉 Lesson 10 VBA worksheet function 👉 Lesson 11 VBA Projects 👉 Lesson 12 VBA Split function 👉 Lesson 13 VBA Active x and form controls 👉 Lesson 14 VBA Userform 👉 Lesson 15 VBA Text function (Example-Replace/Trim/Left/Right/mid/find etc) 👉 Lesson 16 VBA with external data base(Ms Access & SQL Server) 👉 Lesson 17 VBA with microsoft Outlook 👉 Lesson 18 VBA with microsoft Power point 👉 Lesson 19 VBA with microsoft Word 👉 Lesson 20 VBA with Pivot tables 👉 Lesson 21 VBA Interview questions. Advance VBA 👉 Lesson 22 VBA Array 👉 Lesson 23 VBA UDF function 👉 Lesson 24 VBA Dictonary 👉 Lesson 25 VBA Collection 👉 Lesson 26 VBA Error Handling 👉 Lesson 27 VBA Events 👉 Lesson 28 VBA crawling 👉 Lesson 29 VBA Projects 👉 Lesson 30 VBA Interview questions.