Most Prominent Microsoft Excel Online Training Platform
  • Home
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
Powered by Create your own unique website with customizable templates.
  • Home