VBA Excel Course

In the VBA Excel course, you'll learn to automate tasks in Excel with macros and VBA code: cell and sheet operations, conditionals, loops, UserForms and events.

UX/UI design Backend development Digital marketing

Course program

12 topic 45 lesson
01 Introduction to VBA and the basics 4 lessons
  1. 1
    The Developer tab
  2. 2
    Recording macros (Macro Recorder)
  3. 3
    The VBA window and its submenus
  4. 4
    Introduction to writing VBA code
02 Working with cells 8 lessons
  1. 5
    Cell referencing
  2. 6
    Font
  3. 7
    Alignment
  4. 8
    Font color
  5. 9
    Background color
  6. 10
    The End statement
  7. 11
    The Offset function
  8. 12
    Copying and pasting (Copy, Paste)
03 Operations on columns and rows 3 lessons
  1. 13
    Operations on columns and rows
  2. 14
    The With block
  3. 15
    Using the With block for cell operations
04 Working with sheets 5 lessons
  1. 16
    Accessing worksheets (Sheets)
  2. 17
    Adding a sheet (Add)
  3. 18
    Hiding and showing sheets (Hide, Unhide)
  4. 19
    Protecting a sheet (Protect)
  5. 20
    The Count function
05 Working with workbooks and MsgBox 5 lessons
  1. 21
    Creating a workbook
  2. 22
    Opening, saving and closing a workbook (Open, Save, Close)
  3. 23
    Protecting a workbook (Protect)
  4. 24
    MsgBox
  5. 25
    InputBox
06 Conditional statements 4 lessons
  1. 26
    The If statement
  2. 27
    Else, ElseIf
  3. 28
    And, Or
  4. 29
    Select Case
07 Variables and loops 4 lessons
  1. 30
    Variables
  2. 31
    Arrays
  3. 32
    Sub and Function procedures, user-defined functions (UDFs)
  4. 33
    Introduction to loops
08 Types of loops 2 lessons
  1. 34
    For (Each) Next
  2. 35
    Do Loop (While/Until)
09 UserForms 3 lessons
  1. 36
    UserForm
  2. 37
    Using forms and running commands
  3. 38
    Working with other MS Office applications
10 Event-driven commands 2 lessons
  1. 39
    Event procedures
  2. 40
    Libraries
11 Errors and macro security 3 lessons
  1. 41
    Error handling (On Error)
  2. 42
    Debugging
  3. 43
    Macro security
12 Final project 2 lessons
  1. 44
    Automating a report: a macro project with UserForms, loops and events
  2. 45
    Final project presentation

Our instructors

Meet our experienced teachers!

  • Əhmədxan Həsəsnov — instructor

    Əhmədxan Həsəsnov

    VBA Excel Course

    Don't know where to start?

    Not sure where to start?

    Get free advice

    Fill in the details and we'll get in touch with you.

    +994

    Your data is used only to contact you.

    Contact us directly (+994 10) 234 65 56
    CourseVBA Excel Course
    • Address
    • 609 Jafar Jabbarli St., Baku / Globus Center

    • Social networks