This program is for high-end users who want to make the most of the power of Microsoft Excel. It introduces programming techniques and concepts such as variables, scoping, importing data, passing values and debug techniques. If you have experience with the macro recorder and introductory programming, you will benefit from this program.

Overview

This program provides instruction in the more advanced use of Excel Macros. It will take participants beyond our Excel - Macros with VBA Programming, and introduces techniques for high-end Excel users to better utilise the power of Excel.

Program Content

  • Understand the Excel Object Model
  • Use the Editor Toolbar
  • A deeper look at variables
  • Scope of variables, procedures and modules
  • Call other procedures
  • Parameter passing between procedures
  • Work with arrays
  • Work with different event types
  • Create more advanced functions (optional arguments)
  • Work with external data
  • Work with text files
  • Create better user forms
  • Code to operate user forms
  • Error trapping routines
  • Better debug techniques
  • Make Application Programming Interface (API) calls.

Learning Outcomes

Participants should be able to:

  • Have a deeper understanding of the Visual Basics Editor (VBE) environment
  • Work with variables
  • Understand scoping
  • Pass values between procedures
  • Import data from external sources
  • Create better user forms
  • Use debug techniques
  • Use other objects.
Program Number
937
Skill Level
Advanced
Duration
2 Days
Time
Dates
    Location
    AIM WA Floreat

    * Minimum numbers are required for program to proceed

    Make a Booking
    NOT YET AN
    AIM WA MEMBER?
    DISCOVER THE BENEFITS  

    Similar Programs