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.

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.

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
• Lesson 5: Compiling Code
• 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