Excel, Access, VBA, Training and Development Excel, Access, VBA, Training and Development
 

Toll Free:  855-618-0279

Introduction to VBA Using Microsoft Excel

Students will be learning the fundamental skills required to develop a complete Microsoft Excel spreadsheet application using Visual Basic for Applications (VBA).  This is an introduction to programming using VBA, so no prior programming experience is required.  If you are an experiencedExcel VBA Training Excel user looking to take it to the next level, this course is for you.

Topics include: user-defined functions, custom menus and toolbars, object-oriented programming, loops, events, arrays -- and much more.

Click here for a detailed course outline in PDF format.

Day 1 Day 2
  • Recording Macros
  • User-Defined Functions (UDF)
  • The Visual Basic Editor (VBE)
  • Understanding VBA
  • Writing Code
  • Using Variables
  • Excel Objects
  • Control Structures
  • Understanding Arrays
  • ActiveX Controls
  • Creating Custom Forms
  • Debugging
  • Error Handling
  • Conclusion

Expert Training

This course is taught by Steve Stricklen, an experienced trainer and application developer. He worked as a financial analyst for major corporations, banks, and financial institutions for over ten years before starting his company in 2001.  Since then he has developed countless Excel (and Access) applications for companies across the country.  If you want training from a real power-user, call or email us today.