VBA Basic programming in Excel

This introductory VBA tutorial course for Excel will introduce you to the beginning concepts of VBA in the familiar Excel application.

Starting with the absolute basics, attendees will be writing useful scripts by the end of the course. This course includes classroom presentations and practical exercises.

Main syllabus
----------------------------------------------------------
--
Why Should I Learn Visual Basic for Applications ?

Often people who are skilled with spreadsheets shy away from learning Visual Basic for Applications. Excel carries a lot of built-in functionality so they don’t feel the need to learn programming. In fact, there are a number of reasons to get comfortable with writing macros in Visual Basic for Applications (VBA).

This course will cover the following topics:
Introduction about VBA
Writing and running scripts in VBA
Variables and Types in VBA
Flow Control in VBA
VBA operators in VBA
Control structures in VBA
File Management in VBA
Subroutines and Functions in VBA
String Functions in VBA
Using VBA in Excel workbook
Managing Cells, Rows, and Columns using VBA
managing Excel worksheets and Workbooks using VBA
Error handling in VBA
Some Sample VBA Scripts

After completing this course you will be able to:

Write simple but useful VBA Scripts
Become familiar with basic macro techniques for recording, writing, running, and maintaining macros
Understand key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros
Use VBA in manipulating Excel data in everyday use

Microsoft Office is used by nearly every employer in the world and the more extensive your skills with the application suite, the more attractive a candidate you are when applying for jobs. Visual Basic for Applications in Excel is the same macro language used in Word, Access or the other Office applications.

Once you know how to write macros in Excel, using macros in Word is just a matter of learning a few new object definitions. Even if you are happy with the company you work for, it never hurts to improve your job skills. The more you can do the more valuable you are to your boss. Besides, you never know what tomorrow will bring and an unexpected layoff could force you to start job hunting.

Extras:
- Written test
- Online test
- A Special CD with sample code/programs (Additional 100/-)
- Practice sessions
- Tips and Tricks for better productivity
- Common mistakes and how to avoid them
- Do's and Dont's
- Best practices

Duration: 30 Hours
Fees: 15000/-
Website: http://virtualclass.ca1.biz/

Timings:
1. Weekends (Saturday/Sunday)
2. Daily 2 hours