Excel - Macros with VBA Programming

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

Location
Date
Duration

2 Days

Time (AWST)
Address
Participants
Total

Overview

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

Content

  • 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

Level - Intermediate
Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable.

Level - Intermediate
If you have used Microsoft Excel for some time and need to learn more, this Perth based training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.

This course is designed for professionals looking to improve their practical use of Microsoft Teams, an increasingly common tool for modern workplace collaboration.

Level - Fundamental
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs