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/-
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 |