Course Content
Module 1: Introduction to VBA
0/6
Video 1: What is VBA and why use it?
02:00
Video 2: Setting up your VBA environment
04:00
Video 3: Recording and editing simple macros (intro to basic programming techniques)
05:00
Video 4: Introduction to the Visual Basic Editor (VBE)
12:00
Video 5: Objects and properties in VBA (introducing object-oriented principles)
10:00
Video 6: Methods and events in VBA (event-driven programming concepts)
12:00
Module 2: VBA Fundamentals & Programming Techniques
0/9
Video 7: Variables and data types (emphasize different data types and their uses)
12:00
Video 8: Operators and expressions (cover arithmetic, comparison, logical operators)
08:00
Video 9: Control flow statements (if, else, loops) (in-depth explanation with branching and looping techniques)
09:00
Video 10: Subroutines and functions (modular programming concepts)
07:00
Video 11: Working with Ranges and Cells (efficient techniques for cell selection and manipulation)
05:00
Video 12: Formatting cells and worksheets with VBA (various formatting techniques through code)
09:00
Video 13: Functions & User-Defined Functions (built-in functions, creating custom functions for reusability)
08:00
Video 14: Debugging and error handling (common errors, debugging methods, robust error handling)
08:00
Video 15: Arrays and Collections (working with data structures for efficient processing)
09:00
Module 3: Advanced VBA Techniques
0/7
Video 16: Connecting to external data sources (techniques for accessing and manipulating external data)
08:00
Video 17: Modules and Classes (object-oriented programming concepts, code organization)
09:00
Video 18: Event-driven programming (advanced event handling, creating responsive macros)
11:00
Video 19: Error handling techniques (advanced error trapping and user-friendly error messages)
08:00
Video 20: Building user-friendly forms (MsgBox, InputBox functions, various form controls, data validation, user interaction)
11:00
Video 21: Advanced formatting and charting with VBA (creating dynamic charts, manipulating chart elements)
09:00
Video 22: VBA best practices and optimization (writing efficient, maintainable code)
06:00
Module 4: Practical Applications
0/8
Video 23: Automating data cleaning and analysis (applying various programming techniques for data tasks)
08:00
Video 24: Creating custom reports and dashboards (using charts, formatting, and VBA for informative displays)
08:00
Video 25: Building interactive data entry forms (advanced form controls, data validation, error handling)
10:00
Video 26: Automating specific Excel features (using VBA to interact with PivotTables, macros, etc.)
11:00
Video 27: Building add-ins to extend Excel functionality (creating custom tools with VBA)
09:00
Video 28: Working with Excel objects (advanced techniques for manipulating charts, shapes, etc.)
12:00
Video 29: VBA security considerations (writing secure macros, understanding potential risks)
08:00
Video 30: Tips and Tricks from the Instructor
08:00
Complete Excel VBA Bangla Course
Previous
Next
0% Complete