Advance Excel - Classroom training only for working professionals during weekend at Akurdi --------------------------------------------------------- Option 1) Online class via Skype Fees Rs: 6000/- (all inclusive) Duration: 5 to 6 weekends If you opt for Online session, It will be One on One session for which you should have good internet connection at home. Option 2) Class room session Fees Rs: 4900/- (all inclusive) Duration: 5 to 6 weekends Venu of Class: Akurdi, Pune If you opt for class room session, you have to come at our office in Akurdi, Pune during weekends.

Topics Covered

VBA Macro Classes/Advance Excel Vlookup/Hlookup Pivot Introduction to Visual Basic Editor 2010 Understanding Excel Objects Workbook, Worksheet Variables, Variable declaration and data-types in VBA (any version). Properties Methods Events Range Object Range Object Properties Range Object Methods Using conditional statement [IF] to work on Range data Using loops to manipulate data in Range Working with Collections Advantages of using collections Scenarios: To understand the use of collections Sub versus Function Programming Formulas into Worksheet Cells Using Worksheet Functions A1 Reference R1C1 Reference Handling VBA Error / Debug VBA code

Who should attend

Only Working professionals

Pre-requisites

Basic knowledge of excel

What you need to bring

Nothing"

Key Takeaways

Advance Excel