VBA Training By Industry Experts At Sibyl, Kammanahalli

Excel & Adv. VBA
Microsoft Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
The Windows version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA). Programming with VBA allows spreadsheet manipulation that is impossible with standard spreadsheet techniques. Programmers may write code directly using the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization environment. The user can implement numerical methods as well as automating tasks such as formatting or data organization in VBA and guide the calculation using any desired intermediate results reported back to the spreadsheet.
Excel
About The Excel
Toolbar
Formats in Excel
More………….
Excel With VBA
The advantages of VBA
An easy-to-use and versatile language
Integrated with off-the-shelf products
Minimizes development time and costs
More……………
Macros: the first step
Recording and executing macros
Limitations
Enhancing with VBA code
More…………...
Getting to Know the VBA Development Environment
The code design tools
Project Explorer
Help system
More……………
The debugging tools
Code stepping
Immediate Window
Breakpoints
More……………
Writing VBA Code
Event-driven programming
The role of events in Windows
How events are triggered
More…………..
Putting objects to work
Properties
Methods
Events
More…………..
Storing data in variables
How and when to declare variables
Selecting data types
Fixed and dynamic arrays
More……………...
Conditional branching
If...Then...Else
Select...Case
More……………
Looping through code
Do...Loop, While and Until
For...Next and For Each...Next
More………….
Building procedures
Creating Sub and Function procedures
Calling procedures
Passing arguments to procedures
More………….
Empowering VBA through the Application Object Models
Understanding object model structures
Exploring the hierarchy using the Object Browser and Help system referencing specific objects

More……………………

Training by Industry experts
Special Features:
• Online training (Live by trainers) available for working professionals
• Training on Individual Modules is also available.
• Project sessions on SDLC with every course
• PD sessions(personality development) with every course
• Recruitment programs

For Further Details

Contact –
SIBYL SOLUTIONS,#410, 5th 'A' Cross 2nd Block, HRBR Layout Kalyan Nagar,Bangalore-43
9008673522 / 9740783622 / 080 25421686