We provide MS Excel VBA and Macro training for Corporate in Chennai, Mumbai ,Bengaluru, Pune, Ahmedabad, Kolkata, Hyderabad, Noida, New Delhi,
Excel VBA and macro training is designed for them who are the expert user of ms excel having the comprehensive knowledge about functions, features and formulae and would like to enhance their knowledge to the next level by automating their repetitive tasks or designing the new functions, add-ins, Dash Boards with drop-down menus and many more.
Excel VBA and macro training is designed for them who are the expert user of ms excel having the comprehensive knowledge about functions, features and formulae and would like to enhance their knowledge to the next level by automating their repetitive tasks or designing the new functions, add-ins, Dash Boards with drop-down menus and many more.
|
Level-1 (Intermediate) (16 Hrs / 2 days)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Introducing Objects Defining objects Examining the Excel object hierarchy Defining collections Utilising the object browser How to work with properties The with statement How to work with methods Building an event procedure Utilising Intrinsic Functions, Variables and Expressions Defining expressions and statements How to declare variables Determining data types Programming with variable scope Harnessing intrinsic functions Defining constants and using intrinsic constants Adding message boxes and using input boxes How to declare and use object variables Managing Program Execution Defining control-of-flow structures Using boolean expressions Working with the if...end if decision structures Working with the select case...end select structure Working with the do...loop structure Working with the for...next structure Working with the for each...next structure Restrictions for use of control-of-flow structures Harnessing Forms and Controls Defining UserForms Utilising the toolbox Using UserForm properties, events and methods Understanding controls Setting control properties in the properties window Using the label control Using the text box control Using the command button control Using the combo box control Using the frame control Using option button controls Using control appearance Determining the tab order Filling a control Increasing code to controls How to launch a form in code Using the PivotTable Object Defining PivotTables Making a PivotTable Using the PivotTable wizard method Using PivotFields Adding a procedure to a custom toolbar Debugging The Code Defining errors Working with debugging tools Determining breakpoints How to step through code Working with break mode during run mode Identifying the value of expressions Handling Errors Defining error handling Defining VBA's error trapping options Capturing errors with the on error statement Determining the error object Coding an error handling routine Using inline error handling |
Level- 2 ( Advanced) ( 16 Hrs / 2 days)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Further Excel Object Model The Range object The Current Region object Workbooks and worksheets collections Chart object List object Arrays Dynamic arrays Array optimisation Multidimensional arrays Arrays and objects Object Oriented Programming (OOP) Classes and objects creating new objects creating new classes Error handling Good programming techniques Recursive programming Using optional arguments Best Practice for Excel Programming Introduction Introducing Visual Basic for Applications Defining the development environment Using help Closing the VB editor Developing with Procedures and Functions Understanding and creating modules Defining procedures Creating a sub-procedure Calling procedures Utilising the immediate window to call procedures Making and naming a function procedure Working using the code editor Further Object Orientated Programming Destroying objects Default property and method Working with collections Advanced Procedures, parameters, variables Passing parameters by reference and by value Optional and default parameters Passing an array of arguments to a procedure Using enumerations User-defined Type Implicit and explicit conversions Linking with Office Connecting to other Office applications Working with other Office applications Importing from Access using ADO Understanding Active-X data objects The Connection string Manipulating data Macro Security How macro security works Digitally signing macros |
