Excel

VBA for Microsoft Excel

productive-solutions-microsoft-excel-vba-for-microsoft-excel-course-header

VBA for Microsoft Excel

Course Description

This course is for people who wish to improve their skills by using Visual Basic for Applications (VBA) to increase productivity by automation in Excel.

 

Performance Based Objectives

  • Record macros using the recorder and create an application using the recorder
  • Create user-defined functions and work with the VBA editor
  • Understand VBA concepts and features, create procedures and sub routines
  • Work with variables and Excel objects
  • Use standard programming techniques and concepts
  • Create and program custom forms

 

Course prerequisites

Participants will need to have attended the Microsoft Excel Advanced course or a working knowledge of the topics covered including recording Macros in Excel.

Course Features

  • Students
  • Max Students10
  • Duration2 day
  • Skill leveladvanced
  • LanguageEnglish
  • Re-take courseN/A

Instructor