EXCEL VBA
Excel VBA (Visual Basic for Applications) is a powerful programming language within Microsoft Excel that allows users to automate tasks, create custom functions, and enhance spreadsheet functionality. By writing VBA code, users can streamline repetitive processes, develop user-defined forms, and build complex data manipulation routines, enhancing productivity and efficiency.
Overview
- Classes 40
- Duration 60 hours
- Skill level Beginners to Advance
- Mode Bengali/Hindi
- Students 10-15
- Assessments Yes
Course Description
This Excel VBA course teaches how to automate tasks, create custom functions, and streamline workflows using Visual Basic for Applications. Learn to develop macros, design user forms, and enhance spreadsheet capabilities for increased productivity and efficiency.
Certification
ISO MSME Certified Government Registered
Materials
- Software Installation
- Study Materials
SYLLABUS
-
Lesson 1: Macros/VBA
-
1. What are Macros?
-
2. What is VBA?
-
3. How to record macros?
-
4.How to run macros?
-
-
Lesson 2: VBA Editor
-
1. Modules
-
2. Procedures
-
3. Project Explore
-
4. Toolbars / Options
-
-
Lesson 3: Creating / Editing Code
-
1.Create Procedures
-
2.Subs
-
3.Comments
-
-
Lesson 4: Invoking Macros
-
1. Hot Keys
-
2. Quick Access Toolbar
-
3. Call Command
-
-
1.Stepping through code
-
2.Reset
-
3.Run
-
Lesson 6: Variables
-
1.Declarations
-
2. Option Explicit
-
3.Data Types
-
-
Lesson 7: Working with The Object Mode
-
1.Worksheets
-
2.Ranges: Rows, Columns, Cells
-
-
Lesson 8: Creating & Naming Objects
-
1.Naming conventions
-
2.Housekeeping
-
-
Lesson 9: Navigation / Selection Techniques
-
1.Formula R1C1 Reference Style
-
2.Offsets
-
3.Range Names
-
-
Lesson 10: Logic Statements
-
1.IF Statements
-
-
Lesson 11: Looping Statements
-
1.Do Loops
-
-
Lesson 12: Interactive Code
-
1.Input boxes
-
2.Message boxes
-
-
Lesson 13: Error Handler
-
1. Preventing fatal errors and crashes
-