Advanced Excel with VBA - With Hands-On Practice

This course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features.

Get Training from professional IT people who are specialized in Extreme Excel Programming, complex formulas, array formulas, graphs, pivots etc. Our philosophy is simple: we train learners in Real Time Standards, to make them capable of doing a job after the course.

We strongly believe that learning the advanced features of Microsoft Excel comes through hands on application and one-to-one interaction between the tutor and the tutee. This is why our courses are focused on the individual in contrast with standardised and generic group courses.

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with more advanced programming techniques.

Main syllabus
----------------------------------------------------------
--
This course will cover the following topics:

Using logical functions
Naming ranges
The IF function
Creating nested IF functions
AND and OR functions
Combining logical functions
Using COUNTIFS,SUMIFS, & AVERAGEIFS
Statistical functions
Date & Time functions
Text functions
Advanced functions
Exporting and Importing
Workbooks and worksheets collections
The Range object
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
Advanced VBA programming
Advanced VBA examples

After completing this course you will be able to:

Perform the most advanced calculations and functions,
Write Object Orientated Programming as practiced in Excel
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: 12 Hours
Fees: 10000/-
Website: http://virtualclass.ca1.biz/

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