Training in Excel VBA – Advanced Course

Key Information

Duration: 1 Day days

Course Learning Skills: VBA 2013
Additional Material: Download Course Slides Link

Brief

We offer three one day Excel VBA courses to cover the three levels of Basic, Intermediate and Advanced. You can, if you wish, do all three over a three day period or combine any two over a two day period.

Also, you can mix and match modules from the three levels if you would prefer to tailor a course more suited to your needs.

Attendees

This course is for experienced users of Excel VBA looking to explore and utilise its more powerful features.

Prerequisites

Ideally each delegate should already be proficient in VBA and the manipulation of Excel objects. Those who have not done much VBA previously or would like a refresher are welcome to combine our intermediate course with this one over a two day period.

Benefits

Delegates will gain a broader understanding of advanced Excel VBA programming and be able to do each of the following:

  • Supplement the Excel object hierarchy with their own objects
  • Extend the Excel Add-In library with their own applications
  • Exchange data with external applications and files

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

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