Microsoft Excel – Expert VBA

Course Summary

This half-day course is designed to assist those wishing to build further upon their knowledge of Microsoft Excel. Ideally you will have completed the ‘Advanced’ module or have a very good working knowledge of other Excel versions to begin with.

Our series of excel courses also includes Excel Beginners, Excel Intermediate and Excel Advanced.

Topics

  • Understand the concept of Microsoft Excel Visual Basic for application
  • Create a Macro using the Macro Recorder
  • Assign an Excel Macro to a Keyboard Shortcut
  • Create Excel Macros Manually
  • Understand the Visual Basic Editor
  • Create a New Macro using the Code Window
  • Assign a Macro to a Workbook or Worksheet Event
  • Understand Collections, Properties and Methods
  • Understand the concept of UserForms and Add a UserForm to an Excel Document
  • Use Index Numbers
  • Understand the concept of Variables and Identify the types of Variables
  • Understand dimensioning Variables and variable Scope
  • Create a Function Procedure
  • Understand Statements and Program Flow Control
  • Use the Call Statement; Use the With Statement; Use the If...Then Statement; Use the Select Case Statement; Use the Do...Loop Statement; Use Labels and Line Numbering; and Use the On Error Statement

Course at a Glance

  • Next Start Dates: New dates TBA
  • CPD Points: 4
  • Course Cost: £175.00
  • Course Length: 4 hours (09:00-13:00)

There are no dates currently available for this course, If you would like to register your interest please complete the form below:

Latest Articles



Latest from Twitter



Want to learn more? Sign up to our mailing list!



We will email you from time to time to update you on upcoming courses, events and conferences.