Join Our Most Professional Telegram Group. Only Learning. No Nonsense. https://t.me/TheExcelism

Topic: Macros & VBA  I  Mode: Online LIVE  I  Date: ---  I  Time: --- I  Fees: INR 5,000/-

ENROLL

---

SYLLABUS:

Section 1: Understanding the Excel
1. File Types of Excel
2. Security Control in Excel
3. Understanding the Cell References

Section 2: Recording Macros
4. Understanding the Concept of SOP
5. Recording and Storing Macros
6. Relative Reference Macros
7. Interchangeability of Macros among files
8. Practical Case Studies

Section 3: Visual Basic for Applications (VBA)
9. Introduction to Visual Basic Editor (VBE)
10. Projects, Properties etc.
11. VB Color Guidelines
12. Object Model of Excel for VBA
13. Objects, Properties, Methods etc.

Section 4: Working with Excel in VBA
14. Code to Write in Cells
15. Reference to Ranges, Worksheets, Workbooks etc.
16. Concepts of Variable, Declaration, Scope etc.
17. Understanding the Data Types

 Section 5: Concepts in Coding
18. With End With Statements
19. For Each for Loops
20. If Statements
21. Select Case Statements
22. Concept of Looping
23. Usage of Functions
24. Message Box Vs Input Box
25. Debug of the Code

Section 6: User Defined Functions (UDF)
26. Function Procedures
27. Building User Defined Functions
28. Case Studies on UDF

Section 7: Advanced VBA
29. Working with Arrays
30. Working with Folders and other Files
31. Working with Pivot Tables of Excel
32. Worksheet and Workbook Events
33. Building the User Forms