Model Online / On-Site
Duration
Modules 9 modules

About the Course

Microsoft Excel Macros (VBA) Training teaches foundational and advanced Visual Basic for Applications (VBA) to participants who want to automate repetitive tasks and build custom solutions in Microsoft Office applications—primarily Excel. The course covers macro recording, VBA programming, UserForms, and real-world automation workflows.

Target Audience

  • Professionals with advanced Excel proficiency

  • Users looking to automate repetitive spreadsheet tasks

  • Analysts aiming to boost productivity in reporting and data processing

  • Employees who want to customize Microsoft Office applications

Learning Outcomes

  • Grasp the logic of macros and VBA programming

  • Record, edit, and manage Excel macros

  • Develop custom automation solutions and functions with VBA

  • Apply debugging, error handling, and code optimization techniques

  • Build professional VBA applications and UserForms that accelerate business workflows

Curriculum

Module 1 – Introduction to Macros & VBA

  • Introduction to Macros and Macro Types

  • Recording a Macro

  • Running Macros

  • Assigning Macros to Objects

  • Configuring Macro Options

  • Editing Macros

  • Deleting Macros

  • Macro Security Settings
Module 2 – The Visual Basic for Applications (VBA) Editor

  • Toolbars (Debug, Edit, Standard, UserForm)

  • Code Window

  • Properties Window

  • Project Explorer Window

  • Module, UserForm, and Class Concepts
Module 3 – Programming Structure

  • What Is Object-Oriented Programming?

  • Objects and Their Properties, Methods, and Events

  • Procedures and Procedure Types (Sub, Function)

  • Variables and Data Types

  • Variable Scope and Lifetime

  • Constants

  • Conditional Statements (If/Then/Else, Select Case)

  • Loop Structures (For/Next, For Each, Do/Loop)

  • The GoTo Statement
Module 4 – Programming Excel Objects

  • Excel Object Hierarchy (Application, Workbook, Sheet, Row, Column, Cell, Range)

  • Selecting Cells, Rows, and Columns

  • Counting Selected Rows, Columns, and Cells

  • Writing Formulas to Cells via VBA

  • Writing Values to Cells

  • Modifying Cell Formatting and Properties
Module 5 – Operators

  • Arithmetic Operators (^, *, /, \, +, –, &, Mod)

  • Comparison Operators (=, <>, <, >, <=, >=, Like, Is)

  • Logical Operators (Not, And, Or)
Module 6 – Error Handling

  • Error Handling Statements (On Error GoTo, On Error Resume Next)

  • Error Codes and Descriptions
Module 7 – Functions

  • Frequently Used Built-In VBA Functions

  • Creating User-Defined Functions (UDFs)

  • Passing Parameters to Function Procedures

  • Building Custom Purpose-Built Functions

  • Using UDFs Inside Excel Worksheets
Module 8 – Working with UserForms

  • Creating a UserForm

  • UserForm Object Properties

  • UserForm Object Events

  • Form Controls

  • Control Properties

  • Control Events
Module 9 – Practical VBA Applications

  • Creating Charts with Macros

  • Filtering and Sorting with Macros

  • Creating PivotTables with Macros

  • Building a Data Entry and Query Form with Macros

  • Working with MS Access Data from Excel VBA

  • Working with MS SQL Server Data from Excel VBA

Other Courses in This Category

  • Microsoft Excel Advanced – Expert Level Excel Expert Level

    Expert-level Microsoft Excel training covering array formulas, XLOOKUP, INDEX/MATCH, advanced PivotTables, Goal Seek, Solver, What-If Analysis, form controls, and Power Query.

    MS Office Corporate
    Live Course
    8 modules
    View
  • Microsoft Word, PowerPoint and Project for Business Professionals

    Microsoft Word, PowerPoint and Project for knowledge workers and project teams: long-form corporate document templates, Slide Master and data-driven executive decks, WBS, critical path (CPM) and resource scheduling.

    MS Office Corporate
    Live Course
    5 modules
    View
  • Microsoft Excel Fundamentals Basic Excel

    Foundational Microsoft Excel training covering interface navigation, cell and table formatting, worksheet management, conditional formatting, charts, and core formulas.

    MS Office Corporate, Individual
    Live Course
    9 modules
    View
  • Microsoft Excel Intermediate Intermediate Excel

    Intermediate Microsoft Excel training covering table management, advanced sorting and filtering, conditional formatting, VLOOKUP/HLOOKUP, and conditional functions (SUMIF, AVERAGEIF, COUNTIF).

    MS Office Corporate
    Live Course
    10 modules
    View
  • Microsoft Excel Advanced Advanced Excel

    Advanced Microsoft Excel training covering XLOOKUP, INDEX/MATCH, SUMIFS, database functions, data validation, PivotTables and PivotCharts, workbook security, and recorded macros.

    MS Office Corporate
    Live Course
    8 modules
    View
  • Microsoft Project Fundamentals Basic MS Project

    Foundational Microsoft Project training covering project scheduling, Work Breakdown Structure (WBS), task dependencies (FS, SS, FF), resource assignment, and Gantt Chart tracking.

    MS Office Corporate
    Live Course
    8 modules
    View

Get in touch