Training in Excel VBA – Advanced Course

Additional Material: Download Course Slides Link

Construction of an application

  • Overview of user forms
  • Overview of Workbook and Worksheet events
  • Application of dynamically populated List items
  • Use of form templates to dynamically manipulate form display contents at runtime
  • Assigning macros to ribbon tabs (toolbars)
  • Creation and maintenance of menus

Add-ins

  • Creation of add-in workbook
  • Application of ribbon tab to invoke and control an add-in
  • Application of Excel options window to activate an add-in

Class modules

  • Overview of class module versus program module
  • Creation of property and method procedures
  • Use and manipulation of class modules

Combining with external applications and files

  • Use of data from other Excel files
  • Use of data text files
  • Use of data databases via ODBC connections
  • Use of object hierarchies in other Microsoft Office applications
  • Data storage in the Windows registry
  • Use of external dynamic link libraries (DLL files)

Charts

  • Creation of a chart as a sheet or as an object within a sheet
  • Application of formats to different chart areas and items
  • Maintenance of data labels and values
  • Maintenance of key attributes

Pivot tables

    • Creation of a pivot table and definition of its source data

Manipulation of column and row headings

Manipulation of cell values

Application of grouping and filtering

Application of formats to different sections of a table

Register your interest in a Talk-IT Course

Course Interest

By sending this message you agree to the privacy policy.

Do a short survey to tell us what you think about training?

Click here to take the survey, it’ll only take a few minutes!

Scroll to Top