Curriculum
- 13 Sections
- 37 Lessons
- 104 Weeks
Expand all sectionsCollapse all sections
- Introduction3
- Start Working with VBA and Macros7
- 3.1What are VBA and Macro?5 Minutes
- 3.2Example of few ready real files created using VBA & Macro8 Minutes
- 3.3Configuring Excel to start VBA and Macro2 Minutes
- 3.4Project 1 – Creating the first macro11 Minutes
- 3.5Running the macro clicking on a button4 Minutes
- 3.6Project 2 – Macro running by shortcut key4 Minutes
- 3.7Saving process of the Macro enabled file3 Minutes
- Visual Basic Editor (VBE) – Change the VBA Script5
- Various Visual Basic Concepts and Environments3
- Subroutine and Execution1
- Event and Execution1
- MessageBox and InputBox2
- Using UserForm in Excel3
- Managing Various Form Controls4
- Errors, Debugging and Error Handling4
- Complete Project to Create a Data Entry Form1
- User Defined Function (UDF)1
- Creating Add-ins2
