whatsapp +91-9870480053 | +91-9870480053 | info@itstechschool.com

Blog

vba-excel
23 Nov 2016

Advanced Excel | VBA excel training gurgaon

/
Posted By

VBA Excel Training Gurgaon : VBA stands for Visual Basic for Applications an event driven programming language that is now predominantly used with Microsoft office applications such as MS-Word,MS-Excel & MS-Access. We can use VBA in all office versions right from MS-Office 97 to MS-Office 2013 and also with any of the latest versions available. Among VBA, Excel VBA is the most popular one. The reason for using VBA is that we can build very powerful tools in Microsoft Excel using linear programming.

VBA Excel Training Gurgaon

Objectives

  • Create recorded macros in Excel
  • Use the macro recorder to create a variety of macros
  • Understand the Excel object model and VBA concepts
  • Work with the three main components of the VBA Editor window
  • Create command procedures
  • Create and use variables
  • Create and work with user-defined functions
  • Write code to manipulate Excel objects
  • Use a range of common programming techniques
  • Create a custom form complete with controls and event procedures
  • Code to drive a user form
  • Create procedures that start automatically
  • Write a variety of error handling routines

Pre-requisite

  • Participants should have programming background
  • All attendees must have prior knowledge of Excel 2010.

 

Leave a Reply