Advanced Excel with Macros - With Hands-On Training

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

Microsoft Visual Basic for Applications (VBA, Macros) when usedwith Microsoft Excel can build powerful automated business tools quickly and minimum cost. If you sit in front of a computer screen all day creating reports in Microsoft Excel, you know the power of this software package. But if you aren't using macros yet, you don't know the half of it.

When you first learn Visual Basic for Applications, Excel built-in functions might seem like a faster way to do things. Puzzling out program structure and getting results to come out right takes longer than using quick and dirty shortcuts on the spreadsheet.

Main syllabus
----------------------------------------------------------
--
This course will cover the following topics:
Introduction to Excel Macros
Recording macros
Running macros
Selecting cells and ranges
Using Macros in Excel workbook
Managing Cells, Rows, and Columns using Excel Macros
Using Excel functions in Macros
Macro security
Some Sample Excel Macros

After completing this course you will be able to:

Write simple but useful Excel Macros
Become familiar with basic macro techniques for recording, writing, running, and maintaining macros
Automate Report Generation
Automate Chart creation

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: 10 Hours
Fees: 5000/-
Website: http://virtualclass.ca1.biz/

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