Details
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
Reviews
Be the first to write a review about this course.
Write a Review
Pioneer in providing advanced excel training, professional PowerPoint training, excel vba and macro training,MS-Office Training,MS Access Training, MS Project Training,Data Analysis & Visualisation, Finance modeling with excel and Finance for Non- Finance to corporate and individuals as well.
We are flexible in providing domain specific or vertical based advanced Excel training program like Excel for Sales & marketing, Hr, FInance and Hospitals. etc and bagged an excelent review from the patrons.
We are flexible in providing domain specific or vertical based advanced Excel training program like Excel for Sales & marketing, Hr, FInance and Hospitals. etc and bagged an excelent review from the patrons.
We also conduct Weekend Workshops on Advanced Excel, Professional PowerPoint and Excel VBA at Four Star business class hotels.
Besides We have customised Advanced Excel Training module for B-Schools, MBA Colleges and Universities, Insurance and Sales Domains, Hospitals and found to be very Impressive during our past.