Excel Macro Programming Level II

Length: 1 day
Software Version:  2007/2010
Prerequisites: Excel 2007 Macro Programming Level I
Target Student:  Take this course to develop a strong understanding of the Excel object model used in VBA. Learn advanced Variable concepts, exploit VBA tools and functions.

After completing this course, participants will be able to:

  • Developing custom Function in VBA

  • Using the Object Browser in the VBE

  • Declaring and scoping variables

  • Using Arrays

  • Understanding object variables and using the Set statement

  • Learn the features, benefits, differences and syntax of VBA's four primary decision structures

  • Understanding the scope of procedures and functions

  • Using loop structures including For Each - Next loops and four flavors of Do loops

  • Using VBA functions

  • Learn how to build an Add-In for Excel

 

Click here for course cost and dates

BACK