Excel - Macros with VBA Programming

This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.


2 Days



This course will introduce and extend VBA programming within Microsoft Excel to enable participants to create and manage complicated macros.


  • Understand the Visual Basic Editor (VBE)
  • Object oriented programming concepts
  • Work with cells
  • Work with basic variables and arrays
  • Interact with the user
  • Decision making
    • IF, CASE and LOOP statements
  • Error handling
  • Basic event handling.

Learning Outcomes

Participants should be able to:

  • Create and edit macros by writing VBA code in the VBE
  • Understand concepts of object oriented programming
  • Build user-defined functions in Excel
  • Use events to trigger VBA procedures.
Related Results
Excel - Advanced Functions

This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

PowerPoint - Create and Enhance Slides

This course provides you with the skills needed to create highly professional slides and presentations with Microsoft PowerPoint.

Microsoft-Power BI Desktop-Level 2

If you have attended Power BI Desktop - Level 1, this course will build on your existing knowledge and introduce you to more advanced DAX (Data Analysis Expressions). 

Excel - KPI Dashboards

If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.

Courses - Frequently Asked Questions

Get answers to common queries.