MS Excel VBA and Macro Training for Corporate
Details
Objective:
The two days comprehensive program is designed with lot of research and development to equip the participants with the VBA Features, object library, functions to work fast and smart. Participants can automate their tasks which is repetitive and also can design their own functions, tabs, add-ins etc. Ultimately they can make the impossible stuffs possible in excel through Excel VBA.
Our Training program is designed to help with these following aspects:
- MIS Reporting
- Dashboard Designing
- Professional template with Drop-down Menu.
- Data Crunching
- Business Intelligence models
Outline
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
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 User Forms
Utilising the toolbox
Using User Form 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 Pivot-Fields
Adding a procedure to a custom toolbar
Working with Charts
Creating Automated Charts
Creating Dynamic Charts
Creating Combo Charts
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
Demonstration of Tools
Search Engine, File Explorer, Consolidation tools, BI Model etc.
Apart from Advanced Excel , we do cater our training service on Professional PowerPoint, Excel VBA, MS Access with VBA, MS Project, Finance Modeling with Excel, Finance for Non-Finance etc. ...